Skip to Content
0
Former Member
Sep 06, 2013 at 07:46 AM

Logic Script Problem in Member

20 Views

Hi Guys,

I need help regarding this Logic Script Code. Its a pretty complicated.

Below are our sources and DImensions Table. I need to Transfer data from one to another. one of the main Problems is the under INVENTORY dimension, It has a Property PROJECT which I need to connect and Map to the PROJECT dimension in the PRO_CASHFLOW Model.

SOURCE: PRO_INV

ACCOUNT

CATEGORY

INVENTORY

MODELS
PARAMS
PREMIUMS
TIME

DESTINATION: PRO_CASHFLOW

ACCOUNTS

CATEGORY

PROJECT
RATE
TIME

CODE:

*XDIM_MEMBERSET ACCOUNTS="INVENTORY"

*XDIM_MEMBERSET PARAMS="EMPTY_NULL"

*XDIM_MEMBERSET PREMIUM="EMPTY_NULL"

*XDIM_MEMBERSET MODELS="EMPTY_NULL"

*XDIM_MEMBERSET CATEGORY="PLAN"

*XDIM_FILTER INVENTORY = [INVENTORY].properties("BASE_LEVEL")=P

*DESTINATION_APP = PRO_CASHFLOW

*SKIP_DIM = MODELS

*SKIP_DIM = PARAMS

*SKIP_DIM = PREMIUM

*SKIP_DIM = INVENTORY

*ADD_DIM RATES=PHP

*ADD_DIM ACCOUNTS=EQUITY

*WHEN CATEG

*IS PLAN

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

I was thinking of copying everything in the PRO_INVENTORY Model as long as the BASE_LEVEL Property is in P level(which mean project level)

we are using BPC 10