emeadaxsupport: Error during data import, when using multiple entities in one Processing Group that have different financial dimensions

[Blog bot]

Источник: http://blogs.msdn.com/b/axsupport/ar...imensions.aspx
==============

Consider the following scenario:

You will get an error "Unable to return DimensionAttributeValue record for xxxxxx",

when　using the DIXF tool to import data and have multiple entities in one Processing Group

that have different financial dimensions.

The Problem is that, the system always takes the first source data format for the "Copy data to target" step.　

The simple scenario is:

　

1.　Create a Processing Group

2.　Create 2 entities in that processing group (i.e. Customer and Items)

a.　It is needed to have 2 entities with different Financial dimensions

and different source data formats

3.　Get the staging data

a.　Your data should have the Field "DefaultDimensionStr" filled

4.　Copy the Data to target

5.　Now you are getting the error :

"Unable to return DimensionAttributeValue record for xxxxxx".

Workaround suggestion:

Go to \Data Dictionary\Tables\DMFDataSourceProperties\Methods and create a new method.

Overwrite the new created method with following code snippet:

public

static DMFDataSourceProperties wdxFindByExecIdDefGroupEntity(

DMFExecutionId _execId,

DMFDefinationGroupName _defGroup,

DMFEntityName _entity)

{

DMFDataSource dmfDataSource;

DMFDataSourceProperties dMFDataSourceProperties;

DMFDefinitionGroupExecution dFDefinitionGroupExecution;



if (_execId && _defGroup)

{

selectfirstOnly1 ExecutionId, DefinitionGroup from dFDefinitionGroupExecution

where dFDefinitionGroupExecution.ExecutionId == _execId

&& dFDefinitionGroupExecution.DefinitionGroup == _defGroup

&& dFDefinitionGroupExecution.Entity == _entity



join SourceName from dmfDataSource

where dmfDataSource.SourceName == dFDefinitionGroupExecution.Source

join dMFDataSourceProperties

where dMFDataSourceProperties.Source == dmfDataSource.SourceName;

}

return dMFDataSourceProperties;

}






3- Save and compile

4- Got to the \Classes\DMFEntityWriter\write method and change the code as shown below:

//Before

//dmfDataSourceProperties = DMFDataSourceProperties::findByExecIdAndDefGroup(_executionId,_definitionGroup);

//After
dmfDataSourceProperties = DMFDataSourceProperties::wdxFindByExecIdDefGroupEntity( _executionId, _definitionGroup,_entity.EntityName);





5- Save and compile

6- Do an Incremental CIL generation




Источник: http://blogs.msdn.com/b/axsupport/ar...imensions.aspx