Hi,
We now have a live CUBE. It has now live data and daily <b>DELTA</b> updates are already scheduled on it.
However, it is now late that we discovered we need an additional dimension to be added to the <b>CUBE</b>. The data source is able to provide the values for the cube so theres no problem where to get the data.
Now the question is how could I add the new dimension to the <b>LIVE</b> cube w/o having to reload data again from scratch.
Please advice...
--Jkyle
Hi Jkyle,
you can always add a new dimension to a cube a long as there is a free one. But all records already posted to the cube will stay without any information coming from that dimension. If you need to fill the dimension also for the history I think there is no way except the reload from the source system.
In case you still have all request available in BW you might be able to load from PSA, step by step and after successful reload of a request you can delete the corresponding original request from the cube.
regards
Siggi
Add a comment