Do you mean that Impromptu formulates a separate query to calculate a total?
Oh yeah. Every single time. It doesn't matter how you define the total either. You can do it in the Data tab or you can do a data insert after the report runs and define the total that way. Then you look in the SQL...
This will take you into the "Magic Query" window where you will see what the "true" SQL is...
Hey, that's cool! In this window it shows that the SQL is using the date prompts. So why doesn't it show that in the SQL window?
Thanks again for that.
Database only in Client/Server Tab gives the error:
Cannot execute query.
Processing requirements exceed the current Client/Server limits.
=========================================================
It won't let me edit the SQL. Because the report has totals it sends two queries; one for the...
It looks like an outer join was used in Impromptu but not in FM.
I'm not using FM or Report Studio yet. Can you see the SQL? If you can, and there isn't an outer join, I would look at the Impromptu SQL.
I noticed that some reports filter a date range in the database while others return a brazillion records and then filter on the PC.
For example. If I use:
and ( Transaction Date between ?Start Date? and ?End Date? )
No date filter is in the SQL!
If I use:
and ( Transaction Date >= ?Start...
We are going to start bringing GL data into CF and CP via ODBC. The question I have for anyone doing this is: Have you been able to modify the scripts/process to automatically create new accounts in Cognos?
Currently when we do the GL Extract if a new account was created in Oracle that we don't...
Thanks. The Metadata Modeling course is being held in April so I will probably take that one. (Part 1 and Part 2) My boss wants me to take Cognos Planning 7.3/8.1 Technical Administration so I might be in that one this month.
Thanks again.
Most of the classes seem to be for Finance people or report developers. I'm new to Cognos and our company would like to move from a Finance-Installed Series 7 to an MIS-Installed Cognos 8. I'm the lucky guy who gets to configure the entire enterprise.
Can anyone recommend any classes that cover...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.