Drill-up and drill-down in report studio

[tradeex]

Hi -

I have a relational DB and the straight table with rollup 1 through 4. I want to create a drill-down/up in crosstab using 'Drill behavior. I looked and followed the instructions but the drill behavior did not work. I pulled rollup 1 into the report, created new query for rollup 2 to 4, selected drill-behavior and still nothing.

Does anyone have good instructions, step by step I can follow to create a drill up/drill down option rather than using javascript?

Thank you!

[Raghuvir]

Hi -

I have a relational DB and the straight table with rollup 1 through 4. I want to create a drill-down/up in crosstab using 'Drill behavior. I looked and followed the instructions but the drill behavior did not work. I pulled rollup 1 into the report, created new query for rollup 2 to 4, selected drill-behavior and still nothing.

Does anyone have good instructions, step by step I can follow to create a drill up/drill down option rather than using javascript?

Thank you!

Hi,

you would require a dimensional model to implement drill up and drill down feature.

Regards

[tradeex]

Sorry my mistake I do have dimension model and almost have it working but getting confused with the options of Drill behavior. I created a member set with the members I need to drill-down up, and started assigning drill behavior. I see rollup1  underlined and can see 'drill-down' when right clicking my mouse but doesn't do anything. Am I missing something under drill behavior advanced option? I am not familiar with all the drill down up behaviors (i.e. preserve, empty set, replace item etc).
thanks