SSAS - Custom drill through

Here I would like to give one of the very useful tip in SSAS cube drill through report. One of my client required to have specific order of the fields in the report. Normally drill through report in cube comes as per the order of dimension selected.

This can be achieved using Analysis Service Stored Procedure (ASSP). Please visit http://asstoredprocedures.codeplex.com/ for more details.


Now download and register the DLL. steps you can find from the below link.

http://asstoredprocedures.codeplex.com/wikipage?title=Installation%20Instructions

Here I will demonstrate how to make use of ASSP to get the custom drill through.

Once you have installed, it appears under Assemblies folder of solution explorer.



Fig 0.1




























Now go to Action tab of the cube and create new action
Fig 0.2
Provide name to the action as per the project standard, here I have given as Custom Drill Through.
Target type property decides when this drill through  report should appear, for this demo I have selected as Cells
Now in the Action expression  window write the code as shown in Fig 0.3. For custom drill through use the ASSP procedure GetCustomDrillThroughMDX.
Compliance is the dimension name and so the code will be like NAME([$Dimension].[Dimension Property])


Fig 0.3

Comments

  1. IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. A IEEE Domain project Final Year Projects for CSE system development life cycle is essentially a phased project model that defines the organizational constraints of a large-scale systems project.

    IT Company Employess Productivity usually increases when a company implements corporate training courses on latest technologies.
    corporate training in chennai
    It Companies need of Corporate training programme arises due to improvement in technology, need for getting better performance or as part of professional development. corporate training companies in chennai Corporate Training refers to a system of professional development activities provided to educate employees.
    corporate training companies in india

    ReplyDelete

Post a Comment

Popular posts from this blog

Hadoop - Hive - Load data from csv/xls files

Microsoft BI Implementation - Cube back up and restore using XMLA command