BW Variables not showing up in universe based on BEX query

[Former Member]

We've been trying to create BO Universes on BEx Queries. When we create the connection, it reads the query into the Universe, however, it does not always read all of the BW variables associated with the queries. We've moved all filters in the BEx Query into Free Characteristics but BO Designer still does not read them into the universe or create them as mandatory filters in the universes as the documentation states. Any assistance is appreciated. Thanks

[IngoH · Accepted solution]

Hi,

in case you are before FixPack 2.5 you might have to move the characteristic into the rows or columns. Above FixPack 2.5 or SP3 and higher that should not be needed anymore.

ingo

[Former Member · Accepted solution]

Thanks for the replies. To answer the first question, we are using BOXI 3.1 SP3

Let me know if this helps provide some suggestions.

[Former Member · Accepted solution]

Hi -

I assume that you might have kept the filters(Variables) in Default Values section. Only filters which are placed in Characterstic restrictions will appear in Universe Designer. Thanks!

Regards,

Anesh B

[Former Member · Accepted solution]

You are correct. When moving them to the Characterist Restrictions section, they show up.

[Former Member]

Hi,

Which BOE version are you using?

Which type of variables are not generated in the universe: all, only some?

Didier