Cube Remodelling in BI 7.0

[Former Member]

Here is my scenario.

I am working on a cube ZC_IC05 and this cube is compressed every month.

Dimension 1 - 0material

Dimension 2 - 0plant

Dimension 3 - 0mat_plant (0mat_plant has 0plant compounding)

For some reason 0mat_plant is incorrectly populated in the cube. So I would like to correct it by re-populating as 0mat_plant = 0material.

Can this be achieved using Cube remodelling???

Appreciate any help!

Anirudh.

Edited by: Anirudh on Oct 17, 2008 8:08 PM

[rajkumar_kandula · Accepted solution]

Hi Anirudh,

Remodeling is a new feature introduced in BI7.0 by which it is possible to alter the structure of the cube without losing its contents. At present, this feature is not available for DSOs and InfoObjects. In remodeling, we have the following options:

u2022 For Characteristics:

Add characteristic

Remove characteristic

Replace characteristic

Some important precautions to be taken before performing remodeling:

u2022 Remodeling involves conversion of tables. In characteristic remodeling, the dimension tables are converted and while key figure remodeling, the fact tables are converted. There is a chance of the data being lost or corrupted, so a taking a backup of the InfoCube is strongly recommended.

u2022 All Transformations from and to the InfoCube are deactivated. So are their dependent DTPs. Also, the InfoCube is locked for any loads or changes. Therefore, it should be ensured that no loads are scheduled to or from the Cube while the Remodeling is in progress. Additionally, the transformations and DTPs have to be reactivated after the process is over. Since remodeling involves a change to the structure of the cube, some remapping may have to be done.

u2022 Queries based on the InfoCube are rendered invalid, so the queries must also be changed.

[Former Member · Accepted solution]

Can Cube remodelling be be used for my scenario?

[Former Member]

Hi,

I have never tried remodelling, but you can utilise the option "Repalce Char" for your scenario.

Hope this helps,

Cheers,

[former_member185132]

Anirudh,

So you already have a cube, and the cube already has the characteristic 0MAT_PLANT. In this case, remodeling will not help. Remodeling will help iff you are adding/deleting/replacing characteristics.

Plus, remodeling cannot cross the boundaries of the dimension. Meaning that you cannot refer to the data of Material Dimension from the Mat_Plant. So even if you did not have Mat_Plant in your model, adding it in a new dimension and picking up values from Material dimension will not work.

Suggest you try a transform/DTP to a temporary cube, and do the mapping in that transform. Delete the data in the original cube and reload it back.

[Former Member]

Dear Anirudh

Remodeling, it's the way to change data model already exist.When you add a characteristic or key figure to an existing data model, you must check if the existing data in InfoCube must be enriched with the new information (characteristic o key figure). According your question "For some reason 0mat_plant is incorrectly populated in the cube. So I would like to correct it by re-populating as 0mat_plant = 0material" is relationship to enrich your historical data with the new information, in this cases as Visahl said, you must delelte the data in your InfoCube insert the new InfoObject "0material" and reload the data. Before do this, integrate the new characteristic in the data flow.

Otherwise, you can use a remodeling rule that is a collection of changes to your InfoCube that you perform simultaneously. For characteristics, you can add or replace characteristics with the following: a constant, an attribute of an InfoObject of the same dimension, a value of another InfoObject of the same dimension, a customer exit.

You can remodel InfoProviders in the transaction RSA1 choosing Additional Functions -> Remodeling in the context menu for your InfoProvider in the InfoProvider tree.

After that you should be create a remodeling rule. Enter a desccription for remodeling rule and choose the InfoProvider "ZC_IC05" and choose Create. After that, choose add operation to list, and choose remplace characteristic and you must specify the new characteristic "0material" is to be filled. And mapping for characteristic, in other words, the new characteristic "0material" is filled with the values of another characteristic, to adopt the values of the original, for example"0mat_plant". Choose "Transfer" and save your specefication. Choose Check and choose impact analysis to display a list of the objects affected by remodeling. To the last step it is "Schedule" to start the remodeling and monitor.

Because it is a new functionality of BI 7.0 be carefull make a copy of the InfoProvider "ZC_IC05" before do the remodeling

I hope these comments join of the rest can help you!

Luis

[Former Member]

Hi,

First of all, are you adding any new field ? If no, then why go for Remodelling...

If you want to re-populate the reqd. field, change its mapping in the transformation. Make sure that the cube is empty before that. Change the transformation and then Reload the cube.

Why do you want to do re-modeling ?

[Former Member]

Hi,

Because I don't want to drop and reload the data in the cube which is not an option for me at this point and I am not adding a new field.

I am trying to see if I can achive that using remodelling.

Thanks!

Edited by: Anirudh on Oct 20, 2008 7:15 PM

[Former Member]

Yes, u can replace with remodeling.

Read further clarfication remodling concept

[Former Member]

This message was moderated.