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

where is the data coming from in query


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?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 21, 2004 at 06:37 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

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.