Skip to Content
Author's profile photo Raman Korrapati

Adding New info object to info cube Which have data.

This will be simple one but may be helpful..

My cube have data as shown below.

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.

Assigned tags

      40 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Simply superb. But you should have told about What to do to load historical data and How the subsequent delta load happens to the new field.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Hi Suman,

      Thank you, surely i will add it soon.

      Reagrds

      Author's profile photo amine lamkaissi
      amine lamkaissi

      Hi Raman,

      I just discovered that you are publishing documents in SCN.

      I will follow your posts.

      Keep going 😉

      Amine

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Thank you Amine, i will try to give best useful info to the SCN/BI users.

      Regards

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Hi Raman,

      Making bigger strides good to know that.

      wish you all the luck.

      Hope you will come up with more documents soon.

      Regards,

      AL

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Thank you Anshu, i will try to give best one.

      Regards

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo CH Raman
      CH Raman
      Blog 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

      Author's profile photo Former Member
      Former Member

      Hi

      to write end routine code.

      Author's profile photo CH Raman
      CH Raman
      Blog 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.

      Author's profile photo Sudha Moon
      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.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Thank you sudharshan, surely i will update.

      Thanks

      Author's profile photo Aditya Sai
      Aditya Sai

      Hi Raman,

      Please help me understand regarding those 4 options?

      Constant , attr etc.,?

      Constant means you defined it anywhere?

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice document raman 🙂

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi Raman,

      Simple and useful information...thanks for sharing 🙂 .

      Author's profile photo Former Member
      Former Member

      Hi Ram,

      You explained remodeling concept in better way.,.,

      Regards,

      J.Sakthikumar

      Author's profile photo Former Member
      Former Member

      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,

      Author's profile photo Krishna Chaitanya
      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.

      Author's profile photo Harish Allachervu
      Harish Allachervu

      known concept 😛 but how you articulated its simply superb anybody can easily understand. 🙂

      Cheers,

      Harish

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Nice solution Raman. As usual you kept the docuemnt simple but the solution will come in handy for many.

      Goodluck,

      Benedict

      Author's profile photo Phani KV
      Phani KV

      Hi Raman,

      Nice document and thanks for sharing.

      Thanks,

      Phani.

      Author's profile photo Suman Chakravarthy K
      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

      Author's profile photo CH Raman
      CH Raman
      Blog 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.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Yeah,, you are right!!

      Author's profile photo Yogesh Narwani
      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

      Author's profile photo Former Member
      Former Member

      Nice one.

      Author's profile photo Aravind Nag M
      Aravind Nag M

      Nice one, as requested please add the steps related to history load and subsequent deltas.

      Author's profile photo Sankameshwar Ramakrishnan
      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.

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Yes, above statement will be considered when we load data(added field) from source(ECC).

      Author's profile photo Former Member
      Former Member

      HI,

      good document.

      Author's profile photo Former Member
      Former Member

      Good Doc Brother..!

      Author's profile photo Erdem Uren
      Erdem Uren

      /wp-content/uploads/2014/06/7_469415.jpg

      why i cant see "create button"?

      Author's profile photo CH Raman
      CH Raman
      Blog 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.

      Author's profile photo Former Member
      Former Member

      Like this document.very good concept on

      Remodeling. 🙂

      Author's profile photo Former Member
      Former Member

      Very nice document Raman..:)

      Can you share the link for the document about what to do to load historical data...

      Author's profile photo CH Raman
      CH Raman
      Blog Post Author

      Hi

      for historical data, we need delete and reload data to cube.

      There is no other way.

      Thanks

      Author's profile photo Former Member
      Former Member

      okay..

      Thanks..

      Author's profile photo Former Member
      Former Member

      Hey Raman,

      That was a real cool document.

      We often face scenarios, Thanks for sharing.

      Regards,

      Vikrant

      Author's profile photo venkat yerva
      venkat yerva

      Hi Raman,

      It is good document and you presented very well 🙂

      .

      Author's profile photo Former Member
      Former Member

      Good note to be kept!