Changes in WEBI Report due to change in BLayer

[Former Member]

Hi All

I have made some changes to my Business LAyer in IDT by adding and removing a couple of dimensions. now when i try to run my webi report whihc was based on the changed univervse it is asking me to recreate the whole query.

do i have to chnage all the webi reports based on this universe just becasue i made a chnage at the Busienss Layer level.

What is the best practice for such a situation.

Regards

Adnan

[Former Member · Accepted solution]

Hi,

After adding and removing dimensions from business layer save the connections and export to repository..

Yes, you need to change all the webi reports if the dimesions are added and removed from the business layer.

[Former Member · Accepted solution]

thanks for the response ravi. but the dimensions being used in my WEBI report still exist in my business layer. so the only chnages made at the business layer is adding a few more dimensions and removed some of the unused dimenions. are you syaing i still have to recreate the webi report from the beginning.

is there  a better way to handle this. if ihad like 30 webi reports based on one Business LAyer. than  every time i make chnage made at the businsess layer i will have to recreate all the 30 reports.

there has to be a better way of doing this .

[former_member188911 · Accepted solution]

Hi A Z H ,

I don't think there are any problems with the addition of new objects in the business layer, what I think is giving you headaches are removal of objects.

If you remove objects from the business layer and the same was present in one or more documents, that field will be still in the query and somewhat you will need to remove it from the SQL statement otherwise you will get database errors.

At the same time it is not recommended to simply remove objects from a Business Layer, too risky.

Once deleted you cannot simply re-create the object and think it will be re-associated to all the documents you have.

Personally I would create a Class that becomes like a trash can where you move objects that are no longer needed.

Then you would run platform search to find all the documents that include that object and manually remove them from the query.

Last but not least, I would document everything in case some day somebody scratches head trying to find where that object has gone...

PS:  My two cents, not an official statement from SAP

Thanks

Simone