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

Multiple Custom Variable Selection.


We have a situation where we need to provide, during the variable selection screen, the ability for the user to select from a list of custom grouping of materials.


Material Group 1

Material Group 2



Material Group 10

Each of the above custom groups should already store, during the query design stage, a set of materials. The user will then simply select one of these groupings when she executes the report.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 12:14 AM

    Hi Dorothy

    You could create a hierarchy on the material characteristic and set up the 10 groupings, either directly in BI or load it from a flat file.

    Link: []

    Then in the query just create a hierarchy node variable on material and reference the hierarchy you have just created, at the prompt the user can then select the desired material grouping.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I am not aware of any way of having the hierarchy in the prompt expanded by defualt, however you can directly input the node you would like to restrict it to, just prefix the node id with +, if you had a naming standard like;

      Grouping Hierarchy - GRPHIER

      Group 1 - GRPHIER01

      Group 2 - GRPHIER02

      Group 3- GRPHIER03


      and defaulted it to the top level, ie GRPHIER, then if the users were familiar with the groups then they would just need to append the group number in the input, eg +GRPHIER01

      Hope this helps


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.