How to add scripts/spreadsheets as general documents in Statistica Enterprise ?

How to add scripts/spreadsheets as general documents in Statistica Enterprise ?

book

Article ID: KB0075966

calendar_today

Updated On:

Products Versions
Spotfire Statistica All supported versions

Description

Statistica Spreadsheets/ Scripts may be stored centrally in Statistica Enterprise. Infact, any file can can be stored in Statistica Enterprise as a version controlled document that is accessible centrally to the users with permissions as a general/binary document. The advantage of storing in statistica files/scripts in Statistica Enterprise is that it can be centrally stored and referenced by other files using the format :

Issue/Introduction

How to add scripts/spreadsheets as general documents in Statistica Enterprise ?

Resolution

Option 1:

1. Open the Spreadsheet or Script that needs to be added to Statistica Enterprise as a general document

2.  In Statistica, navigate to Enterprise Tab>>Add to Enterprise. Select Create new object.

User-added image

3. Choose the System View folder to add into Enterprise, define the name for the script and define Access permissions on who can access the script and then click OK to successfully add a script to Statistica Enterprise. User may be prompted for versioning information, if applicable to the system.

Option 2:

1. Open Enterprise Manager and select the system view folder where you would want to import the general/binary document.

2. Click on "Insert file" from the Action section and choose the file to be added. Define Access permissions and enter versioning information if prompted and then click on Commit to save the file in Statistica Enterprise as illustrated below:

User-added image
------------------------------------------------------------------------------------------------------------------------------------

Once deployed, the files can be referred to in other places as "enterprise://[System View Path in Enterprise]|[Version Information]"  See: https://support.tibco.com/s/article/How-to-get-the-system-view-path-of-an-object-in-Statistica-Enterprise-Manager for how to find the System View path in enterprise

Here are some common use cases to referencing the binary documents:

1. As reference of other scripts :

User-added image

2. While defining database connections using STAOLEDB provider for Statistica Spreadsheets:

User-added image

3.  While defining code for SVB Analysis configurations :

User-added image