SLM Measurement Reports

2009-09-13 Thread Tim Rondeau
Hi All, Arsystem 7.0.1 patch 2 SLM 7.0.02 Looking to run some SLM Measurement reports. Besides the ones out of the box. We have been having plenty of issues with trying to run anything off of the SLM Measurement. We basically created a join between the Help Desk and SLM Measurement to

Re: Deleting Demo account (UNCLASSIFIED)

2009-09-13 Thread Joe D'Souza
AIE uses the username and password of the user that installs it, and considering that it is very likely that you have done it with Demo, you will need to reset it to an alternate username and password in its configuration or your schedules will fail.. Joe -Original Message- From: Action

Re: Setting fields from a direct SQL...

2009-09-13 Thread Joe D'Souza
I'm thinking of doing that because if you need to set values from two columns, and both use these kind of functions, then while you may get $1$ correctly, I'm wondering what it would set for $2$. I might test that on Monday before opening a ticket. Joe -Original Message- From: Action

Re: Setting fields from a direct SQL...

2009-09-13 Thread David Morgan
Hi Joe, all Whilst this may be a work-around it may be quicker than waiting for a fix... Can't you write a SQL function/procedure/package which would perform all the jiggery-pokery within the SQL body before returning just the column you wanted? Regards Dave Morgan -Original Message-