Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sage ACT! 2012 Analytics FAQ

Employee
Posts: 6
Country: USA

Re: Sage ACT! 2012 Analytics FAQ

Sounds like you are using an old(er) version of ActDiag. Download the new version - this should fix the issue.

Silver Elite Contributor
Posts: 3,075
Country: United_Kingdom

Re: Sage ACT! 2012 Analytics FAQ

ACT Diag V 14.1.108.0

 

Is there a more recent version?

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Employee
Posts: 6
Country: USA

Re: Sage ACT! 2012 Analytics FAQ

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.

Copper Super Contributor
Posts: 63
Country: USA

Re: Sage ACT! 2012 Analytics FAQ

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.

 

Danielle Major

Ki Consultants

Danielle Major
Ki Consultants
ACT! Certified Consultant
ACT! Certified Premier Trainer
561-208-3912
407-284-1459
www.kicrm.com
Copper Super Contributor
Posts: 63
Country: USA

Re: Sage ACT! 2012 Analytics FAQ

i downloaded and unzipped that attachment and it crashed on two of my windows 7 machines and i was not able to get it to run.

Danielle Major
Ki Consultants
ACT! Certified Consultant
ACT! Certified Premier Trainer
561-208-3912
407-284-1459
www.kicrm.com
Silver Elite Contributor
Posts: 3,075
Country: United_Kingdom

Re: Sage ACT! 2012 Analytics FAQ

Yup

 

Doesn't run on my machine either.

 

:-(

 

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Bronze Elite Contributor
Posts: 3,136
Country: USA

Re: Sage ACT! 2012 Analytics FAQ

right. i have .net 4 installed.

 

it NO workie

-MM
World Famous ACT! Certified Consultant @ www.ActiveSales.net
Bronze Super Contributor
Posts: 1,219
Country: USA

Re: Sage ACT! 2012 Analytics FAQ

Does not work on my machine either.

BTW - the actdiag.exe in the zip is build 7.0.0.1 Copyright 2011

 

-- Jim Durkin

 

Bronze Contributor
Posts: 1,244
Country: USA

Re: Sage ACT! 2012 Analytics FAQ

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.

Patricia Egen
Certified ACT! Consultant, Trainer, Developer
www.egenconsulting.com
(423) 875-2652

Follow us on:


Visit our Popular ACT Wizards Page Wizards Here!

Bronze Elite Contributor
Posts: 2,101
Country: United_Kingdom

Re: Sage ACT! 2012 Analytics FAQ

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!

Vivek Gargav
Caldere Associates Ltd.
www.caldere.com
vgargav@caldere.com
My Blog