Recent content by kinetic123

I have a requirement to customize the Siebel Analytics Portal. The look n feel is handled using the CSS. I want to add some functionality in the Portal. Which files on the SA server need to be modified?

Hi, I have automated the processing of opening excel sheets and applying macros on them. I do this on a large number of files. At times i get an error - that the file cannot be opened. I notice that in the event log of the machine, an error is recorded with event id of 10010, that the DCOm...

Hi, I have a VB program which I want to execute as a scheduled task. The VB program should pass keystrokes to another application. Can the keybd_event API be used to achieve this? Would this API work (considering I use a scheduled task)if the machine is shutdown or the user has logged off...

Hi, I have a VB code that runs fine on my machine but the same throws up an error 61704 when run on another machine. The code that i have written uses the API calls of a tool COGNOS to interact with it. Any idea on this. Regards Kinetic 123

Just a thought. Have you verified whether the temp variable created uses the user or system profile

Using Datasets might help kinetic123

Hi, I need to save a model file (.mdl) without the categories. How can i achieve this?

I have a 'datetime' column,that when used in a prompt displays the date in ascendind/ descending order. i.e the dates are arranged by year, then by month and then by date. Now when i display this 'datetime' column as a string in mm/dd/yyyy format in a prompt, the display order is different. i.e...

Hi, I need to start a cube building process, once the database tables have been loaded. The scheduling needs to be event based. Does Cognos scheduler Support this? Also, the database tables reside on UNIX while the transformation server is on NT. Are there any other standard schedulers in the...

Hi, In a catalog i pull in a database table and its alias. When a column is added in the database to this table, i update the catalog by pulling in the added column. But this adds the column only to the Catalog table that referes to the databse table and NOT to the alias. Also the added column...

griffindm, Thanks for your response. I have got MR1 and am fine now.

I have been trying to use a catalog prompt in Impromptu ,more than once in a catalog condition (filter) (e.g) start_date >=to_date( promptA,'mm/dd/yyyy') and end_date<=to_date(promptA,'mm/dd/yyyy) The prompt accepts a string and uses that in the filter after converting it to a date. In the...

Hi, Have you thought of using PowerPrompts for this? Definitely an easier option.

I have a table in SQL 2000 with a primary key constraint. I have created a Transformation task to load the above table from a flat file. The problem is that the flat file has duplicate records and the load fails because the primary key constraint in the table is violated. Is there some method...

Any idea on how to use Quality manager within DataStage (other than the menu option provided).