07-18-2012 12:26 PM
Whoops - my bad, that version is the most recent available for download on our site. We plan to upload a corrected version shortly. In the meantime, you can use the one in attached Zip file.
07-18-2012 01:03 PM
Jeff, I did finally get it to work by using the CLI that i found... somewhere... i dont' remember where now.
sqlcmd -d%1 -S.\ACT7 -E -Q"exec dbo.PRC_BI_Refresh_DIMs;exec dbo.PRC_BI_Refresh_History_FACT;exec.PRC_BI_Refresh_Opportunity_FACT;"
Where the %1 is ... i put in the name of my database . no extension, just the name.
i ran that on my database and the demo database and they both work now.
07-25-2012 05:27 PM
I have run into a bug with executing either from ACTDIAG or from the cmd string. It is setting the permissions for ACTREADER to DENY on Select stattements which means you can't see the views from ACTREADER. DUH. None of know the SA password and if you are running Excel from a workstation, you will never be able to use Windows authentication. So the proc needs to be fixed. Or you need to logon with SQL management studio and set the permissions for the two views with it or using a CMD. Hopefully Xavier will see this post and respond if that can be resolved.
07-30-2012 01:07 PM
What about the possibility of setting the act scheduler to run the refresh analytics once a day so that end of day/month/quarter/year reports can be generated.
One other possiblity that I've played around with is running a PowerShell script off the Windows Scheduler that calls the SP directly, but I appreciate that maybe a bit more involved than the average user would want to go!