Skip to Content

Remodeling on DSO

Remodeling Overview

Remodeling on DSO is a new feature available from BI 7.3 which enables to change the structure of a DSO already loaded.

Note: Now this feature is supporting for DSO in BI 7.3 and not supported for Info objects.

Using remodeling a characteristic can be simply deleted or added/replaced with a constant value, value of another Info Object, with value of an attribute of another Info Object.

Similarly a Key Figure can be deleted, replaced with a constant value or a new Key Figure can be added.

This blog describes how to add a new characteristic to DSO using the remodeling feature and populating data for added Characteristic.

 Note following before you start remodeling process:

  • Back-up of existing data.
  • During remodeling process DSO is locked for any changes or data loads so make sure you finished all the data loads for this DSO till the time this process finishes.

Note following after you finish remodeling process and start daily loads and querying this DSO:

  • All the objects dependent on DSO like transformations, Multi Providers will have to be re-activated.
  • Adjust queries based on this DSO to accommodate the changes made.
  • If new field was added using remodeling than don’t forget to map it in the transformation rules for future data loads.

  Initial Structure of DSO

 Initial structure of DSO

 

 

 

 

 

 

 

 

 Start the remodeling toolbox. This can be done either via Transaction Code: RSMRT or from the DSO context menu.

 

In the next screen enter the technical name you want for the remodeling rule to be and in the next box enter DSO technical name being remodeled. Click on Create button.

 

 

In the next screen enter the relevant description and click on Transfer button.

 

Click on the Add Icon to create a new remodeling rule.

 

Select the radio button Add characteristic, enter/select the new characteristic.

 

Check the key field button

 

 Remodeling rule is now ready and can be scheduled. Click on the schedule button.

 

 Select the desired scheduling option. While the remodeling rule is being executed it can be monitored by clicking on the monitor button.

 

 DSO Structure after adding New Characteristic,

 

 Finally add the new characteristic to the query and execute it.

 

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. tilak mishra
    Nice feature of 7.3 over previous releases but  question comes to my mind is how far it’s going to be used in a regular practice on project letvel when we count on the consistency thing.

    Screenshots are bit small in size however your texts were self-explanatory.Thanks again for sharing the article which we had waited for..

    (0) 
    1. Sriman Kanchukommala Post author
      When ever the data source was enhanced, we need to enhance with that field through-out the data flow.As of now we don’t have option to enhance the same. It will be very useful in the regular practice.
      (0) 

Leave a Reply