Skip to Content

This will be simple one but may be helpful..

My cube have data as shown below.

My cube designed screen.

Now am planned to add 0customer to Entity Dim.

Go to RSA1, Administration–>Re modelling tab,

Take you to the below screen.

Give the remodeling rule name and target on which you want add info obj. click on create, its gave a pop uo box to enter description.enter the required description and click on transfer. in below screen click on + symbol(add an operation to list)

Click on that , Below screen will popup.

here we can see all options which we want add/delete, for adding we not pass values using 4 options as show above. time being am using constant value.

after filling the required options here, click on Transfer. next save and Click on check. there is an option impact analysis, by adding/deleting if we want know the any impact, clik on it , it shows you.

After this check options , you can schedule, it will adjust the all necessary changes in cube dimension.

Next screen will come with start later and start immediately. choose as you want. but choosing here as start immediately.

after choosing immediately,

you can see below message, then go with monitor or job log.

as we see in pic. after the success of this job, you can see added filed in your target.

See my cube have added info obj in IC_EVA3.

By adding new obj, DTP was deactivated, so make it active and use usual.

My doc – purpose is too add info object to target which have data.

Information:

Remodeling purpose is just add or delete info object from cube which have data.

For added info object need historical data then drop whole data from cube and reload from source.

If you won’t need histocal data then droping data from cube was not needed. Thru delta loads now onwards data will be filled for added info object.

Thank you all.

To report this post you need to login first.

40 Comments

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

  1. Aakash Gujja

    Hi Raman,

    It’s very useful for everyone. Thanks for sharing with us.

    I have one query about adding new field in cube. If we dont required historical data for the new field we can add it directly into the cube right or else do we need to follow the same process? Recently i have added one field directly into the cube as user not required historical data for that field.

    Thanks Regards

    Aakash Gujja

    (0) 
    1. CH Raman Post author

      Hi Akash,

      By remodelling you can add directly new object into cube. if don’t need historical, then no need to delete and load data steps. just add new object and map or maintain routine to fill data.in next load onwards new object will filled asusual.

      Thanks

      (0) 
        1. CH Raman Post author

          Not clear what you need.

          are you asking how to write code?

          if yes then please take abap expert help and inform him about your source and conditions.he can handle code part easily.

          (0) 
  2. Sudha Moon

    Hi Raman,

    Very nice and Useful. As Suman mentioned Please add What to do to load historical data and How the subsequent delta load happens to the new field and what are the steps and precautions we need take.

    (0) 
  3. chandra nagireddy

    Good one.

    every one will be happy if yu addressed the histroical data,( many of us know how to load handle..still if u addressed in the doc nice..)

    Regards,

    Chandra,

    (0) 
  4. Krishna Chaitanya

    Good to see this document from you. 

    Seems to be full fledged reply for the yesterday’s thread.

    Thanks for sharing to all of us.  Keep going 🙂

    Regards,

    Krishna Chaitanya.

    (0) 
  5. Suman Chakravarthy K

    Hi Raman,

    The main USP of this blog is the title. “How to add an Infoobject to the Cube which has data” catch the eyes of all BW consultants. If you had put it as “Remodeling Concept” then the impact would have been less. You did a smart thing with your title. 😉

    Keep it up..

    Regards,

    Suman

    (0) 
    1. CH Raman Post author

      Not like that, Most of the time i choose titles with general words.

      I seen lot of scn users asking questions in general terms. So when we use general or suitable words, its easy to get on Google search engine.

      I think SCN ROE also mentioned the same.

      (0) 
  6. Yogesh Narwani

    Hello Raman,

    Very nicely documented the whole stuff & thanks for sharing the same .  I hope  you will share  the updated version ( historical data) for same soon !

    Regards

    YN

    (0) 
  7. Sankameshwar Ramakrishnan

    Hi Ramanjaneyulu,


    Very good document.


    But I doubt if below statement is correct unless the new field can be filled from a different field within the same dimension  .

    For added info object need historical data then drop whole data from cube and reload from source ” 


    If the field can be filled from a different field within the same dimension, the customer exit can be used.  Code in below link is helpful . Tried and worked 🙂


    Remodeling process in BI


    Thanks.

    (0) 
    1. CH Raman Post author

      Seems like you may have the same remodeling rule on your target.use some other remodeling name and try it. or click on edit and see. what it shows.

      if you any issues, please raise as start discussion rather than here.

      (0) 

Leave a Reply