Skip to Content
author's profile photo Former Member
Former Member

Performing filters in Xcelsius

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 11:49 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 11:55 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 12:14 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.