Data sync error in WEBI report

building reports webintelligence
1

I am getting data sync error in WEBI 4.0 version when I try to insert a column in an existing report.

surya_sudheer :india: (BOB member since 2006-11-01)

2

You’re trying to include an object that does fit with the objects that already exist in the block. Either you haven’t merged enough dimensions or they logically don’t belong together.

Please provide more details.

3

Are you merging dimensions? What is the column you are trying to add - is it a calculation?

Possibly using variables from different queries in the calculation.

mikeil (BOB member since 2015-02-18)

4

I am not merging any dimensions as we have only one data source and only one universe (one data provider). In universe joins are parsing and no error is coming on joins. For us there is no need of merging of dimensions as it is a single query

surya_sudheer :india: (BOB member since 2006-11-01)

5

Try removing columns one-by-one from the report. At some point (hopefully) the #CONTEXT will correct itself, and that will indicate which variable is causing the problem.

mikeil (BOB member since 2015-02-18)

6

How many SQL statements does the single query generate?

7

one SQL query for one tab and there are 3 tabs for each report

surya_sudheer :india: (BOB member since 2006-11-01)

8

One query - if you view the SQL, is there only one query generated?

9

The issue is resolved. I have inserted the new join in the existing context and it is working fine

surya_sudheer :india: (BOB member since 2006-11-01)