Skip to Content

UJK_VALIDATION_EXCEPTION:Unknown Dimension error

Hi,

I am on BPC 10 NW.

The dimensions and the data is as follows.

PRODUCT_RM PRODUCT_SKU ACCOUNTS TIME INPUTCURRENCY COSTCENTER SALES_GROUP PRODUCT METRICS DISTRIB_CHANNEL UOM VERSION COMPANY SIGNEDDATA NO_RM 000000000000000076 NO_ACC 2014.02 NO_INPUTCURR NO_CC ZD1 000030000200000001 SAL_VOL 10 CS BUDV0_2014 DR01 136.0000000 000000000040000012 000000000000000076 NO_ACC 2013.09 NO_INPUTCURR NO_CC NO_SALGRP 000030000200000001 BOM_VOL NO_DC KG ACTUAL DR01 0.3060000 000000000060000071 000000000000000076 NO_ACC 2013.09 NO_INPUTCURR NO_CC NO_SALGRP 000030000200000001 BOM_VOL NO_DC KG ACTUAL DR01 0.1200000

The requirement is for each PRODUCT_SKU(eg.000000000000000076) get the SAL_VOL(eg.136) and multiply it with BOM_VOL for each of PRODUCT_RM(40000012,60000071) and write it at COGS_VOL.

So, it is SAL_VOL(PRODUCT_SKU) * BOM_VOL(PRODUCT_RM) = COGS_VOL.

The code I tried at UJKT is:

//VARIABLES FOR RM,UOM

*XDIM_MEMBERSET UOM AS %UOM_VAR% =<ALL>

*XDIM_MEMBERSET PRODUCT_RM AS %RM_VAR%=<ALL>

*XDIM_MEMBERSET PRODUCT_RM=NO_RM

*XDIM_MEMBERSET PRODUCT_SKU=<ALL>

*XDIM_MEMBERSET ACCOUNTS=NO_ACC

*XDIM_MEMBERSET TIME=<ALL>

*XDIM_MEMBERSET INPUTCURRENCY=NO_INPUTCURR

*XDIM_MEMBERSET COSTCENTER=NO_CC

*XDIM_MEMBERSET SALES_GROUP=<ALL>

*XDIM_MEMBERSET PRODUCT=<ALL>

*XDIM_MEMBERSET METRICS=SAL_VOL

*XDIM_MEMBERSET DISTRIB_CHANNEL=<ALL>

*XDIM_MEMBERSET UOM=CS

*XDIM_MEMBERSET VERSION=BUDV0_2014

*XDIM_MEMBERSET COMPANY=<ALL>

*WHEN PRODUCT_SKU

*IS *

*FOR %UOM_LOOP%=%UOM_VAR%

*FOR %RM_LOOP%=%RM_VAR%

*REC(EXPRESSION=%VALUE%*([PRODUCT_RM].[%RM_LOOP%],[TIME].[2013.09],[SALES_GROUP].[NO_SALGRP],[METRICS].[BOM_VOL],[DISTRIB_CHANNEL].[NO_DC],[UOM].[%UOM_LOOP%],[VERSION].[ACTUAL]),PRODUCT_RM=%RM_LOOP%,METRICS="COGS_VOL",UOM=%UOM_LOOP%)

*NEXT

*NEXT

*ENDWHEN

But upon validation, it's giving error at *REC saying "UJK_VALIDATION_EXCEPTION:Unknown Dimension Name in Keyword: "[TIME].[2013.09]:"

Can you help me where it's gone wrong?

Regards,
Draksharam

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 11, 2014 at 02:33 PM

    Hi,

    I have found out the error reason. It's due to *XDIM_MEMBERSET UOM AS %UOM_VAR% =<ALL> and when I changed that to *SELECT(%UOM_VAR%,"[ID]",UOM,"[CALC]='N'"), there's no validation error. Now, there's an issue, I have two variables and when I initiate variable with *select for both of them, and run validation, it takes a lot of time for validation at UJKT and fails through validation at the end. It validates well for 1 variable initialized with *select though.

    How can I use two variables and loop through using *select in one logic script?

    Regards,

    Draksharam

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.