on 08-23-2007 5:39 PM
Hi,
1. If the design is such that it has only the real time cube then are there any implications in loading the real time cube direcly from ECC and other external systems? In this case what is the best approach to load real time cube directly?
2. Why is it advisable to have plan & actual cube as seperate?
Thanks,
sam
Another reason for storing separately is you dont need to change the load behavious of real time cube.
Also, when you know upfont when to plan and when to load, there are 2 process types in Bi 7 to convert the load behaviour of the real time cube.
1. Switch Realtime InfoCube to Plan Mode
2. Switch Realtime InfoCube to Load Mode .
Use this in the process chain and manage the plan and load process.
Ravi Thothadri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Ravi,
This wa a good idea...but u need to do the following for this:
Plan data in write cube and actual in standard cube
create a multiprovider using the above two cubes...
also u can use anothr standard cube for Results, so that the report will come in no time....
All the best;
Sunil M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1. You can load and plan' but you need to change the load behaviour of the cube when you load or when you plan. Right click " real time laod behaviour".
2. The objective of storing separately is that data is split and response time will be better in queries.
Ravi Thothadri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.