Creating Filters in an SAP based universe

building semantic layer
1

Has anyone successfully created a filter on a date for today(SY_DATUM)?

Example would be all orders created today. Not the current member in the cube but today.

Thanks.

LZorbas (BOB member since 2009-01-23)

2

One option:
Create a filter in your BEX query using an EXIT variable (for today), this filter will come into your OLAP universe.

Andreas :de: (BOB member since 2002-06-20)

3

Thanks Andreas.

I discussed this with our SAP professionals and tested it and found that the EXIT Variable comes after the execution and cannot be used to filter the MDX query itself.

I am trying to create a pre-defined condition that returns the current records based on the Posting Date. Something like [0PSTNG_DATE].[LEVEL01].CurrentMember.Name

LZorbas (BOB member since 2009-01-23)

4

But it does work and gives you the result you need, correct?

Andreas :de: (BOB member since 2002-06-20)

5

Hi,

I am working on Bo xi 3.1 and on OLAP SSAS 2008 database.
I want to create filter as follows :

<FILTER KEY="[TIME Date].[TIME Date].[YEAR]">
<CONDITION OPERATORCONDITION="InList">
<CONSTANT TECH_NAME ="substring(convert(varchar,'12/7/2006',121),6,4)"/>
</CONDITION>
</FILTER>

it is not giving me any parsing error but it is not working as a filter.
I tested with creating a object with definition :

substring(convert(varchar,'12/7/2006',121),6,4)

it is showing correct result but the filter as a whole is not working.

Any one having any idea , please reply .

Regards ,

Gaurav

gauravg :india: (BOB member since 2009-04-27)