We have a hierarchy on profit center. We created an authorization hierarchy node variable on this hierarchy and when the user runs the report his authorized region will come up in the selection screen. When we want to choose another sub region present below the node by clicking on the small box on the right of the variable entry (in Portal), it takes for ever to show the hierarchy. In the back end we see that the SID table of the Profit Center is read sequentially. Any idea how to fix this.
We are on BI 7.0 SP 13 and Java Stack 12.
Thank you for you time,