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!
Quote from: tradeex on 20 Jan 2015 03:52:31 AM
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
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