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

Help with DMR (XQE-PLN-0015 The query is not supported)

Started by Wild Klaus, 29 Mar 2015 06:13:28 PM

Previous topic - Next topic

Wild Klaus

Hi!
I am doing a report that has 2 parameters - a year (prompt) and quarters (promptmany).
The report calculated indicators "Sales" and "Returns" for the selected quarters and cumulatively "RunTotalSales","RunTotalReturns" since the beginning of the selected year to the selected quarter (including).
Example: I selected 2014 and 2,4 quarters. Report shows:
Quote2Q 2014 Sales - 5 RunTotalSales - 10, Returns 0 RunTotalReturns 0
4Q 2014 Sales - 7 RunTotalSales - 23, Returns 2 RunTotalReturns 3

Report build on DMR. Running-total calculated as:
Quotetotal([Sales] within set
periodsToDate([Reports].[SalesDate].[Year_Quarter].[Year],
currentMember([Reports].[SalesDate].[Year_Quarter]))

total([Returns] within set
periodsToDate([Reports].[ReturnsDate].[Year_Quarter].[Year],
currentMember([Reports].[ReturnsDate].[Year_Quarter]))
)

Because there are quarters in which there is no returns and / or there are no sales, then I need to link both computations with the general measurement of time - "Calendar" through Master-Detail relations. But when i made it I have got error:
QuoteXQE-PLN-0015 The query is not supported. It contains a detail filter affecting a hierarchy projected by a relative member function.

Do you have any ideas how to solve this problem or can be otherwise restructure Report?
Thanks!