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