Search results for query: *

Hi, Has anybody done Venn diagrams in Report Studio 8 ? If so, did you use MapInfo to get his done? Is this kind of chart doable without MapInfo? Thanks

HI, I have a measure in MS-Access (This is to troubleshoot stuff only) and the measure is a number column. However, when I try to generate the report in Report Studio its not aggregating the column? Thanks for any help.

Hi, How would you create a cross tab report that would have the weekly period on top? For instance | | 7/7/07 - 7/14/07| 7/15/07 - 7/22/07| | | Trip A 5 | 8 | Trip...

Hi, How do you use the _age() function in Cognos 8 to show age in years only? IE. 60 or 53.... I'm trying to use it but it give me YYYYMMDD so, I'd like to strip out MMDD and just return the YYYY. Thanks for any help.

What are the major differences between these 3 types of SQL in Framework Manager. I'm sure they put them in because they serve a different purpose? Cognos SQL. Native SQL Passthrough SQL Also, can any of these accept a prompt parameter to be passed in? Thanks -Jim

Hi All, I'm gonna be going to Report Studio training (V. 8 MR2 ) and I would like to contribute to the forum here. If you have any questions regarding Report Studio I'll be more than happy to post them to the instructor while I'm in training. Thanks -Jim By the way, this training will be...

Hi, does anybone know how to do a union in framework manager? Also, I've entered sql into a Framework manager using distinct and when I want to link the query subjects I don't see them correclty. In other words when using RS to pull individual items from the query subject I can't. I can only...

Hi, How could select distinct rows based on 2 columns. I'm getting different total counts when I log onto Oracle and count all records vs. the count cognos gives me. Using Cognos 8.2 Anybody KNow? Thanks

Trying to update one table from the value of another table. The relationship is one-to-many. Here is my code: update table1 as t1 set field4 = (select field7 from table2 as t2 where t1.id = t2.id ) Table1 has many and table1 has one. Thanks.

Hi, Can't seem to sort a layout calculation in Report Studio. Cognos 8. Has anyone ran into this? -J

Cognos 8 Does someone know how to place a list footer that contains count distinct into the top of the report page? Thanks. -J

Hi, Using Cognos 8, I have a one-to-many relationship. How do I count the distinct from one table? My primary keys are a combination of two columns? Thanks. -J

Hi, I'm working on Cognos 8 and windows env. I have 3 tables. One of them is the facts table and the one of the 2 other tables has records I need to count. The problem is that I don't know how to count the table records when these have a relationship of one-to-many. I have have it like this...

Hi, I wonder if any of you have an answer that can help. Here is the scenario. I have a table that has 2 dates (date1 and date2). To get the amount of days I created a query item that is composed of this (day2 - day1). Now I'd like to convert this into a number value. However, I've tried...

Hi, I was wondering how to do nested queries or "Inline Views". Through Oracle I've been writing SQL code and then in Framework Mgr. I've put in the code as pass-through. However, does anyone in this list know how to do or use inline views throught either: FM or Report Studio? Some of the...

Hi, I was wondering if any of you know how to do a top 5 listing. I just can't seem to get it. I retrieved 3 fields from the Go Sales and put in a calculation to use the topCount function and it won't work. Does someone on this list know the steps to get a top 5 records from a subject query...

I've setup the cardinality in FM manager. Now, how do I test it in Report Studio? -J

Hi, Was wondering if any of you know if there is a limit to the number of procedures in a package? The reason I'm asking is because I have written two procedures in one package and the second procedure gives me an error saying: Error(25,1): PLS-00382: expression is of wrong type I' look at...

I get an error when trying to issue the following simple query. I'm using a cursor and an inline view and using the analytic function DENSE_RANK() over(). It's complaining about following error: Error(32,8): PLS-00103: Encountered the symbol "GOT" when expecting one of the following: := ...

Good morning, I'm wondering about query building in Cognos. I don't know if you have ran into questions like this but here it goes. If you have a bunch of self-queries, table joins, nested queries and the like, what is the best option? Should one write store procedures or straight...