Using a prompt at the universe level 1

[anuktac]

I am new to Business Objects and I am designing a universe in which i have to prompt the user for a date & category every time he tries to run a report from this universe. Date and category are dimension objects. The user need not select date & category in the query panel while running the report. He should get the prompt even if those columns do not appear in the report.
How can I do this in Business Objects?

 

[rjback]

I believe you can create a 'filter' object in the Universe to be dragged into a report, without necessarily choosing objects in the select part of the report.

As to doing this automatically, no idea.

 

[PAULSGS]

You have to click on the line representing the join between two tables to use the edit joint properties dialogue box to add a condition to that pre-existing join


So you default join might be

TableA.col1 = TableB.col2

you have to add something like this

And TimeDimension.Col = @variable('Enter Date Dimension Value') And CategoryDimension.Col = @variable('Enter Category Dimension Value')

You must make sure that you add these join conditions to an existing join that is guaranteed to be used.

For belt & braces you could add these conditions to other joins, and as long as the literal text string is the same, the prompt will appear only once