I am working a project where I need to build P&L/BS reports in QV. I need to achieve this through MDX. I was able to successfully load information into pivot/straight tables. But as you know pivot does not work for this type of reports.
Our hierarchies spans across different levels, therefore I am forced to create a mapping table that will help QV identify & group accounts into specific categories.
I am struggling with running 'intervalmatch' statement by combining QV syntax with MDX . My query simply fails.
Does anyone have any suggestions or experience with building hierarchies using MDX & QV?