If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos error Gen-Err-0015

Started by suhas_bhat, 19 Nov 2010 09:18:47 AM

Previous topic - Next topic

suhas_bhat

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.

MFGF

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!

suhas_bhat

thanks for the suggestion.  :)

khabaleshri

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.

MFGF

Quote from: khabaleshri 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.

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!

khabaleshri

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.)

khabaleshri

Hi All,

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

thanks