Variable from different query

[karkia]

Hi,
1. Can I create a variable based on, say Query1, and use the same to compute a Percentage on another Query?

2. WHat if I have 2 queries which return as follows-
Query1
col_1 Percentage
----- ----------
20
30

Query2col
---
50
120

Now, to compute Percentage for Query1, I need to do-
Percentage(20;50)=40%
Percentage(30;120)=25%
How to perform this kind of computation?

 

[blom0344]

In case you have the option to work with linked dataproviders, you should be able to accomplish this. However, I think your web-version does not provide 'linking' .

Ties Blom
Information analyst

 

[karkia]

Hey Blom,
I am using BO WebI XI rel 1. You think this version does not facilitate linking dataproviders? How about release 2?

 

[blom0344]

AFAIK WebI XI R1 is the same as 6.5 WebI.
From what I know there is no 6 version that allows linked dataproviders in the Web versions.


Ties Blom
Information analyst

 

[skrandel]

I can confirm that. You can do this in XI R2 or any version of the client. But nothin in WebI prior to XIr2 can handle this.

Steve Krandel
Symantec