BO Universe built on SAP BWQuery - Issue with Objects defined as Compounded

[Former Member]

Hi,

There is an object in SAP BW Query "Account Number" which is defined as compounded with "Charts of Accounts" as a Superior info Object. BO Universe built on this BW Query is not displaying the attributes correctly. All the attributes (key, short text, long text) are appearing as Chart of Account / Account Number (0010/112300).

Is there any issue the way BO handles compounded objects while creating the Universe or am I missing any steps. Any piece of advice will be reaaly appreciated.

Thanks

Ambuj

[Former Member · Accepted solution]

Hi

Even we had this problem with Finance domain related reports with respect to SAP BW as database.

Solution for this can be create a variable at report level with the following formula.

If you are sure that "Account Number" is of 4 digit (fixed) and "Charts of Accounts" 6 digits (fixed) then this formula works

=Concatenation(Left([Object name];4);Right([Object name];6))

this can be created at Universe level even depends on how many reports that you are going to use this Object.

for an example I have mentioned 4, 6 it can be any number but should be fixed

Thanks

ChiranGV

[Former Member · Accepted solution]

Hi ChiranGV,

Thanks a lot for your time and response. However having report level formulae does not solve my problem. Data is huge and I need to filter the accounts at query level itself otherwise I get partial results. I am not sure how a custom object with this formula can be created at Universe level. If it can be created then I can use as a filter in Query. It is a BO Universe built on BW Query. I tried using varios XML tags and BO User guides to achieve this but could not. Request you to please help me with creating this object at Universe Level. I think we can do very limited with SAPBW Universes with respect to creating custom objects.

Thanks!!!

Regards,

Ambuj

[IngoH · Accepted solution]

Hi,

for filtering you should use a variable and correct the variable will show both elements from the compounded part.

ingo