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