How do I create a summary data item in Cognos Report Studio?
sql,cognos,cognos-8,cognos-bi,cognos-10
Can you help me understand how to write SUM (ORIG_AMT) AS PARTICIPATION_ORIG_AMT Group by LEAD_ACCT, PART_FLAG in Cognos Report Studio? The equivalent in a Cognos expression would be: total([ORIG_AMT] for [LEAD_ACCT],[PART_FLAG]) ...
IBM Cognos _days_between function not working
The Cognos _days_between function works with dates, not with datetimes. Some databases, like Oracle, store all dates with a timestamp. On a query directly to the datasource, try using the database's functions to get this data instead. When possible, this is always preferable as it pushes work to the database,...
Sharing my cognos reports with my peers
In Cognos Connection, open the report's Properties. On the right-hand side there is a link to 'View the search path, ID and URL'. If you click on this link, a popup appears; you can copy the value under 'Default Action URL' and provide that to your peers, and it will...
Cognos 10.2 Using row values in prompt to filter another prompt
You need to create Cascading Prompts. Create two prompts. The first links to a parameter, lets call it Parameter1. Your second prompt has a Cascading Source set to Parameter1. When creating the the second prompt, you have the option to create a 'Parameterized Filter'. Use that option to set what...
Cognos - List report (Relational database) - Summary limitations
You can build it yourself if you don't want to total the other columns. Add a query calculation in your footer. It will be total(Units for report) / total(TimeinHours for report).
Backport Cognos Reports to Durable Model
report,business-intelligence,cognos,cognos-bi,cognos-10
To make all reports "durable" you must re-build them by opening and re-dragging each query subject item into the report in place of the existing item. This resets the reference to the design language name. There is no easy way to do it. However, all future development will be durable....
Cognos 10 Report Studio: On Page Prompts & Performance
One option is to use JavaScript to check all of the checkboxes after the page is rendered with no filtering applied. To do this all filters have to be set to optional. The page is rendered with all data and unchecked checkboxes. The JavaScript fires and checks all checkboxes so...
Is there any way to avoid the top rows with NULL values that has one column value (One of the table Business Key) in Cognos report prompt values
sql,cognos,cognos-10,cognos-bi
I'm a little bit confused as to what you want to achieve. However, if you simply want to filter out the rows that have NULL for column 1 and column 2 even if the user doesn't pick a value from the prompt then your filter could look something like this...
IBM Cognos REST Services using C#
You'll need to use Cognos mashup services which is part of Cognos SDK: http://www-03.ibm.com/software/products/en/cognos-mashup-service The documentation of this product is not available in public URL and it is available only as part of the Cognos SDK installation. However you get a hunch on it in here: Get started with the...
Difference between Cognos Powerplay Client, Powerplay server and Cognos Transformer
Transformer is used to design and build cubes. Powerplay Client is a desktop tool for reading the cube. Powerplay Server is exactly what it sounds like. How you intend for your users to interact with the cubes determines what you need. You must have Transformer to build cubes. The others...
How to automatically update the IBM cognos Framework manager metadata?
If its rows you are adding to your Query subject, they will automatically update in your framework manager metadata. You can check it by using Test tab.
Performance tuning in Cognos Report Studio
cognos,cognos-8,cognos-bi,cognos-10
I was able to get this resolved myself after many trial and errors. What I did is created a copy of 1st Query item, and filtered 1st query item with current month and year and the for the copy of 1st query item added a filter for two months. That...
Cognos session parameters usage
session,parameters,frameworks,ldap,cognos
You can use the same syntax you would use in FM. So, for example: #sq($account.personalInfo.givenName)# will return the first name, and so on. If you feel some burning need to for user-written SQL, instead of using FM, you can include the macro as a query item in your "outer" query...
How to get the report between certain date range in Cognos
sql-server-2008,datetime,timestamp,cognos,cognos-8
Cognos has an add months function. (At least, Cognos 10 does.) In your expression editor, on the functions tab, it's under Business Date/Time Functions. It's called _add_months. So your function would end up being something like between (_add_months(1,current_date)) You can also use the SQL Server function. You have to put...