Ranet Olap-Drill Through

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

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.

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

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

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.

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.

I believe this suits our need.Please provide the example

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.

Sure and Thank you .

Example is ready.

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 ?

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

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"