Using Cached Values without querying again?

[jmmille]

Hi Guys,

I have an accounting type report that shows Sales, CoGS, Commission, etc. The calculations work fine but when I try to insert a data item with the formula "Sales-CoGS-Commission.." to get Total Net Profit, I get a cross join error.

Is it possible to create an excel-like formula that will use the displayed values to calculate net profit without having to requery? I tried enabling cross joins but the report takes 30 minutes to run because of the amount of information we're running it for.

I appreciate it,
jmmille

 

[blom0344]

If you work with Cognos8 then you are stuck without a client. Therefore all calculations HAVE to be performed on the database and in some cases on the server. In a way it is all 'single-pass'. A cross join would indicate a limitation in the Cognos model. In some cases this can be overcome by defining seperate queries and rejoin these in the report definition. You need to talk to whoever build the model..

Ties Blom

 

[jmmille]

I've been building the model along and along as needed. We are new to Cognos so I haven't spent alot of time getting it right. Obviously, I have some joins wrong but I really don't know where.

I already have each calculation in its own query but joining them did not seem to help anything.

Thanks.