cancel
Showing results for 
Search instead for 
Did you mean: 

Steps after changing the infoobject length

Former Member
0 Kudos

Hi team,

I have read so many documents regarding this. But i have one clarification i have increased infoobject length.

After increasing the infoobecjt length all the tables which related to the infoobject also got affected. Then why we need to do the table adjustment in SE14?

The infoobject got affected only in DSO and OHD and no infocubes.

1. Could you please tell me the use of SE14 in this case?

2. Lets say its necessary to do the table adjustment. In that case wheather we need to give the P table,Stable ,T table and DSO active activation table and changelog table or P table is enough?

Could you please guide me.

TIA

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member241605
Active Participant
0 Kudos

Hello Prasath,

you can achieve the "Info object Length Modification" using the Remodelling Functionality.

Steps:

1) Create a dummy Info object same as your original Object with the length More or less which you wanted to see.

EX: your existing Characteristic is Z_SALES with [CHAR - 02] but you want to change the length to  03, so create a new Info object Z_SALES1 with [CHAR-03]

2) create a remodelling rule with addition of characteristic and you have to assign to the same dimension as what your original object was assigned, and select 1:1 Mapping and give the original Info object name "Z_SALES'.

so that the data will get copied from the Existing one to Dummy one.

3) create another rule for deletionof existing Charcteristic in our case Z_SALES and once after this delete the data in P Table using the Table SE14 then only u can change the length to 02 to 03.

4) once after sucessfull modification of info object create another rule fro addition of Z_SALES by assigning same Dimension and select 1:1 Mapping and give Z_SALES1 so that data get copied from dummy to main again.

5) finally create another rule for deletion of characteristic Z_SALES1.

in this way you can achieve it but during this process Transformation & DTP related to the cube will be deactivated so once after all re activate them.

also if the Charcteristic is used in the query level then first remove them from the query and once after modification again you can add it.

Regards,

PJ

snitwipro
Active Participant
0 Kudos

Hi,

   SE14 is generally used when we would like to either save the data or delete the data. Both the option attempts to change the database definition of the transparent table. We might see the actual table definition in SE11 which might not be same as the oracle table definition.

  Extended use of SE14 is to adjust the table indexes (secondary or primary). Also it is recommended to use a table adjustment when there is any change happened at the dictionary level.

   I don't think the SE14 use is required in case of data length change in the info object. BI gives you the chance to adjust the errors by using Tcode RSRV. Please let me know if you need any further information.

Regards

Sourav

Former Member
0 Kudos

Hi Kalpana,

I have the transactional data in the DSO but i can able to increase the infoobject length and the length gets reflected in the DSO Active and changelog table.

In SE14, if i entered the infoobject name it says object doesnt exists. In se14 we need to give the table only rite so which table i need to give becuase that objects exists in DSO also so we have active ,SID ,changelog table etc?

Former Member
0 Kudos

yes u can chane the length. after ur changing length of infoobject .process will be in inactivate state so in se14 give ur object name( /BI0/MCUSTOMER). we have to give master data table.click on edit their u will find activate and adjust database select that.ur process will be in active state.

Former Member
0 Kudos

You cannot change the length of an InfoObject if there is data in it's tables. You cannot delete this data if the info object has data assigned to it in a transactional table such as an ODS or Cube. So, first thing is to delete all transactional data that refers to the IO. Then delete the master data associated with the IO. Then you can Change the length of the IO.

Change the length of the infoobject in the infoobject maintainence. Then go to SE14 and enter the infoobject and then save and activate the database.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10db929a-7abb-2e10-6fa5-d8d45ca02...

RamanKorrapati
Active Contributor
0 Kudos

Hi Prasath,

Below link will give clear idea - about SE14 usage.

http://scn.sap.com/thread/1598942

By using  RSRV also you can do repair for specific info object.

Thanks