Do contexts in formulas work with drill-down?

building reports webintelligence
1

Hi all,

I have a report that uses contexts to total an amount for a given row (I use fields from two universes with merged dimensions). If there’s a dimension that I want to drill down on for a given row, will the amount automatically inherit the new context and display properly?

In other words, if I have an amount field that uses “Country” as a context, since the report uses Country in the row, if I drill down on “Country” to “State”, will the amount automatically adjust? I have tried this and it doesn’t work for me - I get a context error, so I thought I’d check to see if it was supposed to work in the first place. If it should, please let me know how things should be set up.

Thanks.

Robin

bobonita (BOB member since 2009-08-06)

2

Does anyone have any suggestions that might point me in the right direction on this, even if you don’t have the complete answer?

Thanks very much!!

Robin

bobonita (BOB member since 2009-08-06)