Remodeling of a Cube

[r_b9]

I am using BI 7.0. We have datasource based on table/view. We manually enter the records daily in the table. There is infocube based on this datasource. Infocube is loaded with data from this table/view. Now we need to add one more field to the table/view and consequently one more characteristic in the Infocube.

Can I use the remodelling concept using customer exit to populate value of new field? If yes how and can I used to ??? If no is there any other method to perform the above activity?? Also I want to populate the value of newly added field for already loaded data records, how can I do this??

[Former Member · Accepted solution]

HI,

There is another way of remodelling. You dont you create a MultiProvider over the present cube. And then for the new field, you can create an infoobject or another cube and add it to the Multiprovider. By creating the Multiprovider, it will be very flexible in adding the fields in future also. This is only the conceptual point of view; practically i havent tried. Just give it a try.

[former_member209032]

Hi,

If the data volume is less in source, then you can add drop the cube data, then add new field to the cube and then reload the entire data from source. if the volume is high then go for re-modelling(i do not think as you are manually maintaining data). Search the forumn, there are lot of articles regarding how to do remodelling.

Regards,

Raghavendra.

[r_b9]

The data volume is already high in Cube...are you saying in my case there is no need of remodeling/

[former_member209032]

Hi,

How long will it take to load all the data once again from source?

Regards,

Raghavendra.

[r_b9]

will need to find out......but wht do u suggest....is remodelling feasible in this scenario.....we are daily manully adding the records in the table....

[former_member209032]

Hi,

Remodelling is feasible, but if the data volume is less( let say less than 10 million) then you can drop and reload the cube. This is the easiest option.

Regards,

Raghavendra.

[Former Member]

what do you mean by daily manually adding records in the cube?

I think if the whole loading it not taking a long time you can change and send it from development to production.

Otherwise you can do remodelling in production directly.

Please do close the thread if that answers your questions.

Regards.

Den