Destination App Script logic error

[Former Member]

Hi,

We are doing the data import from the consolidation model to the IC_Matching model through the destination app.

Consolidation Model:                          IC_Matching Mode

Dimensions:                                       Dimensions:

   1.Account                                       1.IC_Account                      

   2.Audit trail                                     2. IC_ Audit trail

   3.Category                                     3. Category

   4. Scope                                        4. Scope

   5.Entity                                          5. Entity

   6 Interco                                         6 Interco

   7.Vertical                                          Blank -No Dimension

   8.Flow                                             7.Flow

   9.Time                                             8.Time

  10.Rptcurrency                                 9.  RTPCURRENCY

Since in the dimension dimension Account we have many GL accounts and only Intercompany transaction related accounts are required in the IC_Matching model. We have maintained a property as “IC” and have maintained “Y” for the same.

Below is the script used for importing the data.

*XDIM_MEMBERSET ACCOUNT = 651110

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET AUDITTRAIL = Input

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET Scope = NON_GROUP

*XDIM_MEMBERSET INTERCO = <ALL>

*XDIM_MEMBERSET FLOW = F_CLO

*XDIM_MEMBERSET VERTICAL = <ALL>

*DESTINATION_APP = IC_Matching

*SKIP_DIM = VERTICAL

*RENAME_DIM ACCOUNT=IC_ACCOUNT

*RENAME_DIM AUDITTRAIL=IC_AUDITTRAIL

*WHEN ACCOUNT

                *IS *

*REC(EXPRESSION=%VALUE%, ACCOUNT=ACCOUNT.IC)

*ENDWHEN

While running the DMP for the same we are getting the below error.

Kindly Suggest.

Regards,

Shilpa

[Former Member · Accepted solution]

Hi Shilpa ,

I can't find where you mentioned your Filter for Account Dimension..?

I hope if you use

*SELECT(%VAR%,"ID","ACCOUNT", "[IC] = "Y"")

*WHEN ACCOUNT

*IS %VAR%

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

It will work .......... I hope so...

And no need to mention *XDIM_MEMBERSET ACCOUNT.....

Aravind

[former_member186338]

Yes, Aravind is correct, but *XDIM_MEMBERSET is also fine:

*SELECT(%VAR%,"ID","ACCOUNT", "[IC] = "Y"")

*XDIM_MEMBERSET ACCOUNT = %VAR%

...

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

Vadim

P.S. And the original error is absolutely clear - you are trying to write result to account "Y"