Doubt reg the Info Cubes

[Former Member]

Hello, Experts.

I few Doubts Regading, Cubes.

We have a cube which is getting Loaded from APO Every day. Now business has asked us to Chage the Data Source for Few Key fig and they want

few more char and they have removed few Char which are not really used for this Key fig.

In this case shall i use the same cube and create a new Data Source ,Info source,Update Rule /or/ go and Create a New cube?

they want few Key fig from the Old Data Source and Few from new Data Source.

and few Char are same in both the data Source. like Division, Sales Org, Customer, new char are Flavours, region, .... which are not in the existing cube.

Please Suggest me.

Thanks

Sharp

[Former Member]

Sharp,

The general rule of thumb is if it is similar kind of data, and you are just adding few additional chars/key figures, it is better to just change the existing cube. One the other hand, if the data from the new data source is different, it is better to create a new cube. For example, if you have Plan data in a cube at the WBS level and the requirement is to now load the Plan data for the activity/actiity element, I would just add the activity/element to the existing cube. Instead, the requirement is to now add the Actual data, I would create a new cube and report off of the multi-provider.

Also, you mentioned that the data from the new source will not have some of the existing charactersitics populated, in that case your cube will be sparsely populated for the new data source.

Think about the volume too. If the volume from the new source is big it is better to create a new cube. This will be better in terms of maintenance.. For some reason, if you have to drop just the new data and reload and if they are in separate cubes, it is a lot easier. Otherwise, it puts a restriction on compression, etc.

I would say, consider several different factors like, data relevancy, how many new char/key figures, data volume, load restrictions, reporting requirement before you decide.

Regards,

Abdul Kaleem

[Former Member]

Hi,

I have added my thoughts to your requirements..

they want few Key fig from the Old Data Source - <b>Have this data source as is</b>

Few from new Data Source - <b>Enhance the old data source with the few fields from new data source.</b>

Cube - <b>Modify your cube as per the latest requirements. Content should be deleted before modifying the existing cube in prior BI 7 versions.</b>

Hope it would help you.

Kumar

[Former Member]

Hello,

In my Case

I am Taking 6 Keyfig from New Data Source and in that 4 Key Fig are already Existing in the cube just need to remap it with the New Data source and Need to add New Key fig which we dont pull any Pervious / History data for this 2 key fig . this key fig will hold the data from the day it moved to production.

and we are going to add 7 More Char to the cube, and old data wont need this.

and i am Using BW 3.0B now .

Please advice me

Thanks

Sharp

[Former Member]

1. Try to change the existing data source and add new fields and delete the unwanted fields.

2. Same is with the cube. You wont be able to remodel the cube without deleting the cube, unless you are in BI 7, where you have some flexibility.

Ravi Thothadri