Skip to Content
0
Former Member
Apr 23, 2012 at 04:07 PM

Cannot process Dimensions and Multiproviders are missing for applications

32 Views

Hi

We have been doing some testing of BPC based on our recent upgrade to BW730 (SP05) and BPC 753 (SP03) including add/delete appset/application/dimension/dimension property, update dimension property, process dimension, etc

We now face several critical BPC errors including

1.Cannot process Dimensions (per BPC admin client process dimensions; the error message is MDX statement error "system error in program CL_RSR_MDX_METADATA AND"; Failed to expand K2 function for dimension xxx member formulas

2. Multiproviders are missing for applications Freight and planning (per UJE_DATACHECKER)

3. Unable to refresh reports - bpc errors found retrieving data (probably due to above two errors)

Seems like the appset may have gotten corrupted. Tried full optimize of the applications but it did neither recreate the multiprovider nor resolve the dimensions processing issue.

Also found several SAP messages related to dimension processing but they are not applicable to us since we are on a higher version / support pack:

1614252 - Process dimension: Hierarchy and Attribute updates wrongly

1610540 - Cannot process members with hierarchy

1382030 - Cannot process dimension and get the error: "Not enough storage is available to complete this operation" - BPC 5.x

Any thoughts/suggestions ? Have you experienced this type of corruption before ?

Thank you

Catherine