SAP Knowledge Base Article - Preview

2263130 - Transformation file validation shows successfully complete even there is a invalid item

Symptom

When validating master data with a transformation file via the Validate & Process Transformation file data, in BPC 10.1 SP07 or SP08 the system does not return an error when there is a mismatch member ID in the transformation file. Moreover, although the validation shows the task was successfully completed, there is empty when click the Output file in the View Option tag.
In BPC 10, the system returns an error "Dimension member xxxxx is an invalid member ID"

Scenario:
When a customer is validating a transformation file within the BPC 10.1 NW version this is validating even though the source file has invalid data within it.

Example:

  • When creating a dimension member within BPC 10.1 NW though the web page it is not possible to create a dimension ID that includes a '+' character directly within BPC 10.1 NW. e.g.BS214+
  •  However there is no rejection when using the Data Manager package and testing a transformation file to load Master Data from a data file where one member has an ID of BS214+ listed.

BPC 10.1 NW:
- Validate has successfully completed
- Validate Records = YES
- Reject count: 0
- Record count: 7
- Skip count: 0
- Accept count: 0

  • When running a Data Manager package this will execute and generate a warning however no rejection is seen.

BPC 10.1 NW:
- No 1 Round:
- Reject count: 0
- Record count: 7
- Skip count: 0
- Accept count: 0
- Submit count: 0
- model: Consolidation. Package status: WARNING

  • Within BPC 10.0 NW SP19 when trying to validate a transformation file with an ID that contains an invalid character such as BS214+, this will be rejected and the validation fails.

- Validate Records = YES
- Error in Admin module or a component used by Admin module
- Dimension member BS214+ is an invalid member ID in dimension ACCOUNT


Read more...

Environment

SAP Business Planning and Consolidation 10.1 for Netweaver Support Package 07 and Support Package 08

Product

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

KBA , EPM-BPC-NW-DM , Data Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.