Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dimension Property Comparison

Hello Experts

I am new to BPC and I am trying to do a comparison using dimension property, but this is performance intensive. Was wondering if there is a work around.

*XDIM_MEMBERSET COMPANY = 207

*XDIM_MEMBERSET DATASRC = %DATASRC_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET ACCOUNTF = %ACCOUNTF_SET%

*SELECT(%DIM_CENTER%,"[ID]",CENTER,"[PROFIT_COST]='C' AND [REL_PC]<>''")

*SELECT(%DIM_CENTER_PC%,"[REL_PC]",CENTER,"[PROFIT_COST]='C' AND [REL_PC]<>''")

*XDIM_MEMBERSET CENTER = %DIM_CENTER%

*WHEN DATASRC

*IS "CPUNIT_DRV"

*FOR %LC2% = %DIM_CENTER_PC%

*WHEN CENTER.REL_PC

*IS %LC2%

*REC(EXPRESSION=( %VALUE% * ([ACCOUNTF].[UNITS],[CENTER].[%LC2%],[DATASRC].[TOTDATASRC])),DATASRC=TEST)

*ENDWHEN

*NEXT

*ENDWHEN

*COMMIT

Thanks

Nikil

Former Member
Not what you were looking for? View more on this topic or Ask a question