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

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

    Re: Two Crosstab joins error

    ‏2013-07-05T19:43:26Z  

    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

    Re: Two Crosstab joins error

    ‏2013-07-05T20:37:36Z  
    • OpherB
    • ‏2013-07-05T19:43:26Z

    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

     

     

    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

    Re: Two Crosstab joins error

    ‏2013-07-05T23:06:03Z  
    • Goud2013
    • ‏2013-07-05T20:37:36Z

    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

     

    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

    Re: Two Crosstab joins error

    ‏2013-07-11T17:05:56Z  
    • OpherB
    • ‏2013-07-05T23:06:03Z

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

    Good luck,
    Opher

     

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

     

    Thanks!!!