Analytics Software

Hi, collegues!

I want to export data from Hyperion Strategic Finance to external database star-schema using standard Extended Analytics Export. Connection to DB is OK, Rule-Set configured quite simple, so data is exported when:
- a user manually check-in modified Entity;
- an administrator manually select Entity-Edit-Export from Administration console.
"transaction" table is populated with status "check-in" or "manual".

We need newely created entitties is automatically exported to schema; the corresponding checkbox "Export on Entity create" in RuleSet is checked.
I wrote a macro that creates new entities throught HSF WebService API
The script below(#1) successfully creates new entity, but no data is populated automatically to star-schema. So I assumed, that I should use ExportExtendedAnalytics WebServiceAPI function(#2), it returns void as it should do when no errors had occured. But I wonder why there are still no new data in star schema after all that manipulations? What I'am doing wrong?


(#1)
tHTTP.Open "POST", "http://" & tServerName & "/HSFWebServices/HSFWebService.asmx/CreateSession", False
tHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
tHTTP.Send "userName=" & Escape(tUserName) & "&password=" & Escape(tPassword)
rawSessID = tHTTP.ResponseText
Str1 = "hsfwebservices/"">"
Pos1 = InStr(1, rawSessID, Str1)
sessionID = Mid(rawSessID, Pos1 + Len(Str1), InStr(Pos1, rawSessID, "<") - Pos1 - Len(Str1))

tHTTP.Open "POST", "http://" & tServerName & "/HSFWebServices/HSFWebService.asmx/OpenServer", False
tHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
tHTTP.Send "sessionID=" & Escape(sessionID) & "&server=" & Escape("HSFServer")

tHTTP.Open "POST", "http://" & tServerName & "/HSFWebServices/HSFWebService.asmx/OpenDatabase", False
tHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
tHTTP.Send "sessionID=" & Escape(sessionID) & "&database=" & Escape(tDBName)

tHTTP.Open "POST", "http://" & tServerName & "/HSFWebServices/HSFEntityWebService.asmx/CreateEntity", False
tHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
tHTTP.Send "sessionID=" & Escape(sessionID) & "&newEntity=" & Escape(tEnt) & "&baseEntity=" & Escape(tBaseEnt) _
& "&rootEntity=" & Escape(tRoot) & "&parentEntity=" & Escape(tParent) & "&keepData=" & Escape(tCopyData)

(#2)
tHTTP.Open "POST", "http://" & tServerName & "/HSFWebServices/HSFEntityWebService.asmx/OpenEntity", False
tHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
tHTTP.Send "sessionID=" & Escape(sessionID) & "&entity=" & Escape(tEnt) & "&checkOut=" & Escape("True")

tHTTP.Open "POST", "http://" & tServerName & "/HSFWebServices/HSFEntityWebService.asmx/ExportExtendedAnalytics", False
tHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
tHTTP.Send "sessionID=" & Escape(sessionID) & "&entity=" & Escape(tEnt) & "&analysisVersion=" & Escape("1")

tHTTP.Open "POST", "http://" & tServerName & "/HSFWebServices/HSFEntityWebService.asmx/CloseEntity", False
tHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
tHTTP.Send "sessionID=" & Escape(sessionID) & "&checkIn=" & Escape("True") & "&releaseLock=" & Escape("True")