Webi Hyperlink - Inheriting Prompts

[Former Member]

*I'm working in BO 3*

I'm working on setting up my first hyperlinked webi documents. However, I've run in to two snags. My parent webi document has a set of 6 prompts that the users must select upon refreshing. So, when I create the hyperlink, I can easily enough select which variable to pass on to the child document (GL Account), however the prompts that were selected at the time of refreshing are not being inheritted to the child document. What do I need to do to pass these on?

The second issue (which may be related), is that one of the prompts of the parent webi document is a hierarchical prompt of our profit centers and the businesses they align to. How can I pass on a prompt to the child document that may be varying at which level of the hierarchy the user is at? Our hierarchy goes from Levels 1-5.

[Former Member]

Hi,

Create 5 prompts in child report like

Hierarchy1Object = 'Select Level'

Or

Hierarchy2Object = 'Select Level'

Or

Hierarchy3Object = 'Select Level'

Or

Hierarchy4Object = 'Select Level'

Or

Hierarchy5Object = 'Select Level'

And from the parent report pass the 'Select Level' hierarchy value to child report.

Edit: Pass drillfilter value from parent to child in hyperlink

Ex:

+"&lsSSelect Level="+[DrillFilterVar]

DrillFilterVar=DrillFilters([HierarchyObject])

[Former Member]

I'm not sure I fully understand the drillfilter piece. The hierarchy selection is made at the initial query prompt. Within the query/universe, each level of the hierarchy is it's own dimension, i.e. [L01 Profit Center], [L02 Profit Center], [L03 Profit Center]. How would I create the DrillFilter variable using those? There's no drill done within the webi report, it's all done at the prompt prior to the report.

[Former Member]

Hi,
Just for example consider 5 level hierarchy as

Country, State, City, Area, Avenue

now catch the userresponse value using [UR Objects=User Response derived variables EX: URState=userresponse("Select State") ]

HierarchyObjVar=If(IsNull([URAvenue]);If(IsNull([URArea]);If(IsNull([URCity]);If(IsNull([URState]);[URCountry];[URState]);[URCity]);[URArea]);[URAvenue])

In your hyperlink include this to pass the hierarchy value to child report -> lsSSelect Level=[HierarchyObjVar]

And child report will have the following filters

Country=Select Level or
State=Select Level or
City=Select Level or
Area=Select Level or
Avenue=Select Level