Hy experts,
We have a workbook in v.7 with several querys in only one sheet, one below the other.
The problem is when we refresh this workbook and there are more rows for each query.
Then, the first query in the workbook overlap the second.
The system shows the message: "Some Item(s) overlap with each other."
Anybody can tell me how can i avoid the overlap.
We use: BI Support Package 15 Patch 1, version 945
Thanks.
there are two settings on the analysis grid: "suppress new lines" and "AutoFit"
is this what you are experiencing? unfortunately for the BEx objects, they have a fixed starting point (on the top), but can expand down and right (data driven). Are your grids dynamic or static?
Hy, thanks for your answer.
Both querys are dynamic, they can expand down an right.
The problem is the fixed starting point.
In v.3.1 there is no problem. When we refresf the workbook, the second BEx object (analysis grid) don't overlap the first one.
We need to "insert new lines" when the first analysis grid has more lines.
Thanks.
Add a comment