Skip to Content
Former Member
Sep 25, 2012 at 08:06 AM

Converting detail objects to dimensions - consequences?


Most of our WebI reports run on UNV universes built on top of SAP BW queries. Although we have upgraded to BO BI 4.0 SP2, there are no plans of switching to BICS.

Our current standard for building universes is creating a dimension for the technical key characteristic in SAP BW and keeping all other attributes as detail objects: i.e. Customer No. (1594449) is a dimension while Customer Name, Customer Address, Customer Telephone no etc. are detail objects for Customer No.

Now we need to convert all "Name" detail objects, e.g. Customer Name, into dimensions while still keeping the other detail objects.

I expect that the change will take affect automatically once the reports are refreshed and saved. However, what consequences can this change have on our existing WebI reports such as in cases when:
- query stripping is enabled
- detail objects are used in query filters
- detail objects are used as report filters
- etc.

Thanks in advance.