Skip to Content
0
Former Member
Oct 20, 2009 at 08:54 PM

Current Month/Year to default in prompt

18 Views

Hello Friends I have 2 User prompts for report for which i created the filter. where I want to calculate the Month/Year TO value as default to current month/year.

Can u Help me with the code in OLAP SAP BI as backend Universe

substr(TO_CHAR(current_date,1,7))

Above does not work but if I hard code it works

I am trying to default the current month and year

Code that works with hard code 200906 but not with d efault the current month and year

Please correct my code

<OPERATOR VALUE="AND">

<FILTER EXPRESSION="[ZFISCPER].[LEVEL01].[[2ZFISCPER]].[Value]">

<CONDITION OPERATORCONDITION="Betweenl">

<CONSTANT NAME="@Prompt('Fiscal Month start','A','Period\Fiscal Mth',mono,primary_key,not_persistent)"/>

<CONSTANT NAME="@Prompt('Select Fiscal Month','A','Period\Fiscal Mth',mono,free,Not_Persistent,{ '2009/06' },User:0)"/>

</CONDITION></FILTER>

</OPERATOR>

Soniya