Is it possible to create a waterfall chart in Apliqo with crossjoined columns for the steps?
By this I mean, have two dimensions dropped into the columns section, both set to MDX type. The first dimension will have cross-joined MDX to cherry-pick specific combinations the executives care about. The second dimension will of course have its MDX set to blank string (as it has been defined in the MDX of the first dimension).
As example of what I am trying to do, I want to see the difference in my waterfall chart between Actual and Budget, so I have Actual and Budget set as rows.
Then on columns I have MDX set like this on the [FIN OCoA] dimension. ([FIN BSEG 1] dimension sits in the columns section also, with empty MDX):
{
{
{
[FIN OCoA].[Consulting and Professional services (M)],
[FIN OCoA].[Travel and Accom expenses (M)],
[FIN OCoA].[Telecoms (FV)],
[FIN OCoA].[Occupancy expenses (M)],
[FIN OCoA].[Marketing Expenses (M)],
[FIN OCoA].[6311 - IT- software licences],
[FIN OCoA].[6316 - Hosting],
[FIN OCoA].[6313 - IT - internet IP],
[FIN OCoA].[Computer Supplies and Maintenance (FV)],
[FIN OCoA].[Insurance expenses (M)],
[FIN OCoA].[Other expenses (M)]
} *
{[FIN BSEG 1].[CORE]}
},
{
{[FIN OCoA].[Employee and contractor expenses - indirect (M)]} *
{
[FIN BSEG 1].[Exec and Corp Development],
[FIN BSEG 1].[Marketing],
[FIN BSEG 1].[HR],
[FIN BSEG 1].[Finance],
[FIN BSEG 1].[Compliance and Risk],
[FIN BSEG 1].[Total Admin],
[FIN BSEG 1].[Total Operations],
[FIN BSEG 1].[IT Support],
[FIN BSEG 1].[IT Dev],
[FIN BSEG 1].[Business development],
[FIN BSEG 1].[Rad Recruitment],
[FIN BSEG 1].[Radiologists],
[FIN BSEG 1].[RadOps],
[FIN BSEG 1].[Radcare and Credentialing]
}
}
}
Unfortunately the chart seems to return completely incorrect numbers all over the place.
Wondering if waterfall charts can handle this and I’m just missing something… or is my only option to create a totally new cube where I combine my [FIN BSEG 1] and [FIN OCoA] dimensions into a single dimension? (If it’s a new cube only option then that’s definitely a problem within time limits I’ve been given).