How to get descriptions in webi from other dimensions texts

[former_member327592]

Hi ,

I need help please getting descriptions from other dimensions with in the same report .

For example I have a manager field but I have only key in this dimension but i need descriptions for manger from employee text which has key and description.

How can I get descriptions please ?

Appreciate your help.

Thanks

[jyothirmayee_s · Accepted solution]

Hi,

What is the Data source of your WebI report?.

Thanks,

Jothi

[former_member327592 · Accepted solution]

Hi Jyoti,

I am using Bex query as source for this .

Thanks

[jyothirmayee_s · Accepted solution]

Hi,

Then you should see both Key and Text of an EMP attribute.

In WebI, under Query Panel; select Employee and you will key and text as 2 different dimensions.

Bring those into Result Objects and create a variable to Concat both EMP Key and Text.

If it is not available, go to Bex query and display option >> Key & Text.

Thanks,

Jothi

[former_member327592 · Accepted solution]

Thanks a lot for your help Jyoti.

[jyothirmayee_s]

Glad it worked.

Thanks,

Jothi

[former_member327592]

Hi Jyoti,

Thank you for your response. In this scenario, I have Employee key and text but manager field has only keys. In the bex query only Keys are available for manager field because there is no text at all for this field in BW.

Is there a way in WEBI to get manager texts by looking at employee text with lookup manager key = employee key .?

Thanks

[jyothirmayee_s]

Hi,

If you always want to display Manager.text when Emp.key=Mgr.key then , try below formula.

=if([Manager.key]= [Emp.key];[Manager.text)

Make sure the key values are same in Manager and Employee dimensions.

Post a sample data.

Thanks,

Jothi