Topic
4 replies Latest Post - ‏2013-07-11T17:05:56Z by Goud2013
Goud2013
Goud2013
13 Posts
ACCEPTED ANSWER

Pinned topic Two Crosstab joins error

‏2013-07-05T16:32:28Z |

Hello,

Iam trying to join two crosstab queries for adding of two columns. but iam getting below error .using version c10.1.1. Anyone has any idea ...would be appreciated. thanks!!!!

GEN-ERR-0016

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


GEN-ERR-0009 Data source type(s) '' - Function 'realDataMode' is not supported in 'NoDataModeProvider'.GEN-ERR-0009 Data source type(s) 'OL' - Function 'ces_currentmeasure' is not supported in 'RelationalQueryProvider'.GEN-ERR-0009 Data source type(s) '' - Function 'manyDimensions' is not supported in

 

 

Updated on 2013-07-05T17:22:34Z at 2013-07-05T17:22:34Z by Goud2013
  • OpherB
    OpherB
    664 Posts
    ACCEPTED ANSWER

    Re: Two Crosstab joins error

    ‏2013-07-05T19:43:26Z  in response to Goud2013

    I'm not sure this is possible. What are you trying to do - combine the measure values, display one set of columns and then another set using the same rows...??

    What is the data source?

    Opher

     

     

    • Goud2013
      Goud2013
      13 Posts
      ACCEPTED ANSWER

      Re: Two Crosstab joins error

      ‏2013-07-05T20:37:36Z  in response to OpherB

      thanks for reply Opher.

      Actually implemented a finanical report by using 3 crosstabs.For each crosstab created a totals, then for whole report i need to show grand totals.so iam trying to join those crosstabs to show up the grand total.i don't know exactly if iam doing wrong way or correct way.....if you have any idea suggest me.

      DB2 datasource

       

      • OpherB
        OpherB
        664 Posts
        ACCEPTED ANSWER

        Re: Two Crosstab joins error

        ‏2013-07-05T23:06:03Z  in response to Goud2013

        I have no idea how to do totals across multiple crosstabs...but I'm pretty sure you cannot join the queries.

        Good luck,
        Opher

         

        • Goud2013
          Goud2013
          13 Posts
          ACCEPTED ANSWER

          Re: Two Crosstab joins error

          ‏2013-07-11T17:05:56Z  in response to OpherB

          No luck in doing multiple crosstabs.but it worked in multiple lists.

           

          Thanks!!!