How to create a SVB (Statistica Visual Basic) Data Configuration in TIBCO Statistica Enterprise?
Article ID: KB0075403
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.0 and higher |
Description
SVB (Statistica Visual Basic) Data configurations can be useful when the data can be retrieved by writing an SVB code. This article explains how a SVB data configuration can be created in TIBCO Statistica Enterprise with examples. Note that SVB Data configurations have limitations with interactive filtering.
Issue/Introduction
How to create a SVB (Statistica Visual Basic) Data Configuration in TIBCO Statistica Enterprise?
Resolution
Users with Data Admin (DADM) permissions or System Admin (SADM) will be able to right click on a folder and and select New SVB Data configuration to create a new SVB data configuration. The user may simply paste code or use a SVB code that is already deployed as a general document in the code/parameter section as illustrated below :
Some Example SVB codes are attached.
1. Example_Excel.svb shows how an excel data source can be used as a data configuration
2. ADO_SQL.svb shows how data from a database connection can be used as a SVB data configuration by changing the constants defined on top of the svb
3. SVB Data Workspace.svb shows how a the output of a specific node in a workspace can be used as SVB data configuration.
Here is a deeper look at some of the example SVB codes to get a deeper understanding of how the code should look like.
1. The SVB does not need a Main subroutine. The SVB for SVB data configuration expect a single function - SVBDataConfiguration.
2. SVB Data configuration expects a lighter version of Spreadsheet called the "StaSpreadsheet". Any recorded macro/ standard Statistica macro can be made into a SVB data configuration by using the function Application.StaSpreadsheetfromSpreadsheet (Spreadsheet object) that returns a StaSpreadsheet
3. RunContext.RunMode = "Columns" can define the code for the Retrieve Columns context of the SVB data configuration.
4. Attached SVB Data Workspace.svb has an example that shows how the parameter section can be used to pass inputs to the code.
The parameters are handled in the code as an variant array with RunContext.Param
DISCLAIMER : Any custom use case that requires of development of a new SVB data configuration are not within the scope of TIBCO support . The attached macros are only examples provided to help user write their own code for SVB Data configurations.
Some Example SVB codes are attached.
1. Example_Excel.svb shows how an excel data source can be used as a data configuration
2. ADO_SQL.svb shows how data from a database connection can be used as a SVB data configuration by changing the constants defined on top of the svb
3. SVB Data Workspace.svb shows how a the output of a specific node in a workspace can be used as SVB data configuration.
Here is a deeper look at some of the example SVB codes to get a deeper understanding of how the code should look like.
1. The SVB does not need a Main subroutine. The SVB for SVB data configuration expect a single function - SVBDataConfiguration.
2. SVB Data configuration expects a lighter version of Spreadsheet called the "StaSpreadsheet". Any recorded macro/ standard Statistica macro can be made into a SVB data configuration by using the function Application.StaSpreadsheetfromSpreadsheet (Spreadsheet object) that returns a StaSpreadsheet
3. RunContext.RunMode = "Columns" can define the code for the Retrieve Columns context of the SVB data configuration.
4. Attached SVB Data Workspace.svb has an example that shows how the parameter section can be used to pass inputs to the code.
The parameters are handled in the code as an variant array with RunContext.Param
DISCLAIMER : Any custom use case that requires of development of a new SVB data configuration are not within the scope of TIBCO support . The attached macros are only examples provided to help user write their own code for SVB Data configurations.
Attachments
Feedback
Yes
No
Powered by
