on 12-21-2004 6:27 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.