Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with Queries Structures in Bex Query Designer and Universe Designer

Hi everyone,

I have a problem when i try to do a Universe from a Bex Query Designer.

When I use a Characteristic Restrictions in a Structure, the universe only show me the structure without the objects inside it.

EJ:

1) Bex Query Designer

Colunms

(Structure) ZSRT_123

- (Characteristic Restrictions) Reg Guayana

-


> (InfoObject) 0Product = 'XXX'

-


> (InfoObject) 0Country = 'YYY'

- (Characteristic Restrictions) Reg Caracas

-


> (InfoObject) 0Product = 'AAA'

-


> (InfoObject) 0Country = 'BBB'

Rows

(Structure) ZSRT_456

(Key Figure) Net Sales

2) Universe designer

(Class) ZSRT_456

-


>(Measure) Net Sale

(Class) ZSRT_123

-


>(Dimension) ZSRT_123

The universe dont translate the two Characteristic Restrictions in the structure ZSRT_123.

Any information would be much appreciated. Thank you.

Former Member
Former Member replied

Hi,

There is only one level generated for a structure whataver the structure hierarchical depth: this level is L00

This is an OLAP BAPI and MDX limitation.

By the way the structure is correctly generated but flattened.

Ragrds,

Didier

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question