locked
Extending Drill-To-Details RRS feed

  • Question

  • I’m using ProClarity 6.3 and I would like to do the following:

     

    1-    drill-to-detail on a calculated measure.

    2-     drill-to-detail on a reporting services or using reporting action on SSAS 2005.

    3-     add actions defined on the cube into the chart or grid context menu same as PerformancePoint context menu.

     

     

    Kindest Regards

    Sherif Isaac

     

    Sunday, September 21, 2008 12:56 PM

Answers

  • Sherif,

     

    Drill to detail on a calculated measure is not possible.  A calculated measure is a result of a calculation of one or more measures and the SSAS engine does not know how to go back and retrace the fact table lines used in the measures which are used in the calc measure. 

     

    Please see SQL Server Books Online for details on how to set up a drill to detail or Reporting Services action in SSAS.  ProClarity supports these actions and they will appear in the menu when set up properly. 

     

    I'll have to refer you to the PerformancePoint Server (PPS) team for question number three.  I'm not sure what the PPS context menu involves.  Again, ProClarity will fully support actions defined in SSAS.

     

    http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=517&SiteID=17

     

    Thanks,

     

    -Joey

    Monday, September 22, 2008 9:25 PM