How to use Enterprise Adhoc Analysis with Input data node?
Article ID: KB0074194
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 14.0 and higher |
Description
There is sometimes a need to pass on filtering values from a downstream document in a workspace to a criteria in Enterprise ad-hoc analysis. The Enterprise Ad-hoc analysis with input data node is used for this purpose
Environment
OS: Windows
Resolution
To use the node, follow the below steps.
1. Ensure that filtering criteria is enabled on the dependent data configuration. Refer to this KB to see how non-interactive filtering can be enabled. For example, when using a Data Configuration named Product Assembly Data, with the following columns, enabling the filtering criteria looks like below. For the example, both Location and Building Number will have the SQL Criteria, Filtering Options, enabled. Note that these columns are defined as Labels:
Location (and Building Number) are both Labels:
2. Create an ad-hoc analysis configuration from the dependent data configuration if one is not present already.
a. Right-click on the data configuration (Product Assembly Data, in the example) and select "New Analysis Configuration off this Data":
b. A new IQC Analysis object is created. Change this to an Ad hoc Analysis:
c. The final object will have the spreadsheet icon but have the Type as "Ad hoc Analysis":
3. From Statistica Home tab, select Open>>Open Examples>>Workspaces>>Example_Enterprise Ad Hoc Analysis with Input Data.sdm. Click on Open. You may type "Enterprise" in the Feature Finder (top right) or find it in the node browser.
4. Copy the node named "Enterprise Ad Hoc Analysis with Input Data (Example)" to the workspace of interest (the workspace that needs to use a downstream document in a workspace as filter for an Enterprise ad-hoc analysis configuration).
a. Copying the Enterprise Ad Hoc Analysis with Input Data (Example) node to another workspace:
b. In the example, the node was copied to the workspace with a downstream document:
5. Open the node Enterprise Ad Hoc Analysis with Input Data (Example) and select the ad-hoc Analysis configuration referred to in Step 2:
6. To pass filtering criteria from the spreadsheet to the Ad-hoc analysis, enter SQL criteria in the syntax : [LOGICAL_OPERATOR]=>[QUERY_NAME]=>[FIELD_NAME]=>[REFERENCE_VALUES]=>[SQL OPERATORS].
This is explained in detail below:
- [LOGICAL_OPERATOR] : AND or OR that will connect multiple SQL Criteria. The first SQL criteria can start with AND.
- [QUERY_NAME] : Corresponds to the Query name of the Data configuration, In the example, this is New Query 1:
- [FIELD_NAME] : The field name in the data configuration query that is configured for filtering (Step 1). In the example, the FIELD_NAME is Location.
- [REFERENCE_VALUES] : The values from a variable in the input spreadsheet. These can be referenced as : NODE_NAME (the upstream document).VARIABLE_NAME.CN . In this example it is : ADHOC.Site.CN
The upstream document, in this case a spreadsheet, is Adhoc and the variable name in the spreadsheet is Site:
- [SQL OPERATORS] : The list of SQL operators listed in Filter options of the fields in a data configuration.
Available operation are:
- Begin with
- Between
- Contain
- End with
- Equal
- Greater than
- Greater than or equal
- Is not null
- Is null
- Less than
- Less than or equal
- Like
- Not begin with
- Not between
- Not contain
- Not end with
- Not equal
- Not like
- Not one of
- One of
7. When the node is run, the results will be equivalent of results of the query with values contained in the referenced spreadsheet used as a filtering criteria:
Note that the filtered options for Building Number, though Enabled, are not used in the SQL Criteria in the Enterprise Ad Hoc Analysis with Input node.
Issue/Introduction
How to use Enterprise Adhoc Analysis with Input data node?
