FAQ Database Discussion Community


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
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 When the user does not select any value in the value prompt (Cognos Report Portal) and clicks FINISH button, the results include...

Cognos 10 Report Studio: On Page Prompts & Performance

cognos,cognos-10
I have a report page which displays a crosstab. This is filtered by 5 paramaters. These paramaters are submitted by the user through on page checkbox prompts. The requirement is to return the data with all values in all paramaters selected on the first run. If I leave default selections...

Cognos - List report (Relational database) - Summary limitations

cognos
I have a Cognos report with Data like so. User Units TimeInHours UnitsPerHour Smith 10 1 10 Smith 30 2 15 In my report I group by user. I can do a total on Units and Hours, but how can i summarize units per hour? Its not the average 10+15/2...

Cognos session parameters usage

session,parameters,frameworks,ldap,cognos
I have setup LDAP authentication and set up "custom properties" in cognos configuration to get a attribute i have defined in the LDAP entry. For example this custom property is called ORG_NAME, how do i use this ORG_NAME in report studio as a parameter to filter on? I have seen...

IBM Cognos REST Services using C#

c#,cognos,cognos-tm1
I've never used IBM Cognos product. What I need is to make an integration between a custom system and Cognos. I don't know yet the requirements but I have one question: Does Cognos have REST/SOAP web services one can connect to and retrieve data? Or maybe an SDK? How do...

Difference between Cognos Powerplay Client, Powerplay server and Cognos Transformer

cognos,transformer
Can someone please explain the difference between Cognos Powerplay client, Powerplay server and Cognos transformer. I am trying to install Cognos 10.2 on a server. I have the installation software for the below three, but not sure if these need to be installed and if so in which order. 1.Cognos...

IBM Cognos _days_between function not working

mysql,database,date,cognos
I'm having an issue with Cognos 10. I'm trying to calculate the number of days between to dates so I use the _days_between( date1, date2 ) function. _days_between ([Derniere Date Changement diaphragme] , [Premiere Date Changement diaphragme]) I'm quite sure the two Dates are Date objects ( I set them...

Sharing my cognos reports with my peers

report,cognos,cognos-10
I am using cognos 10.2 . I have generated some reports as administrator in report studio. Now I want to share those reports with my peers. When I share the URL of the report I generated, its asking for username and password. I created a user and gave them those...

How to automatically update the IBM cognos Framework manager metadata?

cognos,cognos-bi
I am new to IBM Cognos, I have created a project using DB2 as a data source. When I added some extra rows to my table it's not reflecting into my project. Is there any way to automatically update the database data into Cognos Report studio. Please tell me the...