I came up with a solution to this business need using javascript.
It seems fairly robust, however I'd be interested if anyone has an alternative approach.
http://www.andrewmosey.com/auto-expand-tree-prompt-in-cognos-10-2-1-5
Hi All,
I have a requirement to auto expand Tree Prompt Level 2 .
Single Hierarchy -> 10 Levels ->
Level 1: All
Level 2: 4 Members
Would like to see 4th Member auto expanded.
Over All, As soon as the User executes the report, the Prompt page Tree Prompt should be Auto expanded until level 2(4th Member).
Please let me know whether there is any possible approach with this requirement- either with Java script or MDX query logic.
Thanks in Advance
Regards
Geetha
as soon as the user execute the report. The Prompt page should be loaded the Hierarchy Auto expanding up to level 2