I created a dashboard with some dimensional hierarchy. But on sharepoint 2010, it does not drill down automatically. I always have to right click, drill down to choose the dimension I need to drill down. But I already have the hierarchy set
up in the MS SQL analysis server 2008. When I do the same on proclarity desktop professional, it seems to work perfectly fine. I can just click on the graph and it drill to the next dimension in the hierarchy and so on. But on the sharepoint 2010 dashboard,
it does not seem to work.
I am using the report of type "Anaytics Chart" report type in the Sharepoint Designer.
Am I missing some step here? Thanks for your help and support.
View Complete Post