How to turn on Key,Text & Medium tex for objects used webi report

[Former Member]

Hi there,

Created webi report by using Web Intelligence through BI Launch Pad. Environment is BI 4.0. Data source is Bex query connection thorugh BICS method.

Below given screen is the webi report, i have 3 question on this report. could you share me your idea/experience.

1st Question: When run a query in Bex Fiscal Year coloumn is displaying Key value like 2011, 2012 & 2013. where as it is Medium text and Key , instead of key when fiscal year object is called and used in webi report. How to disply key instead of medium text and key.

2nd Question: If you see 2nd column from below screen shot, it is displaying Dimension Discription and Techinican Name ( Project Type(ZCO_CTITM__0PS_PRJTYPE). however bex query is showing only description. How to show only dimension discription as column...?

3rd Question: I dont want to diplay WBS Hierarchy as a column. I want to show only "WBS". How can i do thi...?

[Former Member · Accepted solution]

What ever output you are gets in your webi reports, this is based on the objects property set in cubes level. If year is set as Text, you will get text in BO. you need to set the query/cube property so that you will get the keys and text both in BO when you try to create report on BeX.

[Former Member · Accepted solution]

Hi Rachna Jain,

I dobule checked properties at the info cube and Info object and Query level where found as "Text" . But webi report is showing medium text & key for 0FISCYEAR.

[jyothirmayee_s · Accepted solution]

Hi,

Output depends on objects you have selected. Please also post Query panel.

1st Question: When run a query in Bex Fiscal Year coloumn is displaying Key value like 2011, 2012 & 2013. where as it is Medium text and Key , instead of key when fiscal year object is called and used in webi report. How to disply key instead of medium text and key.

>> You can truncate to display only year using a substr() or right() function in webi.

2nd Question: If you see 2nd column from below screen shot, it is displaying Dimension Discription and Techinican Name ( Project Type(ZCO_CTITM__0PS_PRJTYPE). however bex query is showing only description. How to show only dimension discription as column...?

>> This might be coz of 2 reasons.. check if BEx query has a duplicate descriptions for different infoobject or check "Standard" display of an Infoobject.

3rd Question: I dont want to display WBS Hierarchy as a column. I want to show only "WBS". How can i do thi...?

>> Select the higher level Dimension of WBS infoobject than selecting a hierarchy based.

Check the WBS properties if "Hierarchy" property has been enabled. if you do not want then uncheck the option.

Thanks,

Jothi