I am using 3.1 version of Business Objects.
A new feature allows you to create optional prompts at reporting level.
However I am really struggling to create optional prompts at Universe level for example the syntax at reporting level uses
@prompt('Enter value(s) for Fac Account:','A','Financial Account\Fac Account',Multi,Free,Not_Persistent,,User:0,optional)
however when trying to create the same in the universe it errors.
Can anyone help with this, it will be greatly appreciated
It may not be ideal, but have one class with prompts attached and a duplicated class without the prompts attached. With security you can show and hide the appropriate classes from various user groupsā¦
I have studied and tried that exercise which you have mentioned. In that excersie I am being able to see the cascading prompts, but data is not filtered as per the values i selected. Report filters the data based on only last parameter, apper like only lsat parameter is being part of SQL generated.
How I can achieve and put all the prompt values in where caluse of SQL or you can say How can I achieve the results based on my selection.
That is how it works, unfortunately: A cascading prompt will not translate into a cascading condition.
Your last value selected in the cascading prompt will have to be globally unique (think: primary key). For example the final selection of āRomeā as a city will not work, as there are many cities by the name of Rome worldwide.
As Andreas says, thatās the way it works. The ācascadeā function conditions are only applied to the list of values selections, they do not appear in the final SQL. If you do not have a unique value as a final selection (as Andreas mentioned, āRomeā as a city is hardly unique) then you will not get the query results you desire.
One alternative that I have used is to concatenate the selections through the cascade. So my initial selection would be Country, followed by Country + State, and finally Country + State + City. In that way the selection becomes USA + Texas + Rome or Italy + Central Italy + Rome which would be unique.
Please advise how to implement this, is this should be at database level or do need to concatinate at BO level. How to concatenate the user entered prompt values ?
You make the objects in the universe, and build your cascading LOV off of the concatenated objects. I covered how to do this - including how to get āALLā as an option - in the āNinjaā series of presentations that I did at a conference several years back. I donāt remember if it was Part 1 or Part 2 but both are available from my blog, which is linked in my signature.