Skip to Content
0
Former Member
Sep 11, 2007 at 07:42 PM

Poor Performace when we use Structures in ROWS

7 Views

Group,

Business users are complaining about BEx query performance.When we analyzed the queries,we found that it is because of the Char Structures under rows.

Example : Instead of pulling the whole G/L account hierarchy in rows,they made a structure in which each and every selection is restricted to one G/L hierarchy node.All together there are 20 selections assigned to one structure.

This is killing the query performance.Are there any tips available to improve this query performance?

Thanks,

Bobby.