Skip to Content
author's profile photo Former Member
Former Member

Webi Hyperlink - Inheriting Prompts

*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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2014 at 06:29 PM

    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])

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.