While running the query at the report I have a scenario where I need to hard code the Line Number and activity Number and give user only to select business name and measure name
And in the report all the Measures Pertaining to that filtering should display.
In Cascading prompt all the levels will be prompts for user,
Is their a way where i have possibilty to set the first two level values by me and give user only to select from LOV for the third level ie “businessname” and fourth level" Measure name"
I Need to hard code line and activity As we have 3 activity level and 5 line level reports.so the problem is I cant hard code the LOV value for activity and line at universe level as these values keep changing for the different versions of the reports
Try creating objects in the Universe for the fields you want to hard code.If you already have them then associate a LOV to them and ful filters in the query and select the LOV you want to hard code.
Create the Cascading LOV for the objects you want the user to pick and set a prompt on that…
I am not sure you understand how cascading prompts work. When you set them up in the universe, only the last item is actually added to the query. The other prompts that come previously are only used to limit the list of values for choices. So if you have a cascading prompt on Measure Name > Business Name > Line Number > Activity Number then only account number is applied as a condition on the report.
You would have to build a different cascading prompt for Business Name that starts with Measure Name and then you can hard-code the other conditions as needed.
Try it out… use your cascading prompt and then look at the SQL generated and executed by Web Intelligence.
(BOB member since 2006-12-12)