Search results for query: *

I'm needing to duplicate the use of the Oracle MAX() function in my Cognos Query data sets. We have two tables, EMP and ELECTIONS, where EMP contains the demographic data for a person, and ELECTIONS contains thier benefit elections over time (so, there could be several rows where the person...

I have the following SQL (6.5) that apparently doesn't see the join correctly, as it doesn't see matching dates that have been converted to char(). select ia.client_id, ia.issue_number, ia.action_date, convert(varchar(10),ia.action_date,110), ia2.action_date_c, ia2.isscount from issue_activity...

I have a reporting system, using 8i as the database. I have been asked to create a report that concatenates some of the data from multiple rows into a single row, as follows Assume two tables with the following data: Table_a case id name address 1 123 J. Blow 111 Daisy Ave 2...

Ok I've got a Dashboard report made up of a dozen or so subreports. I have a row of bar charts, all displaying the same data, but for different business domains. The probolme occurs when there is no data for one or more of those domains. I want to hide the resulting very ugly bar graph, and...

I have a requirement for a report that needs to calc a time period in Days (now just simply subtracting the two needed dates). Is there a way to change the calc using the COGNOS Impromptu functions to exclude the weekend days in the total? (i.e., if case took 5 calendar days to complete (Thurs...

I have an Impromptu report that has three promtps that are populated from the database. It runs fine in Impromptu, but, when I publish it and try to run it, I get teh following error: GeTemplate iwr_modifyprompts.utml failed. Reason: The content request 'DescribeNewsItem' has failed. The Cognos...

Here's what I need to do: - I have a main report, with several subreports, mostly text. - I want the user to enter a single date prompt (as a date) - I want to then use the date prompts in the subreports, either directly as displayed data (or manipulated as a string, maybe), or as a filter...

Hopefully, one of you can answer my question about cubes and Upfront. When I am in a cube in Upfront, and then publish a resulting 'report' (a particualr view of this cube) to another Newsbox, does this cube have a physical existance somewhere on the Cognos Server like it's 'parent' cube...