how to dispaly 2 objects related data in single prompt in webi or IDT

[rameshparchuri5]

Hi All,

my request bit tricky ,can you any one help one this logic in webi or IDT.

user request, in the prompt select any of the value selected,based on the data display in the report

Exam: I have two objects [state] [CAPITAL]

STATE --Karnataka Tamil Nadu Andra CAPITAL--- Hyderabad Bangalore Chennai

prompt display like :

Enter STATE or CAPITAL:

• Karnataka
• Tamil Nadu
• Andra
• Hyderabad
• Bangalore
• Chennai

once user select any one of the prompt value list ..based on that report will populate

how to implement list logic in IDT and Webi? anyone help

Thanks,

Ramesh

[mhmohammed]

Hi Ramesh,

You can use my blog post as well.

https://blogs.sap.com/2016/09/15/cascading-prompts-in-webi-similar-to-crystal-reports-not-cascading-...

Thanks,
Mahboob Mohammed

[former_member199945]

Hi,

Option 1-

In IDT try to create Custom Dimension by concatenating State and capital.

Use this object in webi prompts

It will display State with relevant capital values as Ex: karnataka - Bangalore etc.

Option 2 - Creating hierarchy for state and capital at IDT level -

Refe below for steps -

http://davidlai101.com/blog/2015/03/12/cascading-prompts-in-bobj-dashboards-and-webi/

Thanks