Hi
I'm having trouble replicating the cube through MDX.
I need to show the aggregate Cash Inflow Excluding some of it's child.
I have a "Cash Inflow" hierarchy like this.
Cash Inflow $100
-Inflow Application $30
-Inflow Adjustments $20
-Inflow Claims $10
-Inflow Rollover $40
Im my cube I will untick the "Inflow Rollover" in the filter. I will get Cash Inflow with a value of $60.
How do I write an MDX, so that when I call "Cash Inflow", it will return a Cash Inflow value excluding the "Inflow Rollover"?
My basic query is below, I need to modify the Cash inflow part. So that it doesn't return a total value of $100, but a subset value of $60 (exclude "Inflow Rollover")
select non empty{
crossjoin(
{[MTD],[YTD]},
{[Opening BAL],[Cash Inflow1],[Closing BAL]}
)
} on columns,
non empty{
crossjoin(
[Reporting Group],[BU Sales Reporting Group 02]
)
} on rows
from [CUBE]
where
(
[Period].[Period by Financial Year].[Period].&[201312],
[Measures].[Amount]
)
Thanks, if anyone could point me to the right direction
Gemmo1
- Edited by gemmo1 8 hours 43 minutes ago