Performing filters in Xcelsius

[Former Member]

Hi, I need help.

I need to build a dashboard that has approximately 7 filters. These filters determine how the components of 6 flaps present the data.

We know that many filters using Xcelsius is not recommended due to performance. Because of this, I am studying ways to build the dashboard so that it has usability for users.

I thought of the following solutions:

1 - The user selects the data from all filters, click send and then choose the tab, choose the tab when he wanted to see the filters which were selected and components with charge data. I think so I share the load of queries to the dashboard so do not be slow.

2 - Working with OpenDoc - Pass the parameters of the filters chosen in Xcelsius and load the graphics on Web Intelligence, that is, create a dashboard in Infoview with Xcelsius and Web Intelligence.

3 - Divide the dashboard in more than a flash file, also using the passed parameters.

You use what type of solution to this problem?

For this amount of data you use QaaWS or Live Office?

Thank you.

Fadrieli.

Edited by: Fadrieli on Dec 9, 2011 12:39 PM

[Former Member]

Hi,

You are integrating, xcelsius to webi.

so go for Live office Connection.

The filter component is powerful. It will sort through your lists and find the right value to display. You can then use this returned value for other components or by itself as a lookup feature for your dashboard.

The filter is not a good tool for passing multiple parameters back to QaaWS. You would use separate combo boxes for that (one for each list), combined with a Submit button. I will cover this soon in another tutorial.

The Filter component can present a large amount of data and can be used to create a selector with up to ten Combo Box fields.

When selections are made on the Filter component, the corresponding data is inserted in the spreadsheet and can be used as source data for a chart component.

http://ryangoodman.net/blog/index.php/2010/04/19/filter-data-dynamically-in-xcelsius/

Regards

Naveen

[Former Member]

Hi, Thanks for the feedback.

This link provided the solution is not free, right?

In the case of filters, I thought I would test the use 7 combined filters, the problem would be the amount of data that the initial query will bring to 7 possible combinations of these filters.

What do you think?

Tks

[Former Member]

Check also information here

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/70d9a605-20d5-2d10-1a9d-d6efe44c107e

http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/10f691b4-6464-2b10-20bb-9d1454c43377

Regards

Federica

[Former Member]

Hi

I would go for point 3 and with regards QAAWS or LO ? QAAWS but bear in mind the amount of data you retrieve as Xcelsius is not a reporting tool , it is a snapshot of your data hence data have to be organised at a lower level (database and reports) in a way to retrieve them as fast as possible.

Regards

Federica

[Former Member]

Hi, Thanks for the feedback.

Because of the volume of data we think of using LO.

The solution 3, the big question is that somehow it will act the same way as the first solution, the data will be loaded after the filters are all cells in Excel and solving the queries of the three new flash also will search for the parameters of all filters to load the data.

In fact, in my opinion these types of dashboard should be built entirely on Web Intelligence, but the visual layer of version 3.1 is not pretty.

Thank you.