Placing two queries without overlap - Ananlysis for office

[shahid]

Hi,

I am loading two queries starting at A6 and A200 in AO.

My first query has more than 200 records and when the data is loaded, i am ending up with this crosstab overlap issue.

I came across this post and trying to implement this

https://archive.sap.com/discussions/thread/3497125

Question is, will I be able to influence query two starting location?

if query one has 300 records, can we able to place the query two at A306 with the above post? Can we influence the location of query two starting position (depending on number of records) or query two will be placed at A5000 OR A10000 and then we have to hide all the empty rows?

Somehow, I am not able to get the desired results for placing query two at my desired location.

[former_member211603]

Hi Shahid,

Did u find Solution for your requirement. I have same requirement where crosstabs need to place one below other. Second should shift automatically based on extension of first crosstab.

[TammyPowlas · Accepted solution]

Hello - are you using Analysis Office 2.4? You can use the Group Crosstab feature or link dimension feature mentioned here: https://blogs.sap.com/2016/11/28/reviewing-what-is-new-in-businessobjectanalysis-office-2.4/

They place side by side without overlap

[shahid · Accepted solution]

Hi Tammy,

Yes, I am using 2.4.

Thank you for this blog.

- Shahid

[shahid · Accepted solution]

Hi Tammy,

I am able to place the crosstabs side by side.

Is there a way to place one below the other? May be some sort of a setting or by a VBA code?

or is it like the initial place of cross tabs is always fixed?

[TammyPowlas · Accepted solution]

Hi - I only know the side-by-side option; I am not familiar with VBA - that might work.