Cascading Prompts and Delegate search Options in Information Design tool

[former_member223477]

Hi Friends,

  Do BO 4.0 supports Cascading Prompts and Delegate Search Options in Information Design Tool? If 'Yes', could you please suggest the way to do the same?

Many Thanks,

Krishna.

[Former Member]

Hi Krishna,

Yes BI4.0 IDT supports Cascading Prompts.

Please find the below example steps for creating cascading prompts in Information Design Tool for efashion unx universe.

1. Convert eFashion.unv to UNX file in IDT 

2. Add a predefined condition (Filter) at the universe level for the week objects using @Prompt function:

@select(Time period\Month) IN (@prompt('Enter Week:','N','Time period\Week',Multi,Free))

3. Create list of value based on Business Layer in 'Parameters and List of values' in IDT

• Example: L1 - which uses the Month object in result pane and Filter in filter pane

4. Create another list as L2- which uses Quarter in the result pane and Month in filter pane as optional prompt

5. Create another list as L3- which uses Year in the result object pane and quarter in filter pane as optional prompt

6. Now go to Business layer and associate the above created list of values with objects

7. Associate Year-> L3, Quarter->L2, Month-> L1

8. Now go to Queries Tab in business layer and create a query using Year, Quarter, Month, Sales revenue and select Year as an optional prompt in filter pane

9. Run the query and we can see the Cascading Prompts are working properly

Hope the above information helps you in creating cascading prompts in IDT

In case if you need steps for creating Cascading list of values, here are the steps:

1. Open an existing business layer in IDT 
2. Create a “List Of Values Based On a Business Layer Objects” 
3. Select the option  “List Of Values Based On a Custom Hierarchy” 
4. From the LOV pane, Add the required Dimension objects to the hierarchical LOV 
5. Assign the created LOV to the object definition in the Business Layer >Advanced tab

Thank you

Hyder

[Former Member]

Hi Hyder,

Thank you for sharing the detailed steps.

Testing the Query in the IDT is a success(cascading works).

But when I run the WebI report based on these objects, cascading doesn't work.

Is this a bug with WebI and any service pack need to be applied.

Appreciate your help on this if this - working in IDT and not in WebI.

Regards