cancel
Showing results for 
Search instead for 
Did you mean: 

Current Month/Year to default in prompt

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You hit one of the major SAP MDX limitation.

Calculated MDX expressions in SAP MUST return numeric values. So in your case the expression is interpreted as string.

Moreover in MDX there is an expression "Now()" that returns the system date but unfortunately this is not supported by SAP.

In fact SAP supports very limited date functions in MDX.

So in your case,, except creating a user exit, I don't see any other workaround until SAP MDX is not improved.

Regards,

Didier

Former Member
0 Kudos

Hello Didier Mazoue . I saw http://www.dagira.com/2007/09/25/dynamic-dates-part-iv-yearly-date-ranges/#more-27

is this going to give u some thought how we can resolve this using Trunc(Sysdate)

Former Member
0 Kudos

Hi,

We know how that we have to improve MDX support to solve current date on SAP BW .

The sample you provided is for Oracle databases and we already support it.

Didier

Former Member
0 Kudos

Hello Didier,

I'am also interested by that topic.

Do know where I can find the MDX date functions supported by SAP (we build our universes on top of BW Infocubes).

And do you have any idea when the enhancement for MDX in order to support additional functions will be released?

Thanks for your answers

André

Former Member
0 Kudos

Hi Didier,

Same comment here.

Very interested to know what the plans are in this area and when it can be expected. This is a very important feauture.

Are there documented best practises available for using user exit's?

We've also been exploring the option to use operating system environment variables to work around the issue (combined with some scheduled scripting). No luck so far in web intelligence (which is needed for OLAP universes).

Please see

Thanks in advance for your thoughts on this!

Raf

Answers (0)