Hey everyone,
I have got huge difficulties with a Report that contains both dimensional and relational data (wrapped up in one package via Framework Manager).
For a start: I would like to create a tree-prompt (based on the dimensional source), that's showing only two hierarchy Levels, 'Article Group' and 'Article'.
Having a formula like children([Article Group]) the prompt will only Show the highest Level, leaving the user being unable to "drill down".
Having a formula like Descendants([Article Group];2) the prompt will only show the lowest (article) level leaving the user with 200+ choices...
On a different report, children([Dimension]) is working perfectly well.. I have no clue, how to solve this.
Anyone already encountered this kind of Problem?
Thanks and regards,
Simon