Skip to Content
0
Former Member
Mar 03, 2009 at 12:28 AM

Hierarchical Filter Item - Assignment

25 Views

Hi SDNers,

We are on BI 7.0 SP 16.

I am using Hierarchical Filter Web Item on Profit Center in our custom Web templates to allow user to change hierarchy levels after he has executed the report (for the first time), i.e. user has a selection screen variable on Profit Center Hierarchy (Auth Relevant), but after he ahs executed the report, there is also Hierarchy Filter Web item , which he can use to change the Hierarchy level.

My question :

1. Is it possible to assign a Hierarchy Node varaible(Authorization relevant) to Hierarchy Filter Web Item or it can only accept Charactersics (0PROFIT_CTR in my case) .

2. We have a requirement of Export to PDF and Export to excel, the problem is when user runs the report lets say for Hierarchy Level 4 (in original selection screen) , the Info field gets the value from Selection screen variable, but when user changes the selection to Hierarchy level 5 using Hierarchy Filter Web item later on from Report page ,this new selection does not reflect in the Info field and hence when we export to PDF or Excel the Data is for Hierarchy level 5, but the info field shows hierarchy level 4.

In Info field we are using "Variable Selection" on profit center variable to be displayed, but is there a way that the same info field element can also get the value from Hierarchy filter item , which is a dynamic selection after report execution.

Appreciate you help and response.

Thanks

TC