Recent content by CosmicNerd

I am trying to set up Data Manager networking across two servers in Cognos 10.2.1 . When I try to run a Data Movement task I get the error "UDA-SQL-0107 A general exception has occurred during the operation "columns". ORA-00942: table or view does not exist UDA-SQL-0196 The table or view...

What product/version are you using? Acestar Solutions Limited Cognos development and on-site training http://www.acestar.co.uk/

You've probably solved it by now, but I wonder if you've got enough RAM on the server where the dispatcher is installed. I had that one once on my pc. Acestar Solutions Limited Cognos development and on-site training http://www.acestar.co.uk/

You can update query subjects and this will bring in new columns if the query subject is written that way (maybe using select *). Right-click the individual query subject and select Update Query Subject. Regards Clive Acestar Solutions Limited Cognos development and on-site training...

Try right-clicking on the Namespace and selecting 'Import Metadata'. You need to tell FM about these tables. Acestar Solutions Limited Cognos development and on-site training http://www.acestar.co.uk/

Have you checked the SQL generated for the query? That would be the first thing to do. I am trying to find out more myself about how Cognos handles report generation. I have also heard that the Content store can get pretty busy in some environments. You also should look at what environment you...

Prompts in Imprompts are quite inflexible. I suggest you try either: write a script (CognosScript) to handle the prompt using Message Box or similar, or you might get somewhere defining a report or catalog item that has the format you want (text), using that as the prompt, and linking the data...

We are using Oracle ref cursors returned from a pl/sql package to return the record set to cognos. The problem that we are experiencing is that on some cases Cognos return data from the ref cursor and in other cases we receive the error message listed at the end. From an Oracle perspective the...

Have you tried separating them with a comma? Acestar Solutions Limited Cognos development and on-site training http://www.acestar.co.uk/

Hi, Does anyone know if you can search BLOB fields in Impromptu or Powerplay? Acestar Solutions Limited Cognos development and on-site training http://www.acestar.co.uk/

What version of Powerplay have you got? In later versions you can generate a small test cube in the Run/Test build menu. This might help. If you don't have this option, you could try using the Clean House option to get rid of some categories, if you can see them - may or may not be appropriate...

Presumably you've tried just subtracting the dates, can't remember if this works (probably doesn't). What about using date-to-days-from-1900 to convert the two dates to numbers, then subtract one from the other, then convert the result back to a date using days-from-1900-to-date? There are...

What product/version are you using? Could you give more details of what you are trying to do? Thanks

Oh, I thought your script was a Cognos script, ie written in VBA (Visual Basic). That's what I was suggesting, ie using CognosScript to control your reports.

Maybe it's a new feature! I don't have the ranking item selected for sorting, but it has affected the sort order of my report.