I tried do a search but couldn’t find an answer specific to Deski.
Is it possible to select multiple objects in a subquery? Whenever I select a second object, the Run button becomes disabled. I read that it’s possible in Webi so I’m hoping we could do the same in Deski. Thanks.
klrangel (BOB member since 2004-12-21)
klrangel,
In short this is not possible.
why do you have to select 2 objects in your sub query? The entire point of subquery is lost if you can select 2 objects.
chander165 
(BOB member since 2005-12-20)
Thanks for your reply. This is what I’m trying to do:
SELECT DIM1, MEASURE1, MEASURE2
FROM TABLE1, TABLE2
WHERE
DIM1 = (SELECT DIM1X, DIM2 FROM TABLE1, TABLE2
WHERE …)
Basically I want to be able to display DIM2 together with DIM1, MEASURE1, and MEASURE2 on the report. There are multiple DIM2 for each DIM1 but I want to display only those DIM2 that were picked up in the subquery. Hope this makes sense. 
klrangel (BOB member since 2004-12-21)
You can try adding an additional subquery to your first one…
andrewp (BOB member since 2009-03-17)
I am very Sorry, But I still dont understand.
Say your Table looks like this…
Dim1 Dim2
A X
A A
A Z
B Y
B z
C E
C F
C G
Is there a concatenated column(dim1 and dim2) from table1 and 2?
can you put a example/sample data of what you are trying to achieve?
chander165 (BOB member since 2005-12-20)
yes You can probably do 2 sub queries … 1 for Dim1 and another for Dim2
chander165 (BOB member since 2005-12-20)