Question:
Hi all,
A challenge for all BW-guru’s
Our BW team developed a template for our (7) customers. 3 of our customers want to upload client specific information in a custom made cube.
So, customer 1 wants to upload A,B and C to cube 99
Customer 2 wants to upload K,L and M to cube 99
Customer 3 wants to upload X,Y and Z to cube 99.
Is there anyway to accomplish this in some sort template, without enhancing cube 99?
mcteam
Answer:
What do you mean by enhancing the cube? You can do it by simple update routines in the update rules, w/o changing the cube structure.
_________________
Keep smiling
Answer:
Hi SR,
Sorry for not being clear. What I meant was, in cube 99 (template) I already have 10 infoobjects. I don't want to add extra infoobjects for the 3 customers in the current template.
What I want is that the cube should know via some kind of "switch" that there are extra client specific information and that the cube should add these extra information in the cube.
I know I am asking a lot of intelligence from the system, but just want to check if this is possible before moving to other solutions (if any).
mcteam
Answer:
I take it that A, B, C, etc., are characterisitcs (InfoObjecst) that do not exist in your InfoCube. In which case, you can't avoid changing the InfoCube structure. That is why I find the Data Warehouse layer principle gives one a lot of flexibility. Have an ODS layer with all possible InfoObjects from a data source, and build cubes over it (or several ODSs)as necessary.
There is no 'switch' to help in your case. All you can do is to copy the template to a new cube and then add the new InfoObjects to it and then update it from your DataSource.
_________________
Keep smiling
Answer:
Hi SR,
That is exactly what I thought (and didn't hoped to be).
Thanks for looking into it.
mcteam