Search results for query: *

Hello, The official support of COGNOS told me that it was not possible to plug on Analysis Services 2005 cubes. They also told me that connection to SQLServer 2005 as datasource was possible but not supported... And what about Transformer 7.3? Can I generate PowerCubes from an SQLServer 2005...

I haven't worked whith FM, so I based this affirmation on what I heard... Thank you very much for the correction ! Regards, Philippe

Hello, Am I wrong thinking and saying that actual COGNOS 8 solution is only ROLAP and provides no MOLAP feature ?!? How can I use a cube as source in Framework Manager ? It seems that FM is not able to generate IQD ... So how do we deal performance problems ? Thank you in advance for your...

Hello, I use a table with a blob. When I insert something in this blob I get an opened cursor named table_e_400_6eec_5_0_0 which is visible with the query select user_name, count(1) as count, sql_text from sys.v_$open_cursor group by user_name, sql_text order by count; I found an explanation...

Thank you, I'll try to add this feature to the server. Cheers, Philippe

You have understood me, Dima. As I wrote in my firt message, there is a COMPRESS command that can be applied to a table through an ALTER TABLE command. But it seems that I need a specific feature (Heap segment compression ). And I'm not sure that this feature is adequate for my purpose. Any...

One way I think is to write a Java stored procedure that calls sqlldr (something like Runtime.getRuntime.exec(cmd);. You can than call the java stored procedure in pl/sql like another pl/sql function/procedure. Hope it helps. Philippe

Yes 9.2 EE...

OK, I understand now...[thumbsup2] I'll try this. But as I want to keep this table always as small as possible I will be forced to program this procedure in an automatic job. Is there no way to let Oracle do this job ?

What do you mean ? I don't want to export the table, I just want it to be smaller in Oracle...

Hello, I want to compress a table which contains blobs. I tried ALTER TABLE MYTABLE COMPRESS but I get this error : ORA-00439: feature not enabled : Heap segment compression How can I enable this feature? Is it the only way to compress BLOB data ? Thanx, Philippe

I tried to do this, but I had bad results with numeric columns. If you apply an 'AXX' format on a numeric column, you obtain something like ####### in the data... So one should refine your query with a DECODE like DECODE(DATA_TYPE, 'NUMBER', '999', 'VARCHAR', 'A')... Too much work for my...

Thank you for confirmation. I think it's a strange limitation. A parameter like "SET HEADERWIDTH [COLNAME|DATA]" should not have been complicated to implement !...[thumbsdown]

Thank you for your response. But is there no other way to tell sql*plus it should display the full name ? I would not like to have to know the structure of the table (for a generic batch processing). No idea ?

Hello, I want to create a .csv file from a table. My script : SET echo OFF SET HEADINGS ON SET colsep ',' SET feedback OFF SET linesize 1000 SET sqlprompt '' SET serveroutput ON SIZE 40000 FORMAT SET TERMOUT OFF SET UNDERLINE OFF SET trimspool OFF SET trimout OFF...

Dave, Thank you for the response. In fact the situation is a little bit more complex than what I showed in my example. I have more than 10 codes for this field and the description are translated in three langages (in another table). And I have more than one field in the report that is coded...

Hello, I would like to convert a numeric code in its textual description in a report. The situation is the following one : I have table which looks like ID EVENTTYPE EVENTDATE 1 1 14.08.2003 2 1 14.08.2003 3 2 14.08.2003 4 3 15.08.2003 5 1...