on 01-20-2009 4:20 PM
Hello,
I have a scenario, where I need to display "ALL" data in the Combobox or filter componenet in a dasboard. Xcelsisus dod not have an ability to aggregate and display the data. Thus I was told that that in the Universe, one could set the where clause by the hardcoded word "ALL' , and do not include in where clause. How does one achieve this functionality at the backend to reflect the "ALL" condition in the combobox in Xcelsius.
Thanks
AP
I suggest you create an optional filter in your query.
The in you Excel spreadsheet you have to create 2 columns like this:
- First column contains displayed values as following:
- ALL
- Caption 1
- Caption 2
etc
- Second column contains values that will be sent to the database (you can use in that case index awareness in needed):
-
- Key 1
- Key 2
etc
Notice that the first value is equal to null and will be interpreted as an optional answer to the prompt.
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
So in my Universe, I have 3 dimensions objects
1. State
2. Premium Tye
3. Year
State values hardcoded in Excel are:
'ALL',
'California'
'Delaware'
'Maine'
Thus in the WHERE CLaUSE of the State object dimension what should my sql statement be formed.
The Best Practices document says
Product =@Variable('product') or @variable('Product') = 'ALL'
Do you substitute 'produc' with State or the values of State like California, Delaware etc
Thanks
---
Hello,
In my Xcelsius dashboard the user can select values for the 3 dimensions (State, LOB, Agency), they also have the option of defining 'ALL' values.
I looked at the best practices document which asks to perform a Universe filter on each of the dimensions.
eg.) Product_Col = @Variable('Product') or @Variable('Product') = 'ALL'.
What is the values column or 'Product' going to be. Do I also set @prompt filters in the dimensions.
Thnks
Abhi
Thanks to All,
In my scnerio I have Five ComboBox, eg Years,Months,Account Type,Premise,Billing, in All five Combobox our requirements is all dimentions in Combobox All labels eg. Jan.Feb,March, April......cont. and All labels of month
Plz help me regarding this i m using Xcelsius 2011 sp6 data connect through Excel Sheeets,
if any body have .xlf file like this Case plz share or send me at, m_shafiq08@yahoo.com
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.