Hello Gurus !!!
I am creating two queries, query1 and query2 . Then its joined with query 3.
Scenario:
Query1 and 2 is used for crosstab. query 3 is used for graph.
I need to add total in crosstab (query1 & query2). when i apply Automatic summary (or) Total , am getting the below error.
Error : The 'ces_currentmeasure' function is not supported in the context in which it is used.
But i need to show the totals in the crosstab. Please suggest a way
Datasource : Relational package
Version : 10.2
Thanks
Shamar
Quote from: Shamar on 28 Jul 2015 10:51:53 AM
Hello Gurus !!!
I am creating two queries, query1 and query2 . Then its joined with query 3.
Scenario:
Query1 and 2 is used for crosstab. query 3 is used for graph.
I need to add total in crosstab (query1 & query2). when i apply Automatic summary (or) Total , am getting the below error.
Error : The 'ces_currentmeasure' function is not supported in the context in which it is used.
But i need to show the totals in the crosstab. Please suggest a way
Datasource : Relational package
Version : 10.2
Thanks
Shamar
I think the piece you missed is in setting the aggregation property for your measure in query 3. My guess is it's set to "Unsupported" at the moment?
MF.