Changes to be made in Universe created from Bex Query

[former_member360582]

Hi,

Once the Universe has been created on top of Bex query,after that any important changes to be made in the structure.

Just like I found that the Measure object created in universe needs that object properties function should be changed from database delegated to Sum.

Or should I keep the same as database delegated.

Is there any thing else needs to be changed.

Regards

Gaurav

[former_member360582]

Answer got

[IngoH]

Hi,

the default setting for the key figures can be configured in the options of the Universe Designer (tab OLAP).

Delegated is needed of items that have an exception aggregation.

In case you change the underlying BW query you need to reflect those changes in the Universe by using the menu View > refresh structure

ingo

[Former Member]

HI ,

Universe Designer has a button that is intended to pick up changes from a modified BEx query

Clicking this button re-generates the universe from scratch (as if it was a new one), generating new object IDs

Reports built on the universe prior to clicking the button contain objects with now invalid object IDs

All such reports will lose their query definitions and leave an empty query panel

Multiple individual support cases logged by various customers can be reduced to this issue

Partial fixes included with FixPack 1.4, available now. More to follow in SP2

In a universe design we identify subject areasdefine required data elements evaluate ad-hoc requirements Prioritize ease-of-use/ maintenance or performance

You can visit the link. http://www.element61.be/e/resourc-detail.asp?ResourceId=158.

thanks,

karthik