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...
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...
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...
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.
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,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...
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....
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).
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...
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,...
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...
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]) ...
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...
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...