Author Topic: Cognos error Gen-Err-0015  (Read 8374 times)

Offline SABreyals

  • Full Member
  • ***
  • Join Date: Aug 2010
  • Posts: 46
  • Forum Citizenship: +0/-0
Cognos error Gen-Err-0015
« on: 19 Nov 2010 09:18:47 am »
Hi all,
   Am facing a peculiar error which goes like
Initially, in data source type(s) '', the function 'source' is not supported in 'TabularOperationProvider'. After decomposition, in data source type(s) '', the function 'source' is not supported in 'TabularFuncProvider'.
Can somebody please tell me how to resolve this.
All i am doing is pointing to a dataitem2 in query2 from within a dataitem1 in query1,
something like this query2.dataitem2.
Please help.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,497
  • Forum Citizenship: +635/-10
  • Cognos Software Muppet
Re: Cognos error Gen-Err-0015
« Reply #1 on: 19 Nov 2010 10:13:25 am »
Hi,

You need to either join or union your two queries into a new query, then refer to items within the scope of just that one query.

Regards,

MF.
Meep!

Offline SABreyals

  • Full Member
  • ***
  • Join Date: Aug 2010
  • Posts: 46
  • Forum Citizenship: +0/-0
Re: Cognos error Gen-Err-0015
« Reply #2 on: 24 Nov 2010 09:36:11 pm »
thanks for the suggestion.  :)

Offline khabaleshri

  • Full Member
  • ***
  • Join Date: Feb 2018
  • Posts: 21
  • Forum Citizenship: +0/-0
Re: Cognos error Gen-Err-0015
« Reply #3 on: 28 Dec 2018 09:00:10 am »
Hi All,

Could you please elaborate on this further as I am too facing same error.
I am working on Cube package and I would like to show diff between current amount and prior amount from 2 different query.
when I join current and prior query for diff then I am getting Gen-Err-0015.
please let me know how to diff query1.current_amount-query2.prioramount from cube package.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,497
  • Forum Citizenship: +635/-10
  • Cognos Software Muppet
Re: Cognos error Gen-Err-0015
« Reply #4 on: 28 Dec 2018 09:50:53 am »
Hi All,

Could you please elaborate on this further as I am too facing same error.
I am working on Cube package and I would like to show diff between current amount and prior amount from 2 different query.
when I join current and prior query for diff then I am getting Gen-Err-0015.
please let me know how to diff query1.current_amount-query2.prioramount from cube package.

Hi,

With a cube package you're unable to join queries, unfortunately. Joins are a relational concept and translate into SQL constructs, but when reporting over a cube there is no SQL - MDX is used instead.

Honestly, though, the capabilities of member-based reporting over a cube should mean you never need more than one query. Can you explain what you are trying to achieve? I strongly suspect there is a better, easier way...

Cheers!

MF.
Meep!

Offline khabaleshri

  • Full Member
  • ***
  • Join Date: Feb 2018
  • Posts: 21
  • Forum Citizenship: +0/-0
Re: Cognos error Gen-Err-0015
« Reply #5 on: 31 Dec 2018 05:06:11 am »
Hi MFGF,

I am looking for two period amount difference. For that, I have created 3 query
1. current amount from current query (data items:LOB_NM, Outstanding amount) where filter : monthid=?month?
2. previous amount from previous query (data items:LOB_NM, Outstanding amount) filter : monthid=?month?-1
3. diff=current- previous

I am new to dimensional modeling. please help me out to achieve above into single query with any dimensional functions(like filter etc.)

Offline khabaleshri

  • Full Member
  • ***
  • Join Date: Feb 2018
  • Posts: 21
  • Forum Citizenship: +0/-0
Re: Cognos error Gen-Err-0015
« Reply #6 on: 03 Jan 2019 05:03:25 am »
Hi All,

Anybody help me to achieve above scenario in cube package. can we do it in single query

thanks

 


       
Twittear