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. :(
Quote from: newb2cog on 04 Jun 2014 03:53:52 PM
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.
Yes. Did same as above. :)
Gross Amount tuple([Purchase],[Trade Amount Daily])
Redemption Amount tuple([Redemption],[Trade Amount Daily])
Thanks.