Ranet Olap-Drill Through

StatusIDPriorityType
Open36095MajorFeature
ProfileReply
syedjahangir SardarClient

Hello Team,

On click of the Data in the Ranet Olap grid we would like to show the data behind used for calculation. Please let me know if there is an option already exist or we have to capture the click event to show the data in the .net grid.Attached pic for your reference,

Replies

UserDescriptionPosted On
syedjahangir SardarClient

Sorry i did not mention the Ranet Olap version.It is the MVC one

Vyacheslav SemenkovAgent

We already have Drill Through functionality via context menu of table cell.

Anyway, we don't provide user option to configure onClick event of table cell. You will have to do it on your own.

syedjahangir SardarClient

Is there an option to override the drill through functionality ? That way we will customize the query ..

Vyacheslav SemenkovAgent

I'm afraid, there is no way to change it.

syedjahangir SardarClient

We already have Drill Through functionality via context menu of table cell.
Anyway, we don't provide user option to configure onClick event of table cell. You will have to do it on your own.

So what you are saying is identify the click event of table cell using Javascript ? we have explored completely and this is the only option pending.Once this is done we are planning to purchase the cloud one.

Vyacheslav SemenkovAgent

This will be extremely inconvinient to do it on client. But I think it's possible to do what you want by modifying server behaviour. You can override WebAPI method that is used to obtain Drill Through data. It accepts our query as request parameter. You will need to modify query the way you need.

If this solution is okay for you, I can provide you an example.

syedjahangir SardarClient

I believe this suits our need.Please provide the example

This reply has been deleted 2 weeks ago.
Vyacheslav SemenkovAgent

This might take some time. I'll send it to you as soon as possible. I believe, the worst case scenario is 12 am CET on monday.

syedjahangir SardarClient

Sure and Thank you .

Vyacheslav SemenkovAgent

Example is ready.

syedjahangir SardarClient

thanks Vyacheslav Semenkov for the example and your effort.i get this error when executing it with adventures work cube.Let me know what went wrong ?

Attached files:
syedjahangir SardarClient

OK i have got it .you are giving me the click info .below query gives detail on the date value and city .now With this data i have to pull out the detailed report as per my need.Is that right ?

DRILLTHROUGH SELECT( [Date].[Date].&[20050702], [Customer].[City].&[Abingdon]&[ENG], [Measures].[Order Count] ) ON 0 FROM [Adventure Works] CELL PROPERTIES BACK_COLOR , CELL_ORDINAL , FORE_COLOR , FONT_NAME , FONT_SIZE , FONT_FLAGS , FORMAT_STRING , VALUE , FORMATTED_VALUE , UPDATEABLE , ACTION_TYPE

Vyacheslav SemenkovAgent

We create drillthrough query based on clicked cell. You should modify it. Take a look at CustomDatasourceController.cs, it's where all the query modification should be.

Also, try refreshing browser cache for this page, seems like some changes are not applied in your application. Drillthrough query should not contain this part: "CELL PROPERTIES BACK_COLOR , CELL_ORDINAL , FORE_COLOR , FONT_NAME , FONT_SIZE , FONT_FLAGS , FORMAT_STRING , VALUE , FORMATTED_VALUE , UPDATEABLE , ACTION_TYPE"

Write US