Dimensional Calculation.

[sujitgouda]

I have a dimensional model with the following details.
Transaction Type: Purchase, Redemption
Measures: Daily, MTD, YTD

I would like to calculate value for Daily Gross and Daily Net; where Daily Gross= (Daily in Purchase) and Daily Net= (Daily in Purchase & Redemption)

I am trying to create a List report, but I am unable to calculate for Daily Net. It always gives same value as Dail Gross. :(

[MFGF]

I have a dimensional model with the following details.
Transaction Type: Purchase, Redemption
Measures: Daily, MTD, YTD

I would like to calculate value for Daily Gross and Daily Net; where Daily Gross= (Daily in Purchase) and Daily Net= (Daily in Purchase & Redemption)

I am trying to create a List report, but I am unable to calculate for Daily Net. It always gives same value as Dail Gross. :(

Ok. All good so far. You haven't told us, however, any details of how you are currently trying to achieve this. Are you using calculations? If so, what expressions are you using?

If it was me, the Daily Gross would be a query calculation with the expression tuple([Daily],[Purchase])
Daily Net would be aggregate([Daily] within set set([Purchase],[Redemption]))

I would always use a crosstab with a dimensional package, not a list.

MF.

[sujitgouda]

Yes. Did same as above. :)

Gross Amount   tuple([Purchase],[Trade Amount Daily])
Redemption Amount   tuple([Redemption],[Trade Amount Daily])


Thanks.