I have a WebI report from query BW data source.
In this report, I have prompts to Material Hierarchy and Regional hierarchy.
1) In query WebI, I put all the material dimensions of hierarchy (3 levels), all dimensions of Regional (3 levels), Day of Calendary and 29 measures .
Run the query by selecting the first node in hierarchies. The consultation runs for about 15 to 20 minutes and appear the message "No data retrieve."
2) If I run the query again, selecting the node below any of the two hierarchies, the query runs about 10 to 13 minutes and returns the data in the report.
In some cases, the report with the same parameters as the first item, occurs "time out".
The universe haven't restrict the rows and the Execution Time
Using BO XI 3.1, SAP BW 7.2