Skip to Content
avatar image
Former Member

selection of row or columns for graphic or analysis item in WAD

Hi guys,

A have the next situation: I have a query with a set of information that in wad can be several tables and graphics with different filters.

I want have the same dataprovider (this query) and in the wad create the different tables and graphics from that dataprovider without create several queries for each filter.

Is this possible?

The proposal is reduce the differents dataproviders quantity for performance, because the information and presentation is the same but with filters differents.

Thank you very much for your collaboration.

Regards,

Jeysi Ascanio

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 15, 2009 at 10:10 AM

    Hi Jeysi,

    Hmmm, if filters are different, you will still need as many db request as the number of tables and graphs. Don't think you will gain any performance improvement.

    Regards,

    Fred

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you FCI for your response.

      But Is it possible use the same dataprovider for several analysis item and graphics items in a same wad? Can you send me the procedure, please.

      In relation to performance, what is the best solution?

      1. Create a query for each analysis item and graphs neccesary. Is the same querie structure but with a minimal filter.

      2. Create a view for each data set from a general querie applying the filters neccesary.

      3. Do the filter in the Wad directly (this not, then for you comment the multiple db access)

      Thank you very much again.

      Regard,

      Jeysi

  • avatar image
    Former Member
    May 12, 2009 at 06:06 PM

    The scenary define the best scheme to apply.

    Key figures quantity, characteristics quantity; web template complexity, etc..

    Regards,

    Jeysi Ascanio

    Add comment
    10|10000 characters needed characters exceeded