Skip to Content
0
Former Member
Jan 30, 2007 at 11:51 PM

Calculate key figures totals in report based in multiprovider doesn't work.

17 Views

Hi dear Friends:

We have a requirement where the data are in 2 different cubes, the layout defined is

selections parameters :

Zsales_offices

0calweek

Columns.

0calweek KFCalc1..............................KFcalc2.....................etc.

In rows.

01.2007 Qty on demand X unit cost. sum of all qty's prods

02.2007

03.2007

04.2007

the structure in cube z1mis contain:

Zsales_offices,product,0calweeek,unit cost.

the Second cube structure zdemand contain:

Zsales_office, product,0calweek,qty on demand

Our problem is:

1. As you can see we need keep into KFcalc1 the product from multiply Qty on demand * unit cost but when the result is displaying the result is a wrong amount and the reason is because didn't´t exist a characteristic product in the layout, without this characteristic the amount for qty on demand and unit cost are summarized and multiplying with these amounts.

We are trying to find a solution vía restricted key figures, calculating before aggregation, but it's not woks.

I hope that you can give one suggestion.

Regards.

Eg@n