2009-04-07

Run SQR without PeopleSoft process scheduler

That's easy enough:
1. install SQR (Hyperion's product, downloadable from Oracle);
2. config your SQR client with your database;
3. when you run your sqr from command line, remember to specify your username/password/database_service_name (don't leak your password);
3+. Typically, you need to specify your "SQR_INCLUDE_DIR", by typing the string into your command:
sqr sqr_test.sqr /@ -I;

Don't forget to end up your DIR name string with "\" or "/"; ortherwise it won't work.