on 10-20-2009 9:54 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
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é
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.