cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

I was also facing this issue.

What i have tried - I ran the Dashboard and then delete the data from the Underlying Bex Query . Howevere if i again refresh the Dashboard it still shows me data.

Then i try to modify the QaaWS , you pls also try this , even in that at the last in the preview field it shows me data.

Then i realise its a problem beyond QaaWS.

Then i modify the Universe connection. After doing that i am able to see the run time change.

Now i got data get refreshed fast.

Former Member
0 Kudos

Ashwani Sharma,

Thanks for your answer.

>Then i modify the Universe connection. After doing that i am able to see the run time change.

>Now i got data get refreshed fast

But how to modify Universe connection? It works without problems...

Former Member
0 Kudos

while creating connection to universe.

On the screen of connection time out , please select - disconnect after each transaction.

and try again and let me know the result.

Thanks

Former Member
0 Kudos

Ideas?