Does anyone know how to select dimension variables from query 2 after the queries are linked for reporting? It seems that only dimension variables from query 1 and measures from both queries are available for selection. The dimension variables from query 2 are greyed out. Your help would be most appreciated.
Lucia Chan
Listserv Archives (BOB member since 2002-06-25)
In a message dated 00-04-05 17:02:43 EDT, you write:
Does anyone know how to select dimension variables from query 2 after the
queries are linked for reporting? It seems that only dimension variables from query 1 and measures from both queries are available for selection. The dimension variables from query 2 are greyed out.
The only objects available from query 2 will be:
a) Dimensions linked to an equivalent dimension from query 1 b) Detail objects
c) Measure objects
Dimension objects that are not linked are not available. Dimension objects are assumed to be “keys”, and if you do not link (join) all of the key files you can end up with invalid combinations of data.
If your dimension objects should have been defined in Designer as detail objects, then you can create a new variable in your document and reclassify the information as a detail. At that point it is available. However, you have to understand your data and be sure that this is - in fact - a valid operation.
To redefine a dimension as a detail:
Again, you have to be careful that this results in a valid result. If the object was a key field and was not linked, unpredictable results can occur.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)