cancel
Showing results for 
Search instead for 
Did you mean: 

where is the data coming from in query

Former Member
0 Kudos

Hi,

When we run a query are we getting the data from source system?

Or the cube in Bw?

CAn somebody clarify this for me?

And if i have a query which invloves A hierarchy,is the query execution time going to be more?

Or because the hierarchy is master data it does not effect the query execution time?

Thanks.

Haarika.

Accepted Solutions (0)

Answers (1)

Answers (1)

mstrein
Active Participant
0 Kudos

Hi Haarika,

when you run a normal Bex query you get the data from the Cube/Cache.

Normally the data from the source system is loaded into BW and stored in the BW datamodell of your application. Facttable, DIM tables, etc. The BW data is normally not real time data.

You can if necessary report directly on Source system data eg. using a remote cube if you need real time data.

regards,

Michael

Former Member
0 Kudos

Hi Mikhael,

Thanks for the reply.

So if i get the data from the query cache,

why do i see no data in the queries if delete the data in the cube?

Thanks.

Former Member
0 Kudos

Hi Haarika,

maybe you're reading from the cube (fact table/aggregates) and not from the cache !

If you need more info about the query cache, let me know!

Bye,

Roberto

Former Member
0 Kudos

Hi Roberto,

When i run a query from rrmx,am i not getting the data from query cache?

I saw the roport when there is data in the cube.When i delete the data from the cube and open the query again,i do not see the data .It sys no applicable data found.

Thanks.

Haarika.

mstrein
Active Participant
0 Kudos

That's how it should work.

No Data in the application (Cube)-> No data in the report!

If you have data in the cube and you call the report, the result will be stored for a defined period in the cache.

Correct, Roberto?

Regards,

Michael

Former Member
0 Kudos

Hi guys !

refer to the OSS Note 456068 'OLAP: Deactivating query cache/deleting cache data'...I think you will be able to better work with the cache !

Hope it helps (Haarika, don't forget to assign some points to Michael's answers!!!)

Bye,

Roberto

Former Member
0 Kudos

The OLAP cache is a performance aid. A query will look in the OLAP cache to see if the data has already been retrieved from the database already, and if it has been, and all other criteria for using the cache are met, the query will get the data from the cache rather than having to read the database. Deleting the data in the cube will invalidate the cache for that query, meaning the query must go to the cube, and surprise, surprise, find no data. Any time the cube gets changed, the cache will be invalidated.