Skip to Content
avatar image
Shahid Mohammed Syed

Placing two queries without overlap - Ananlysis for office

Apr 06, 2017 at 06:29 AM | 261 Views | Last edit Apr 07, 2017 at 02:51 PM 6 rev.

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.

SAP Analysis for Microsoft Office
gregor.dieckmann | gerd schoeffl | dirk.mayrock | martin.krtln | torsten.wirth
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Tammy Powlas
    Apr 07, 2017 at 08:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded