Dataflow Aggregation not Working

Mark Schad
Mark Schad Customer
Fourth Anniversary 10 Comments Advocate 5 Up Votes
edited April 2022 in Platform
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
------------------------------

Answers

  • Nitish Subramanian
    Nitish Subramanian Active Partner
    Fourth Anniversary 25 Up Votes Name Dropper Level 100: Foundations of Building in Board
    edited April 2022
    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
    Bart Scott Active Partner, Community Captain
    Fourth Anniversary 5 Answers 10 Comments 5 Likes
    edited April 2022
    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
    Navan Mehra Employee
    Third Anniversary 10 Comments 5 Up Votes Level 100: Foundations of Building in Board
    edited April 2022
    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
    ------------------------------
    -------------------------------------------

Categories