Drill Up/Down in FM

[sram007]

Hi ,
I have created a package using  Adventureworks [SQL Server] DB.
But when i am using this in Report Studio, The Drill up/Drill Down is not workin but this option was enabled in Report Studio,
Can any one please tell me how to enable Drill Up/Down in FM ?
Regards,
Ram

[MFGF]

Hi,

Drill down/up will not be enabled if your are modelling and publishing only Query Subjects and Query Items.  To get this ability, you will need to define dimensional structures (Regular Dimensions and Measure Dimensions) in FM and include these in your package.  If you then base your report off these, you will be able to drill down/up the hierarchies you defined in each Regular Dimension.

Regards,

MF.

[sram007]

Hi MF,
Thanks for your Reply dude,
i have few more questions,
1. How can i create Hierarchies  in FM ?
2. How can i convert this package [After creating Hierarchies] as cube in FM, Please tell me the option where it is?
Please guide me..

Regards,
Ram

[MFGF]

Hi,

Defining a hierarchy is part of the process of setting up each Regular Dimension in FM.  If you have never done this before, take a look at the FM user guide - it has lots of good information on how to set up FM objects like this.

Once you have defined your Regular Dimensions and Measure Dimensions in FM, add these to your package, then re-publish.  Once this is done, any existing reports will need to be modified to use data from the regular dimensions and measure dimensions (rather than the original query subjects) if you want them to drill down/up.