Skip to Content
0
Former Member
Nov 25, 2011 at 05:33 AM

Multi LOOKUP on same cube (or not same)

98 Views

Hi guys!

Is it possible to get slices of data from multiple applications? For example for processing or calculations in other application? Unfortunately multiple lookup doesn't work even from same application:

*XDIM_MEMBERSET CATEGORY = A

*XDIM_MEMBERSET CURRENCY = B

*XDIM_MEMBERSET TIME = C

*XDIM_MEMBERSET ENTITY = <ALL>

..

*LOOKUP APP1

*DIM MEASURES = "PERIODIC"

*DIM CURRENCY = A

*DIM ENTITY = B

...

*DIM S01:B_EXPENSES="S1"

*DIM S02:B_EXPENSES="S2"

...

*ENDLOOKUP

*LOOKUP APP1

*DIM MEASURES = "PERIODIC"

*DIM CURRENCY = A

*DIM ENTITY = C

...

*DIM S03:B_EXPENSES="S3"

*DIM S04:B_EXPENSES="S4"

...

*ENDLOOKUP

...

REC(EXPRESSION=LOOKUP(S01)LOOKUP(S02)/LOOKUP(S03)+LOOKUP(S04))

...