on 05-28-2015 9:19 AM
Hi,
I need to create a report with few query filters. They have list of values. My requirement is that the lov for one prompts should depend on the values selected in the LOV of other prompts.
I am aware of cascading LOVs but I do not have any hierarchy. For example, there are students and courses, if student A is selected, only courses he is enrolled in, to be displayed in course prompt, in the other way, if course B is selected, only students with course B in student prompt.
The user is free to answer any prompt first. Help appreciated.
Thanks
Follow the steps:
1) Snaphot of table with data as required by you.
2)Now go to universe & create @prompt for student ID column.
3) apply the where condition for course object in universe
4) Save the universe and export the same.
5) Open the report drag the object with @prompt on report and create prompt for course object.
6) Now run the report you will get your desired output.
Thanks,
SB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Oh Thanks but i am unsure how to create a prompt in information design tool. I am using BO 4.1 SP5. Is it possible in this?
And if I have more than 2 such parameters how is it achievable? I actually have 6 such dependent parameters.. and user needs to be free to choose these parameters in the order he wishes and they are all optional. 😕
Thanks
Thanks, This is helpful I guess but I still won't be able to chose the parameter in any order while refreshing report. It still goes in the pre defined order ID -> Course -> Subject ...
User wants to be able chose course or subject or ID first... as he wishes each time he refreshes.. Any thoughts on this?
Thank You
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.