Link the result from another query in another report.

[Former Member]

Hello hi,

I have a Web Intelligence document and inside this document, I have two reports from two queries.

So, query 1 generates report 1 and query 2 generates report 2. However somehow I need the total figures in report 1 to be part of the calculation in report 2.

For example, in report 1, there are three rows

A $1

+B $2

+C $3

= Report 1 total =$6

And in report 2, I have something like this

D $4

+ E $5

+ Report 1 total $6

= Report 2 total $15

Thanks.

[arijit_das · Accepted solution]

As you do not require any merging of dimension, you can use the measure from query 1 in report 2 directly.

[Former Member]

Hi Matthew,

You need to understand how web intelligence works. The reports and queries are not tightly coupled. You can consider each query result as a database table and consider the report as a workspace that displays the data based on the objects from one or more queries, either discrete or together.

If we consider each query as a database table, I hope that you understand the need of joining them based on common attributes so that your results are not extrapolated (cartesian).

A report in webi can have multiple blocks (such as tables, cells, charts) that gets data from one or more data providers.

Cheers

Mohan