BWA Index Problem while transporting Info object

[Former Member]

Dear Experts,

We have created BWA Indexes for 0WBS_ELEMT in quality and production BW system.

In Development we have added one new attribute to 0WBS_ELEMT info object, And transported to quality system.

Here 0WBS_ELEMT inactivated due to BWA Indexes.

So we have deleted below tables date and table and re created the table directly in quality using SE14 T code

1./BI0/SWBS_ELEMT

2./BI0/MWBS_ELEMT

3./BI0/PWBS_ELEMT

4./BI0/XWBS_ELEMT

5./BI0/TWBS_ELEMT

After all deletion of above tables re transported same request to quality system. and WBS element activated.

Due to deletion of master data tables all cubes transaction data SID link gone and re loaded the transaction data.

Same method is not possible in Production system.

Please suggest any other method without deletion of BWA Indexes and tables.

Regards

Ramu

[Former Member]

Problem solved

[former_member188080]

Hi,

We go for this way SE14 that is last option..

You have to follow same method may be in Production ,get client informed and get more time and better plan...worst situation..

see if you can delete the index on object and retransport..

see if RSRV adjustments works...

Thanks and regards

Kiran

[Former Member]

Hi, For addition of a attribute in InfoObject don't required to delete data, activation of master data/attribute change run will update the master data.

So i fill you missed opportunity to test it correctly in QA. from error it fills that issue is with BIA indexes, so you need to clean BIA for all provider which is using this WBS Element InfoObject. So that it will not give this error while transport and then you can refill BIA indexes.

I will suggest never ever go for se14 option still u are 101% sure.

Regards,

Ganesh

[Former Member]

Hi Ganesh,

Thank you for your reply.

Am not saying BIA Indexes. We have created BWA Indexes for Business objects purpose.

These indexes are using in BO not in BW.

That is the reason to delete the master data and tables of WBS element.

Regards

Ramu

[Former Member]

Hi Ramu,

BWA Indexes are used for increasing performance then it may be the BEx report or input to Business Object. When you load BWA Indexes values of Objects (Master Data/Provider Data) gets loaded to BWA server, so all Values are get updated in BWA memory, so this reference will be always there in SID table of InfoObject. Hence when you want to change this data, it will see reference in BWA and hence it will fail.

You can try one thing. Revert changes and load data in one of the Provider where WBS Element is used, so that you will get SID's generated. Then load BWA again. So this will be initial situation.

Now add Attribute in the Master data that will not be allowed, so just clean BWA data in Dev and then try to add attribute, and check if you get any error.

This will help you to understand what will happen in Production

But you should not delete data from any table from Se14, because BW data is stored based on Extended Star Schema and hence there are many dependencies hence you should not use this and go by default procedures for same.

Regards,

Ganesh