how can i do in OLAP universes?

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Didier... Thanks For Reply

I applied this filter but didnt work

[Former Member]

Hi,

Can you detail what it is not working?

Do you have errors? Data is not filtered?

Can you explained what you exactly do?

Didier

[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...