How to use Enterprise Adhoc Analysis with Input data node?

How to use Enterprise Adhoc Analysis with Input data node?

book

Article ID: KB0074194

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.2,13.3

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

 

Issue/Introduction

How to use Enterprise Adhoc Analysis with Input data node?

Environment

Windows

Resolution

On Statistica 12.7 and later versions, this node is present in the examples folder. With Version 13.3 and later versions, this node is part of the product. 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

2. Create an ad-hoc analysis configuration from the dependent data configuration if one is not present already.

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 or find it in the node browser if you are using Statistica 13.3 or newer version.

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).

          

5. Open the node Enterprise Ad Hoc Analysis with Input Data (Example) and select the ad-hoc Analysis configuration referred to in Step 4.

     

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 

          

  • [FIELD_NAME] : The field name in the data configuration query that is configured for filtering (Step 1) 
  • [REFERENCE_VALUES] : The values from a variable in the input spreadsheet. These can be referenced as  : NODE_NAME.VARIABLE_NAME.CN . In this example it is : Spreadsheet1.Var1.CN.
  • [SQL OPERATORS] : The list of SQL operators listed in Filter options of the fields in a data configuration. 

         

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. 

       

Additional Information

Legacy Article ID: 227760