on 2013 Dec 20 11:19 AM
Hello all,
I read many blogs for this option. I didn't understand how to Add 'ALL' as list of values for the objects in UDT/IDT?
Please let me know how to achieve it?
Regards,
Chandrakanth
Hello Chandra,
In UDT/IDT edit the object for which you want to add ALL Option and add a query using union like
SELECT DISTINCT
RESORT.resort
FROM RESORT
UNION
SELECT ‘-ALL-’
FROM DUAL;
Resort In (Selection) OR ALL in (Selection)
When a resort is selected
Bahamas Beach In Bahamas Beach OR ALL In Bahamas Beach
The first half of the expression is true
When ALL is selected
ALL in Resort List OR ALL in ALL
The second half of the expression is true for every possible resort
( @Select(Resort\Resort) IN @Prompt('Please select
Resort','A','ALL
Components\Resort',multi,constrained) OR
@Select(ALL Components\ALL String) IN @Prompt('Please select Resort','A','ALLComponents\Resort',multi,constrained) )
Hope this will help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes, understand 1st step: Have to edit LOV of the objects and need to write SQL like below
"SELECT DISTINCT
RESORT.resort
FROM RESORT
UNION
SELECT ‘-ALL-’
FROM DUAL;"
Here, I added "All" to the list of values....Okie.
When i select "all" from lov's, how sql will generate?
My doubt ( i selected "all" but how webi engine will treat as combination of all the values in LOV's)
I am unable to understand. Please can u elaborate?
Regards,
Chandrakanth
So for selection on top of All you will have to create a universe prompt using @prompt like below which will ignore the prompt if ALL is selected..
here is a example for a Year prompt that we use.. Note already we have a LOV Year which has the ALL value
And we have another object for year in time folder with where clause as below
Table.YEAR IN @Prompt('Enter Fiscal Year or ALL','A','Time\Year',Multi,Free) or 'ALL' IN @Prompt('Enter Fiscal Year or ALL','A','Time\Year',Multi,Free,Persistent,{'ALL'})
and select clause as
Table.YEAR
Now we have another prompt referring the already created object..
ALL' IN @Prompt('Enter Fiscal Year or ALL','A','Time\Year',Multi,Free,Persistent,{'ALL'}) or TABLE.YEAR IN @Prompt('Enter Fiscal Year or ALL','A','Time\Year',Multi,Free)
Once the prompt is created you can just use the prompt in your reports
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.