Search results for query: *

christenhusz wrote: Why don't you use the standard windows schedular? works just fine! Sometimes it does but ... $#$@#$%%#%#$%# :'-(

Nobody ???

We have a server with Transformer Server and a different server with our directory Server installed. When I schedule a Cognos macro with NT Schedular on our Transformer server then I get an error: "'440-AutoExe: : Index out of range' during execution (Line: 157)." The reported line is: Set...

Hi Lia, Do you have read permisions on the views? You can only see the views if you have the rights to use them. Can you use the views through a query analizer? DeWegenwachter

Yes there is! Views are like tables. For Impromptu we see now differences. So look for your views in the table viewer! DeWegenwachter

We are creating many catalogs, queries and cubes. Frequently we make adjustmens to this files. We now want a version control system to administrate the different versions of the files. We heard of the version control system from Microsoft "Visual Source Safe". Is somebody using this...

Lex said: Can you not just incorporate the contents of the vba macro into the cognosscript? You can also incorporate the contents of your cognosscript into the vba macro !!! With a little adjustment you can copy-paste your Cognosscript into VBA !!! DeWegenwachter

2 mil rows is nothing. We are creating cubes with 27 mil. of rows. To build this cube we need something like 2,5 hours. What is the SQL of your query? What for DBMS do you use? Did you create dimension queries and fact queries? Is the hardware of your Transformerserver fast enough?

You can use OLE DB without creating an ODBC connection. Did you specify a "Provider String" in the database definition? For example: Provider: SQLOLEDB Data Source: databaseservername Provider String: Initial Catalog=databasename

--------------------------------------------------------- Do you have any idea about how and where Impromptu stores the information about the databases,like the configuration file etc.? --------------------------------------------------------- Database info is stored in the Cognos.ini file in...

The only thing you have to do is to make a user class in Access Manager which has the same name as the user class in your catalog ...

The help file of the Cognos Script Editor is very usefull. Most of the things you want to do with a macro are described in the help file. Save a PPR file as a XLS file is very easy. So see the help file for more support!

Hey Sync, I'm interested in your macro. Can you publish the code? Thanx De Wegenwachter