Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using Cached Values without querying again?
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...- jmmille
- Post #3
- Forum: Cognos solutions
-
Using Cached Values without querying again?
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...- jmmille
- Thread
- Replies: 2
- Forum: Cognos solutions
