Hello, strange error I have repeatedly run into:
message severity="error"
title=OP-ERR-0110
The query='qPrompts' referenced in queryResultDefinition='qDashboard.22' does not exist in the querySet.
type="executionStats"
It happens when I attempt to reference a data item used in the prompt selection query within a different query, in this case 'qDashboard' in the form of '[qPrompts].[dataItem1]'.
Very frustrating error, any help diagnosing would be very appreciated!
moved to correct forum
Hi,
So you're trying to reference an item defined in one query from within another query? Have I understood correctly?
If so, in order to do this you will need to join the queries and bring the desired items from each into a third query. You can then address all the relevant items from there.
Cheers!
MF.
Hi MFGF, you have indeed understood correctly.
Thanks for the reply. It's odd to hear I need a join, because in a number of our reports (active and non-active) we have one query for prompt selections (date ranges, etc) named 'qPrompts'. Any Data Item (let's say 'Dates') in the qPrompts query are usually referenced in other queries with no issues by writing [qPrompts].[Dates].
The only way you would manage without a join is if you enabled Cross Products, which is generally not a good thing to do.
Cheers!
MF.
Does it make a difference that the source is a power cube, using dimensional queries rather than relational?
Hi,
Yes - it does make a difference. Queries from dimensional sources can't be joined - joins are a relational rather than dimensional concept.
Cheers!
MF.
Okay thanks for the follow up!
Have a good weekend.