Import with Vertical Extensibility or Extensible Dimensions

Hi,

I can’t get my data import to work with vertical extensibility, and I’d like to understand how this situation is supposed to be handled.

In short, the import validation fails on accounts that are extended for an entity. The entity belongs to a cube that is vertically extended from the primary workflow cube.

Detailed situation

I have extended dimensions and two cubes that use those dimensions.

• CubeParent contains a parent entity with dimensions applied. The parent entity resides in the parent entity dimension.
• CubeChild has dimensions that are extended from the parent’s dimensions. The child entity resides in the child entity dimension.

As a result, each cube has its own unique entity dimension containing its respective entity.

Additional configuration details:

• CubeChild has Is Top Level Cube For Workflow set to False.
• CubeParent is the top-level cube and has the Workflow Profile created from it.
• The child entity has been added as a child of the parent entity in the parent’s entity dimension (see screenshot).

   

• CubeParent has the Cube References tab configured correctly.

Data import issue

I have configured a data source that reads from a CSV file. The data source successfully loads the CSV into the staging area. However, the transformation step fails.

The failure occurs only for the child entity’s extended account, not accounts in the ParentCube account dimension.

The transformation rules when created are associated with a cube.  If the cube is not that of the workflow profile the transformation rule does not appear in the import configuration step.

Question

How should data be imported for an entity that exists in a workflow that has different dimensional detail than the cube it belongs to because it is using vertical extensibility?