BEx Analyzer - How to display just one part of the key of an InfoObject

[Former Member]

Hello all,

i've got an InfoObject with characterstics A, B, C and D whereby entries in A,  B  and C are key values. Now I need this InfoObject in a query, in fact only the characteristic C. The Problem is that in BEx Analyzer it is not possible to display only the values of characteristic D.

Example of the result:

"value_1_from_A"/"value_1_from_B"/"value_1_from_C"

"value_2_of_A"/"value_2_from_B"/"value_2_from_C"

"value_3_of_A"/"value_3_from_B"/"value_3_from_C"  etc.

So I want to see in BEx Analyzer just "value_x_from_C".

Other example: i don't want to see "World/Asia/China" but "China".

Is it possible to split the key of A-B-C and display only the values of C? I think I need a work-around, right?

Regards,

Sergio

[former_member182343 · Accepted solution]

Hi,

If you are talking about compounding attributes -  then you can  hide compounded attribute and dispaly actual characteristic.

Suppose South is the region(char) where Country is the compounded attribute. If you display region - automatically country will come.

To avoid this Place two characteristics up and down at Rows panel and select 'no display' for country char.

- rvc

[Former Member · Accepted solution]

Hi,

thanks for answer.

The attribute C is compounding with A and B. At the picture you can see the properties of Attribute C:

"Busines..." = A,  "Versio..." = B, "Get..." = C

I tried to put the InfoObjects A and B in rows and hid them but I still see # instead of values.

Regards,

Sergio

[former_member182343 · Accepted solution]

Hi,

At report level(Rows panel) , keep A,B, C in sequence. Then use  'NO Display'  for A,B.

- rvc

[Former Member · Accepted solution]

if you "filter" objects A & B, they're not shown anymore when you display C

(definition of compounding is that C has no meaning without A & B, if you filter them, you have concrete values for C, so the system doesn't need to show A & B anymore)

[Former Member · Accepted solution]

Unfortunately I need A and B as free characteristics. So I can't hide them.

Is it acceptable to create a new column (= attribute) and fill it by use of ABAP routine with values from attribute C? Then I could add this new attribute to the fronw view.  

Regards,

Sergio

[former_member182343 · Accepted solution]

Hi,

Then its good. You can go with modelling changes and write abap code.

Even simply do direct mapping from source field to one infoobject and use it altogether.

- rvc

[former_member209032]

Hi,

  I think ur infoobjects A and B are compounded with C hence it is being shown as A/B/C. If that is the case put infoobject A and B in rows before C in the report and hide infoobject A and B.

Regards,

Raghavendra.