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

[QAAWS on SAP BW query] - data update process in XCelsius is too long

I have XCelsius dashboard which uses QAAWS connection: XCelsius >> QAAWS >> BEx query >> SAP BW InfoCube

When I load data into InfoCube - XCelsius dashboard updates data after 20 minutes or more

QAAWS settings are following:

- Refresh on load

- Refresh every 60 sec

I suppose that XCelsius cashes data...

How to improve update time so I can load data into BW InfoCube and see the updated data on the XCelsius dashboard without waiting for 20 minutes?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2009 at 09:59 AM

    Ideas?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2009 at 10:02 AM

    AFAIK,

    Xcelsius is not caching any data (worksheet is here only to help you with the dashboard design). QaaWS is indeed caching data, query cache sessions are defined according to username, prompt values, and query id. Cache lifetime is defined in QaaWS Designer, this corresponds to timeout parameter you can see when opening the Advanced parameters tabs on query design wizard first step (cf. Advanced... button). By design QaaWS behavior is to fetch data from DB for each query (unless cache can be used). Default timeout value is set to 60 seconds (i.e. cache is cleaned after 60 sec without any new request from the same user).

    This said, I'd simply underline that QaaWS is not the recommended connectivity solution for Xcelsius and BW, recommendation is to implement LO connection from a Crystal report.

    If you prefer using actual web services, you may be interested to try WebI Web Service Publisher, available from XI 3.1 SP2 WebI rich client, which enables to publish web services from WebIntelligence report parts (tables & charts), which provide better interactivity & flexibility (as compared with QaaWS & LO), and also better performance than QaaWS (by reducing the amount of DB hits).

    Hope that helps,

    David.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2009 at 06:09 AM

    Review whether the delay is running the query on BW - there are multiple squereis run on the BW DB to support the QaaWS.

    I would geenrally recommend that BW variables be setup rather than just placing query filters in the Qaaws or Universe. When filters are added to restrict data rather than filling BW variables, addtiional queries are generated in order to generate the mDX stmt. These quereis join the master data and dimension tables to find all the populated values to include in the MDX stmt. If the mstr data object has lots of records, these preliminary queries can row a while, especially adainst multiproviders.

    There are performance improvesments in the lastest BW and BOBJ SPs, so get as current as you can.

    Add a comment
    10|10000 characters needed characters exceeded

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.