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

Multiple Tabular references

Started by petercade, 06 Feb 2007 07:56:53 AM

Previous topic - Next topic

petercade

Is it possible to create Multiple Tabular references in one query?

I have three seperate reports that cannot be in one query and i need to reference a total value fronm each of the reports and add thyem together.

I have achieved this by creating the three original queries then adding a fourth query that has three tabular models with the same detail to calculate the totals.  I am then able to sum the values.

What I would like to do is add three tabular references to one query this would ensure the underlying data in each query is correct.

:-[

MDXpressor

Yes, you can.  Create a tabular model under the Query.  In the Children section of the tabular model, drop as many tabular references as you like. 

Having said that, do you need to join the tabular references on a particular data item or are you just using a calc summarized to the report level?  If you need to join them, it will be a bit more complicated. 
It's kind of an ugly process; I will go into more detail if you need it.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

petercade

Thanks MDXpressor
I have tried that however i get an error when running the repot saying that the field is not available. :(
I get this even if i only have one tab ref in the tab model

QE-DEF-0030 Expression parsing error.

QE-DEF-0359 The running query contains a reference to at least one object '[].[ADJ $]' that does not exist.

Trace back:

WPBIBusMethod.cpp(197): WPDataRetrievalException: CCL_CAUGHT: WPBIBusMethod::runRequest

WPReportExecutionMethod.cpp(175): WPDataRetrievalException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(169): WPDataRetrievalException: WPExecuteRequestThread::checkException

WPEngine.cpp(1028): WPDataRetrievalException:

WPController.cpp(263): WPDataRetrievalException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(320): WPDataRetrievalException: CCL_RETHROW: LWDataRetrievalEngine::prepare

LWDataRetrievalEngine.cpp(1842): WPDataRetrievalException: CCL_THROW: LWDataRetrievalEngine::runQSQuery

Source/QE_QsApi.cpp(3384): QSException: CCL_THROW: QE



In this report just need to sum three field
I am interested in the join part (but later if i get this to work)

almeids

The empty brackets [] are the clue - you need to name the tabular model of you target query, then edit the data items and fill in the brackets (or delete and recreate them).
Steve