Can we dynamically include objects in a query via prompts?

building reports webintelligence
1

Hello All,
Is there a way to dynamically include objects in a query via prompts? I have some templates (webi reports) created for our users who are new to webi.The report has pre-defined calculations based on the objects(measures) in the query but users would like to use the report for different measures from the universe w/o having to change the calculations at the report level.
Any thoughts??

ajax7866 (BOB member since 2010-06-25)

2

You could build objects in the universe that prompt for a measure, and, based on the response, returns a different column.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Michael,
Can you pl share a sample object definition which can do this?

ajax7866 (BOB member since 2010-06-25)

4

Sure. This is sample code, and, depending on the database, your code may vary. This would go into the Select of the object.

CASE @prompt('Select an object','A',{'Object A','Object B'},mono,) WHEN 'Object A' THEN Table1.ColumnA WHEN 'Object B' THEN Table1.ColumnB END

MichaelWelter :vatican_city: (BOB member since 2002-08-08)