on 08-20-2010 5:37 AM
Hi Xcelcius gurus!!
I have a small scenario where I need some help.I have the following data in a table.
Codeline System
700 Q99
700 QFT
701 Y1Q
701 QRF
730 Q93
For this I have two combos,Combo1 and Combo2.
In Combo1, I need filtered values from Codeline and in Combo2, I need the corresponding Systems(based on selections of Combo1). Till here, I have suceeded. Now, in Combo1, I need another entry to be appended called "All". On selecting 'All', Combo2 should load all the entries of the column 'System'.
I do not wish to add the ALL in Column and other entries in System
How do we do this?
Edited by: Shashidhar N Garimella on Aug 20, 2010 6:46 AM
Hi Sashidhar,
Codeline System
700 Q99
700 QFT
701 Y1Q
701 QRF
730 Q93
I presume that by filtering the Characteristics Codeline, System, you may have to work with Keyfigure.
For that you must have a total keyfigure for ALL codelines logically as shown below.
Codeline System Keyfigure
All All 48
700 Q99 05
700 QFT 10
701 Y1Q 10
701 QRF 12
730 Q93 11
When you have selected ALL in codeline, there is no need of individual entry in System. Isnt it.
Please explore the possibility of using "Filter" component which may be of very much useful in such scenario.
Correct me if i misunderstood your requirement.
With best wishes
BaaRaa.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Baskar,
Thanks for the info.However, there is yet another constraint here.
I have this data in an excel sheet.So i prefer to fetch data directly from Excel only than to fetch data from BW.
So, therefore, I may not want to use the KeyFigures or Characteristics here.
Please assume that the above data existed statically inside the Excel Sheet of the dashboard(XLF) file.
Regards,
Shashi
Hi Parvarthaneni,
That is exactly what my point is. I am not getting data from BW/BI. All the information required for creating this dashboard
is already in the form of Excel. My project is to develop a dashboard with this information only. And, I am struck at the the problem described. In my context , considering BW/BI is not at all required as my entire source data is present in worksheet form.
Regards,
Shashi
Edited by: Shashidhar N Garimella on Sep 27, 2010 10:00 AM
Yes Sathish,
I can create a dashboard with the Excel data currently. In fact, I have almost completed preparing the dashboard.That is not what the problem is about.In process dashboard making , I am stuck at a point (posted in the description of this thread). This is where I need help. Kindly go through the problem description (first post in the thread) and let me know if you got doubts..
Regards,
Shashi
Hi,
Since you dont want to add "ALL" How do you think you are going to get the data ?? ..I have done some dashboard's for a major client ,we do have this functionality "ALL"
Use of "ALL" To return summarized info or to show other enteries in that column.I generally use a .aspx code for this and then trigger the same an XML Data Button so that the data interaction is dynamic and all future changes will be seen here on the dashboard.
Can you please sent me the Excel data let me do this... parvathaneni.satish at G
Hi mini,
Have your tried using a LIST BUILDER(If screen space is not a constraint) or CHECK BOX. However, if you really want to know about multi-select option in combo please go through the following link.
http://myxcelsius.com/2010/08/31/multi-select-combo-box-xcelsius/
Hope it helps..
HI Mini Patnaik...
We have a custom add-on component that would be a perfect fit for your requirement - it has multi-select capability with the All option also. Please
check the following link.
Regrads,
P.Gowri
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.