Write back in cube after data-entry

Uwe

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

unknown

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