Drill Up/Drill Down

[tjohnston@gpworldwide.com]

Is it true that you can only use the Drill Up/Down feature in Report Studio if you are using dimensions in FM?  We have not created any cubes so far but plan to down the road.  Quite frankly, I find the prospects of doing this daunting but I'm hoping that with some additional training, this will change.  Any advise you can provide in this area would be greatly appreciated.

Thanks as always!
Terri

[Gollapudi]

Hi,

Yes it true, we cant Drill-up and Drill-down the data untill unless its a Dimentional package, by default we will get Dimentional package if the Data Source is a Cube, if your Database is Relational, then you have to create a Dimentional Model in your Frame Work Manager.

Thanks,
Gollapudi.

[Universe09]

Hi

I also would like to ask some questions about drill up/drill down, is it possible to apply this feature in the measure area of a crosstab table?

Thanks!

[Gollapudi]

Hi TerriJ,

Drill-up/Drill-down will not work with measure cells, coz its not defined in a Hierarchy format, its just like a data item, and you can Drill-up/Drill-down any thing which is defined in a Hierarchy format, lets say if your measure defined in a Hierarchy format like Quantity in 1st Level and Revenue in lower Level initially your measure will show Quantity and if you drill down it will show you Revenue.

Thanks,
Gollapudi.