Skip to Content

unknown dimension name in keyword error in bpc 10

*XDIM_MEMBERSET ACCOUNT=PRDCT_QTY,OSD
*XDIM_MEMBERSET PROD_DIM=DPVQTY,PRODQTY
*XDIM_MEMBERSET DATASOURCE = Manual
*XDIM_MEMBERSET CATEGORY = Plan
*XDIM_MEMBERSET MATERIAL=NO-MATERIAL
*XDIM_MEMBERSET PRODUCT=NO-PRODUCT
*XDIM_MEMBERSET COST_CNTR=2-1400CC
*XDIM_MEMBERSET PLANT=P-2000
*XDIM_MEMBERSET TIME=2018.01
*XDIM_MEMBERSET RPT_CURRENCY=USD
*XDIM_MEMBERSET VERSION=Plan-v1
*XDIM_MEMBERSET ENTITY=1002


*WHEN ACCOUNT
*IS *

*REC(EXPRESSION=%VALUE%/([PRODUCT].[NO-PRODUCT],[ACCOUNT].[OSD]),PROD_DIM=DPVQTY)


*ENDWHEN

error: unknown dimension name in keyword [account].[osd]...

same goes for [product].[no-product] when i use it after account dimension in rec statement..

how to use combination of dimension in rec statement...

my scenario is:

i have save values for total working days of plant in account OSD, select product quantity for that specific plant along with cost center, plant and entity in prdct_qty member of account. prdct_qty capture monthly quantity of a product, i want to capture daily quantity by dividing working days of plant and product monthly quantity (prdct_qty) to get daily quantity of that specific group of products of that entity.. we have different entities(plant and cost center are same as entity) and i want to get daily production quantity.. any solution? daily and monthly product quantity are capture in prdct_qty..

formula want to apply:

entity 1000, cost center c-1000, plant p-1000 , product ,A and B and C quantity is 100,200,300 (capture in prdct_qty)

same dimension as above except product, working days of plant is 30, 28 (jan,feb)(capture in osd acccount memebr)

to get daily production

for jan,

100/30 and right it to prod_dim=dpvqty

200/30......

300/30...

same for feb...

same for all entities and its related products...

kindly help me...

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 06, 2017 at 06:22 AM

    Bpc don't like "-" in member id's

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 16, 2017 at 08:26 AM

    Thanks Vadim. My issue is resolved. I appreciated you knowledge about BPC

    Add comment
    10|10000 characters needed characters exceeded