The 'ces_currentmeasure' function is not supported in the context in which it is

[venky18994]

I am getting this error (The 'ces_currentmeasure' function is not supported in the context in which it is used) when i try to create a query by joining two other queries(actually a self join by inserting the required query in another query). both the queries used for joining are running fine but after the join is made, and i run the newly created query the above mentioned error is being displayed.
Thanks in advance,
Venkatesh

[Corrigon]

Is this from a relational datasource?

I've encountered this error before, and it usually occurs if I have data items where I have changed the aggregate properties from the default ('Automatic') to something else (e.g. 'Total') in the source queries.

If so, try changing them back to 'Automatic' in the source queries, and then make the change to the Aggregate property in the joined query.

Hope this helps.
Dave