Waterfall possible with stitched MDX? - RESOLVED? (Just caching issue?)

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).

Perhaps it was just a caching issue? The chart was a long way off on its numbers. But after closing and reopening Apliqo a few times (and making no other changes)… it seems Apliqo has had some time to review a few things, and now the chart is actually looking… correct.

(It was a long way off for a while, and has fixed itself without me doing anything other than closing and reopening a couple times).

Maybe it was some browser caching? But in principle Apliqo UX doesn’t care how the MDX query is structured, it only cares that the shape of the returned query matches the rows & columns layout that the widget type is expecting. For most widgets the table you feed into it doesn’t matter much, but for some widgets like waterfalls and KPIs a very particular layout is needed in order to get the correct results.