Skip to Content

Hi All,

I have the following issues with WEBi report selection input parameters (prompts) that use BW BEx Query variable. Could anyone please assist?

As I am having Bex variable i.e.Fiscal year/Period with options – “Single value and Optional” and its display properties as “Text” and Text view is “Medium-Length Text”.

When we running the Bex query the data is getting like…Jan-11, Feb-11, Mar-11 (Correct data)

But where as in WEBi Reports in the prompt level it is showing data as 01.2011, 02.2011,…like Key data (Wrong data).

Fiscal year/Period Condition syntax is below:

<OPTIONAL><FILTER KEY=”[!V000006]”><CONDITION OPERATORCONDITION=”Equal”><CONSTANT TECH_NAME=”@Prompt(‘Fiscal Period’,’A’,’Fiscal year/period\LovFiscal PeriodBase’,mono,primary_key)”/></CONDITION></FILTER></OPTIONAL>  

The Requirement is as follow……The WEBi Prompt data should be Jan-11, Feb-11, Mar-11… as per Bex report.

Can you please help us…..

Regards,

Raghavendra

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. lucas jose pineda perea

    Hi,

    Raghavendra ,


    Only Change in Dimension,’Fiscal year/period\LovFiscal PeriodBase’,


    Edit Select: [!V000006]


    /wp-content/uploads/2015/01/antes_622291.png


    change for you Dimension Medium “L01 Period type Medium Name” only SELECT into “LovFiscal PeriodBase”


    Medium.png


    After for you dimension “LovFiscal PeriodBase”.


    /wp-content/uploads/2015/01/despues_622398.png

    Result 🙂 ,



    /wp-content/uploads/2015/01/resultado_622399.png

    (0) 

Leave a Reply