merge attributes in bw system or query designer?

[browniejosh]

Hi there

we successfully transferred data from identity management to bw-system.

The Issue now is, that one InfoObject „person_attribute“ has two attributes called „attributname“ and „attributvalue“ which belong together.

Both attributes contain hundreds of different values. Some of them are relevant for reporting.

Example:

Person----attributename----attributvalue

A-----------department--------1

A-----------salutation----------mr

A-----------usertype-----------external

B-----------department-------2

B-----------salutation---------ms

...

This structure is totally confusing.

Now I would like to create a new attribute by merging so that contains specific values out of attributename and attributvalue.

Example:

Person-------department-------salutation-----usertype

A--------------1---------------------mr--------------external

B--------------2---------------------ms--------------....

…

I tried to create variables in query designer for attributename (e.g. department, salutation) but then the values belong to a structure and turn into key figures.

How is it possible to merge these two attributes to a new one?

Or how can I set more than one filter for the same attribute and display it separately?

Dont know if it’s needed for a possible solution but those attributes are type display.

Thanks in advance

browniejosh

[jyothirmayee_s · Accepted solution]

Hi,

Person attribute must be a Infoobject which has display attributes (Dept. Salutation, User tyep and Person). you can enable these display attributes to Navigational attributes in BW.

Within Bex query you can create a structure or display in Row/Columns to show these Nav attributes.

Talk to your BW person to enable.

Thanks,

Jothi