Dataflow Aggregation not Working

Options
Mark Schad
Mark Schad Customer
First Anniversary Advocate First Comment 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
    Name Dropper First Anniversary Level 100: Foundations of Building in Board First Comment
    edited April 2022
    Options
    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
    5 Likes Photogenic Community Captain First Anniversary
    edited April 2022
    Options
    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
    Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights 5 Likes First Anniversary
    edited April 2022
    Options
    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