Skip to Content
0
Former Member
Dec 03, 2009 at 08:30 AM

OLAPLOOKUP

32 Views

Hi,

I try to use in the script an OLAPLOOKUP.

The code in the script look like this:

*XDIM_MEMBERSET GROUPS=LC
*XDIM_MEMBERSET IntCol=Non_InterCo
*OLAPLOOKUP LEGALAPP
*DIM KFEBIT:AccountL="PLMGrossProfit"
*ENDLOOKUP
*WHEN GROUPS
*IS LC
*REC(FACTOR=LOOKUP(KFEBIT),AccountL="KF_EBITDA")
*ENDWHEN

Validation is okay and when I run this script no erros come up. But there is no result.

When I look into the detail log I can see the MDX out of it. This looks like:

select
non empty{[ACCOUNTL.H3].[PLMGrossProfit]} on 0,
non empty{[INTCOL.H1].[Non_InterCol]} on 1
from LEGALAPP
where
([CATEGORY.H1].[ACTUAL],[GROUPS.H1].[LC],[LEGALENTITY.H1].[A=0357],[TIME.H1].[2009.SEP],[MEASURES].[SIGNEDDATA])

This looks for me a little strange. He says that 210 records are generated but all of them are zero.

There are values for PLMGrossProfit, A0357, ACTUAL, LC

So what can I do???

Cheers