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

All, Just figured out my error. -Jim

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.

Thank you Ties. Those are really good suggestions. Jim

Ties, Thank you very much for the example. That really helps. Also, do you know if this report format is normal?

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.

rm1234 (MIS), You can do that by first creating a filter. In that filter write the query for how you want to format your database date! The date is coming from the database correct? Format depends on the specific db vendor. However, you should know the format for your database type. Next...

cog8user, Yes, try doing what almeids has suggested. Cog8user, do you know how to create cascading prompts? Ok, having built the prompt appropriately then go look at the query and its filter? Find out what is being sent as a query to the Cognos server. Write that in the next post and lets...

cog8user, Give us a sample of the values. It should work but perhaps you have something in your query filter that may not be working. Ok, so after they select the prompts and execute the query what kind of data are you expecting and what do you get as a result now? -Jim

Thank you MF. That's really good. Thank you once again. -Jim

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

Thank you for the compliment MF. That's my philosophy, help and you will be helped. I try to improve all the time and if my knowledge helps others then I'm satisfied. Thank you MF. I've already began the list of questions I have for him/her. ;-) -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 MF, I wrote the SQL as passthrough SQL. The query I had written had about 2 inline views and the outer query was listing columns as well as inline view columns. Thank you for your response MF.

MF, That helps alot. Especially the portion where the union is created between the 2 query subjects. The portion where I was lost was when creating a manual query that uses inline views. For example, I used a query that had an inline view (a manually created sql) that had query items from...

MF, I'm working with Cognos 8. In Framework Manager 8 if I write my own nested query to create the query subject. Once I publish it to Cognos 8 ReportNet and use Report Studio to create reports, will I be able to select individual query items from the query subject or would the whole thing...

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...

I'd say this, Do the formatting in RS. For Best practice, use RS for formatting and FM for modeling your data. -Jim

Frincy, The easiest way is to create the report and save it as CSV or other format. That to me sounds easy and not tedious. The other thing you can do is aggreate the data through ETL processes directly in your database. Then you just extract data with whatever tools you have in your DBMS...