PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/07/2014 11:27 AM by  Lorenda
Scripting with dme's - Server timeouts
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Lorenda
Financial Analyst
St. John Health System
New Member
(1 points)
New Member
Posts:1


Send Message:

--
08/07/2014 11:27 AM
    Hoping someone in this group can give me some pointers on how to adjust the below dme by adding indexes, etc to avoid the periodic server timeouts I'm experiencing. First of all, what I am trying to do is build a report to pull our budget data for our supplies accounts, and compare this to the actuals that are coming in on a daily basis. I've done this by pulling all the accounts with our supplies summary account ID. Since I want this to run unassisted, I've inserted variables to provide my fiscal year and current period. FY is my fiscal year variable, rptPER is my Period variable. I am coding in VSOT, Visual Basic.

    KEYUSAGE=PARAM&MAX=9999&NOHEADER=TRUE&OUT=CSV&DELIM=%2c&INDEX=FBDSET1&NEXT=TRUE&PROD=PRD&FIELD=COMPANY%3BFISCAL-YEAR%3BBUDGET-NBR%3BCHART-NAME%3BACCT-UNIT%3BACCOUNT%3BCR-AMOUNT-" & rptPER & "%3BDB-AMOUNT-" & rptPER & "%3BBLANK%3BUNTBUD" & rptPER & "%3BMAINT-DATE%3BCHART-DETAIL.SUMRY-ACCT-ID&FILE=FBDETAIL&SELECT=CHART-DETAIL.SUMRY-ACCT-ID%3D167&KEY=1000%3D" & FY & "%3D1&SK1=1000&SK2=" & FY & "&SK3=1&"

    You are not authorized to post a reply.