Skip to Content
avatar image
Former Member

how can i do in OLAP universes?

Hello, I have one question, if you help me on this I am glad about it;

I have a Univers, but I make it from data which is coming directly from BW OLAP. I also make a variable inside it becuasein order to call last 6 month You know, the months are 12 in a year but we make a special term in our coupe for every 3 months and thats why it brings us 16 month.

january, february, march, april, may, june, july, august, september, october, november, december and after that special term 1, special term 2, special term 3 special term 4.

I need these special terms for other universe, but I dont want them here for last 6 month and I want to resrict universe with xml language, but I exactly dont know what to write in codes.

I tried this kind of things (look at the below) but it doesnt work

<FILTER KEY="[Level Object Definition]">

<CONDITION OPERATORCONDITION="NOTLike">

<CONSTANT CAPTION="spec*"/>

</CONDITION>

</FILTER>

Operator : Different from pattern

Universe operator syntax: NotLike

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 06, 2010 at 10:31 AM

    Hi,

    If you don't want to have the "special terms" retrieved then you can add a filter in the where clause of your Period Characteristic L01 like thisn, this is a sample based on Company Code:

    <FILTER KEY="[0D_CO_CODE].[LEVEL01]" >
         <CONDITION OPERATORCONDITION="NotLike" >
             <CONSTANT CAPTION="*IDES*" />
         </CONDITION>
    </FILTER>

    Don't forget that the caption value is case sensitive.

    Didier

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Dider:

      I was able to get it work with one value but my requirement is not to show "*IDES*" as well as "*BPES*"

      How to combine both of these.

      <FILTER KEY="[0D_CO_CODE].[LEVEL01]" >

           <CONDITION OPERATORCONDITION="NotLike" >

               <CONSTANT CAPTION="*IDES*" />

           </CONDITION>

      </FILTER>

      <FILTER KEY="[0D_CO_CODE].[LEVEL01]" >

           <CONDITION OPERATORCONDITION="NotLike" >

               <CONSTANT CAPTION="*BPES*" />

           </CONDITION>

      </FILTER>

      Appreciate somebody can help me in this.Thanks in advance...