Dataflow Aggregation not Working

I have two entity trees:

A -> B -> C
and,
P -> Q -> R

I have a cube dimensioned: (Month, C, Q), and I want to populate another cube aggregated by R: (Month, C, R)

When I build the layout (Month, C, R) in a dataview it shows the data the way i need it do, but when I run a dataflow to populate a cube with the same layout, it doesn't write any data.

This appears to be because the data is sitting in cells which intersect with C, but there's no data in the base entity A.

Is there any way around this?

------------------------------
Mark
Developer
Australia
------------------------------

Find more posts tagged with

Accepted answers

All comments

Nitish Subramanian

Hi Mark,

No, there's no workaround for the issue mentioned. You'll have to map at least one member from C to one member of A for your dataflow to work correctly.

Regards,
Nitish

------------------------------
Nitish Subramanian
Senior Consultant
Board Community
India
------------------------------
-------------------------------------------

Bart Scott

Are you doing:

Block Dimensions
A Month, C, Q
B Month, C, R

Formula: B = A

Where B is currently Empty, and A has the data at the level under R (and Q -> R relationship is fully populated)?

Also, what version of Board are you on? For 12 you may need to walk it thru a TEMP cube in your procedures (I have had sporadic issues where going straight from 1 cube to another sometimes works, sometimes doesn't). It will also potentially depend on your settings under Calculation Domain.

Bart Scott
CFO Solutions LLC

------------------------------
Bart Scott
Senior Partner
CFO Solutions LLC
United States
------------------------------
-------------------------------------------

Navan Mehra

Hi Mark,
Have you looked at the sparsity settings of your cubes? Are CQ and CR all sparse in both cubes? Have you tried enabling the "extend" option under calculation domain? That should allow you to overcome it. Please share how it goes

------------------------------
Navan Mehra
Senior Consultant
Board Community
Australia
------------------------------
-------------------------------------------