Skip to Content
0
Jul 23, 2019 at 01:35 PM

merge attributes in bw system or query designer?

97 Views Last edit Jul 23, 2019 at 01:38 PM 2 rev

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