cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to set Field property as Key (Not Compounded) & Text

0 Kudos

Hi,

I am using Design Studio 1.6 SP1 Patch 2, I have created one Design studio report on top of BW query.


This BW query have GL account field which is compounded with chart of account, and its show result GLACCOUNT/Chart of account as compounded,


example: GL account number = 10001, chart of account = ABC,

when we execute design studio report it shows result as 10001/ABC

Desired result to show only GL account number = 10001, which seems not possible using design studio,

I can able to show only GL account value = 10001 by selecting option 'Key (not compounded)' from context menu of GL account field after executing same BW Query on SAP Enterprise Portal - Refer below screen shot of GL account property from Context menu (right click) of GL account field.

But same context menu option is not there when we execute same BW query via Design Studio Generic Analysis template.

Please suggest how can we get this option in Design Studio...

Regards, Dushyant.

View Entire Topic
SATHISH_BTP
Participant
0 Kudos

Hi Dushyant,

In Bex Query keep GL account number and chart of account in Rows and Change Chart of account property as no display not only for this for any compounding Objects which one you don't want see in design studio Keep No Display in Bex Query

Best Regards,

Sathish

0 Kudos

Hi Sathish,

what you said is worked, for that Chart of account should be kept first in ROW then GL account then compounding value will gone..

but doing this un necessary fields keep showing in row even though its not being displayed..