Write back in cube after data-entry

Uwe
Uwe Customer
Fourth Anniversary First Comment
in Platform

Hello,

 

i have a simple question:

I have a dataview per Month and Values with the option to enter Data.

After the user save the entry, i wand to fill a cube with the percent of the total for each month, because i need them for further calculations.

 

Jan      10.000      22,2%

Feb      15.000    33,3%

Mar      20.000   44,4%

 

Total 45.000      100%

 

I have testet different functions a/dt(a) etc. but it doesn't work

What i'm doing wrong?

 

Kindly regards

Answers

  • Unknown
    Unknown Active Partner

    Hi Uwe Lueers,

     

    I assume you are trying to run this through a dataflow in a dataentry trigger.


    Probably you will need a help cube in this situation which doesn't have the dimension of the month and split the dataflow in two separate dataflows.

     

    An example:
    Data entry cube called "ProdBudget" has two 2 dimensions: Product-Month
    Your help cube called "ProdBudgetHelp" has 1 dimension: Product
    Your target cube called "ProdBudget%" has 2 dimensions: Product-Month

     

    1st step: Dataflow: "ProdBudgetHelp" set equal to "ProdBudget"
    2nd step: Dataflow:. "ProdBudget%" set equal to "ProdBudget"/"ProdBudgetHelp"

     

    Let me know if this clarifies your doubt.

    Cheers,
    Jonathan

Categories