I have a simple list report in Cognos 8.3. I have a field with things like this: ETLJobX Completed - SUCCESS ETLJobY Completed - FAIL ETLJobZ Completed - SUCCESS ETLJobA Completed - SUCCESS ETLJobB Completed - FAIL I have a conditional formatter set to color the successes in green and failures in red. Works perfectly. Using the con...
Reports against an SSAS 2005 cube with Currency formatted measures. In Cognos 8.2 a $ is properly displayed. In Cognos 8.4 an * is displayed instead of a $. Have you encountered this problem, and how have you worked around it? ...
Hi, I've value prompt with ui:checkbox group parameter: p_IsLastMonth Name: Prompt_IsLastMonth ItemCount: 1; UseValue:Yes, DisplayValue: LastMonth? and two Date Prompts. Whenever the checkbox is checked, the UseValue 'Yes' is passed to the parameter 'p_IsLastMonth'. But whenever the checkbox is left as it is, it results in an error. ...
I have done a course in Data warehousing and Mining and i am interested in going the Cognos BI way. However, i need to practice on data which i cannot find. Can someone please guide me on getting myself aquainted better with cognos ? I need sample data to work on. Where do i find it ? ...
Hi everyone ! Does anyone know if there is any tool or a way to apply automated unit testing in report studio and/or framework manager ? When some regression tests are required and I need to run report by report, on the traditional way, it really bothers me. Best regards, Evandro ...
I need to configure MS AD for using with Cognos 7 series. According to documentation, Base Distinguished Name (Base Suffix) is required for Access Manager configuration (it was entered when creating Data Directory Server) Please let me know, how can i configure Data Directory Server and where i can put Base Distinguished Name. Thanks i...
I am trying to change multiple columns based on one value prompt in report studio in a cube (running cognos 8.4). A prompt with a prefix would be a perfect solution but I cant seem to make it work. Typically I get a "Parsing error before or near position 4" even tho I can see its the exact name of a data item in the query. I have one v...
Hi All, I really would like to know how i can set my application 'Cognos8' as startpage when just typing the host name of the server. When i now type my hostname 'http://myhost' i get the iistart.htm page instead i would like to be able to get 'http://myhost/Cognos8'. tried http redirect to redirect myhost to myhost/cognos8 which ends ...
Hi,I am trying to find a way to filter hierarchy by level in Cognos Report Studio..e.g. I have a hierarchy of org. units, and I'm creating a report on expenses per org. unit, and I want to see expenses of all level 1 org units, and all level 2 units, and all level 3 units etc. (each level separately). Like if I aggregated data for let's ...
Hi All, Is it possible to calculate a percentage change in a Cognos Report? Currently, I have a crosstab that has years as the columns and widgets in the rows with a calculation of total revenue. I am looking to calculate the annual % increase. New to Cognos, but I could accomplish this using other tools. Any help will be very muc...
Hello can i do something like this in cognos impromptu administrator 7? http://stackoverflow.com/questions/2654750/multiple-aggregate-functions-in-one-sql-query-from-the-same-table-using-different ...
Normally you can add a query as a new data source in Cognos PowerPlay (I'm running PowerPlay version 7.3), but when I try to do so I cannot select any queries from my Access database. The dropdown menu which normally shows the existing queries in the database is empty. When I add a table as a new data source it works fine, and all the ta...
Is there any article or documentation describe converting Cognos model to Report Model for Microsoft reporting server? ...
We just migrated a report from Cognos reportnet to Cognos 8.4 and the report is too slow now. The report just has a crosstab nested inside a list with aggregates over periods/quarters/halfs/years Report Design: The mainqueryitem (queryitem) gets data via manual sql. The manual sql has 4 queries inturn unioned. All the 4 queries are j...
I'm working with COGNOS, a very frustrating BI application that relies heavily on Javascript. Basically, when a <select> box is changed, the data on screen is refreshed, presumably by an AJAX function or something similar. I'd like to force this change using jQuery, but I'm not sure how to intercept the call it is making so I can duplica...
I want to take DB2 DBA certification and also want to learn Data-Warehousing and Business Intelligence. I want to know: (1) Whether DB2 DBA certification is demanding or not. I am a .NET developer since last three years and IT experience is even more. I worked on Oracle, MySQL, SQL Server and used DB2 also for some applications. For suc...
I am trying to find the @ in a string field. The follow data item in a Congos 8 returns 0 for every call. instr ( [email protected], '@', 1 ) Any ideas? New to Cognos and Oracle in general but I feel like I have to be missing something obvious. ...