on 02-16-2015 10:23 AM
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.
As you do not require any merging of dimension, you can use the measure from query 1 in report 2 directly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.