Search results for query: *

Hi all, I am new at Cognos 8. I am trying to save a report (Query Studio) as an *.dbf file. How can I do it? Is there another way to do this? thanks

Hum.... Save as (i don't care)..... :-( Have you ever tried to open a report with 2.000.000 records and tried to use [save as ....] ? I know the options, but please read my post !!! I can't open the report with more then 2.000.000 records and then save it as..... [I don't care] ...

Hello all, I have only BO XI 2.0 (no Data Integrator) and want to export some data to a *.CSV file. When I try doing it from a report (open, refresh, save as EXCEL) the data is to big to handel within a report. Is there a way to export the data ? Thanks.

Blom0344, Thanks for your reply. Bottem-line is that all those solutions are work arrounds because BO has put a limit to a DT. I know, the right way is to build a View in the RDBMS, but why offer a solution in a product what I can't use ? I have to join every DT with other tables to fully use...

Skrandel, Thanks for your reply. The reason I used 2 DT, is because BO has a limit space to put your SQL statement. So the only way to resolve my problem is to build a view in de RDBMS......... :-( (I have to ask the DBA) I hoped there was another way because I have to build and release my...

Hello, A have build 2 Derived tables (same structure) because the SQL script is to long to put it in one. Can I merge them to one (derived) table ? I tried this but it would work: Select * from [DERIVED_TABLE_01] union Select * from [DERIVED_TABLE_02] Thanks

Nobody ?

Hey johnv20, A selection of the data: 01-04-2006 12:12:12 05-05-2003 13:15:00 01-jan-2005 10:15:00 01-04-2006 12:12:12 05-05-2003 13:15:00 13-oct-2004 09:10:06 I know how to fix this, but I a looking or a way to keep in control importing the ASCII file. Something like this: ----- TRUNCATE...

Hello, I try to import an ASCII file by using the next source: ------ INSERT INTO [ENTITIENAME] ([all-fields]) SELECT [all-fields] FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source=[DIRECTORY-NAME] ;Extended properties=Text')...[FILENAME] ----- It works fine, unless the input...