Forum Discussion
vopatel
8 years agoFrequent Visitor
interaction between reports from two different queries on same datasource
I have two queries on same datasource/database in Oracle. 1) Returns sales data by sources on a timeline select
(CASE
WHEN
x.SOURCE='Online-Brand'
THEN
1
WHEN
x.SOURCE='Online-Dealer'
THEN
2
WH...
v-xjiin-msft
8 years agoSolution Sage
Hi vopatel,
Based on your queries, even they are using the same datasource, they don't have relationships (Related columns). So with current structure, I'm afraid it is not possible to make interaction between these two queries.
And to achieve your requirement, you need to create related columns in the two datasets first, then create relationship between the two datasets. Something like below sample:
Thanks,
Xi Jin.
To create relationships, you need