save quarter value in a monthly cube

andreaLin....
andreaLin.... Active Partner
Board Developer Name Dropper First Comment
in Platform

Hi all,

I have a cube with a Quarter dimension, and I want to transfer the value to a Monthly cube, specifically in the last month of each quarter.
I tried with the dataflow but each month of quarter will be populated.
I hope you can help me

Andrea

Tagged:

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 4 Answer ✓

    Hi @andreaLin.... ,

    you would need a cube structured by month that has a 1 for each month that is the last one in the quarter.

    Example

    image.png

    In a dataflow you'd then multiply the quarterly values with this marker-cube into the monthly cube.

    image.png

    Result:

    image.png

    Best,
    Helmut

Categories