Problem with Queries Structures in Bex Query Designer and Universe Designer
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.
1) Bex Query Designer
- (Characteristic Restrictions) Reg Guayana
> (InfoObject) 0Product = 'XXX'
> (InfoObject) 0Country = 'YYY'
- (Characteristic Restrictions) Reg Caracas
> (InfoObject) 0Product = 'AAA'
> (InfoObject) 0Country = 'BBB'
(Key Figure) Net Sales
2) Universe designer
>(Measure) Net Sale
The universe dont translate the two Characteristic Restrictions in the structure ZSRT_123.
Any information would be much appreciated. Thank you.
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.