0 Replies Latest reply: Jun 5, 2012 6:12 AM by bde-true RSS

    HSF Export Extended Analytics

    bde-true
      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")