on 2006 Feb 28 5:03 AM
Hi gurus,
suppose i have a cube and aggregare is there. now a new data is loaded in cube but not rolled in aggregate.
Now if i do a query such that the requirements new data only and it is not in aggregate , then from where the query is going to get data, is it form cube or aggregate?
Tahnks
Ram
HI Ram,
The query will fetch the new data from the base cube only as the data is not rolled out in the aggregate.
Hope it helps...let me know
Regards,
R.Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ram,
You might read this help link..
http://help.sap.com/saphelp_erp2005/helpdata/en/80/1a6791e07211d2acb80000e829fbfe/frameset.htm
Hope it is helpful.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ram,
In this case the query will take the data from the cube.
depending on the selection conditions in query, the appropriate aggregate is picked up during run time, but if the data is not rolled out in the aggregate and is available in the base cube, the query will fetch data from the base cube only...
hope it helps..
thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
When ur executing a query the OLAP processor searches for the data in the appropriate Aggrs. if the OLAP processor is not found the appropriate Aggr then it will search data in the cube. From ur question the data is not rolled out into the aggr,so the OLAP processor will fetch the data from the cube.
Thanks,
Shreya
(Do not forget to assign pts if it's useful..!!)
hi ram,
While executing a query the OLAP processor searches for the necessary data in the aggregates ( if present ). if the data is present then it is fetched from aggregates. if not then it will search in the cube. So for your question, it fetches data from cube.
cheers
ravi
Assign pts if the answer seems useful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
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.