unknown dimension name in keyword error in bpc 10

[Former Member]

*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

[Former Member]

kindly share tag for sap bpc

[Steffi_Warnecke]

If you know what "SAP BPC" stands for, you should be able to find a suitable tag under the first link I provided (the tag browser "Browse the Community"). The tag browser is not yet good for searching for abbreviations for products (like "BPC"), but the "long name" should get you some results.

If you don't know what it stands for, google the term and then check the tag browser. This way you're not depended on someone else to find the relevant tags (having also possible future questions in mind).

.

Regards,

Steffi.

[Former Member]

i got it . thanks.

[former_member186338 · Accepted solution]

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

[Former Member]

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