I'm trying to use OLAP cubes to refactor a legacy application:
the scenario is presenting financial portfolios information to users,
aggregated in various modes. So i created a cube in wich one dimension
is a hierarchy of fields like Country, Allocation sector, Instrument
type, Currency and many other, the other dimension is the PortfolioID,
and just one measure, the amount invested. I can aggregate multiple
measures from a set of different portfolios "MDX side" using calculated
members. This works just fine and quite fast, but my competitor ( the
legacy application ) can easily change the hierarchy order in the
"quality" dimension, for example I can first decompose my view in term
of Country first, and Asset Allocation or in any order the user want.
Unfortunately i have no idea how to achive the same results using MDX &
cubes, is it possible or have I to change completely my solution
approach ?
thnks all