Skip to Content
0
Former Member
Jan 09, 2011 at 07:11 AM

Webi Report Displaying values as two tables in a single report

34 Views

Hi Experts,

When i drag objects from two different classes and Run the Query, the Webi Report is displaying Values of Objects from those two different Classes in two tables in the same report.

Actually when i had refreshed the structure of the universe, it asked for deleting the outdated joins in the universe, when i clicked 'Yes' some of the joins between some tables got deleted. So, i manually gave a one to many join between the tables where it is necessay and exported.

And when i Drag objects from these two tables, it is displaying values in two tables in the same report.

For example: If we consider 'dim_date' table and 'f_sales' table, when the join got deleted, I manually joined them and exported.

After that when any objects from dim_date table is taken with any other objects and the query is executed, all other objects values are displayed as one table and the objects from dim_date table are displayed as another table in the same report.

What could be the problem, is this because of refreshing the universe structure?

Any Suggestions to resolve this issue would be really of great help.

If any steps to be followed please explain in detail.

Thanks in advance.