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.
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.
thanks for the suggestion. :)
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.
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.
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.)
Hi All,
Anybody help me to achieve above scenario in cube package. can we do it in single query
thanks