Home

User Guide

1. Create or Edit Explorer Objects Create a Data Manipulation Create a Clustering Model Load an Existing Data Manipulation Create a Time Series Analysis Perform an Event Log Aggregation Create Association Rules Perform a Sequence Analysis Load a Model Perform a Text Analysis LY C Social A Toolkit Create a Social Network i Open the Data Viewer Load a Social Network is Model Perform a Data Transfer List Distinct Values in a Data Set Get Descriptive Statistics for a Data Set The features offered in this toolkit allow you to explore and delete data sets Open the Data Viewer transfer a data source to another location or format Perform a Data Transfer export the list of distinct values of a variable from your data set Among other things this feature allows you to generate a list of unique index values from an existing data set and to use it as a reference table when performing an event log aggregation or a sequence analysis in Infinitelnsight Explorer List Distinct Values in a Data Set generate variables statistics for a data set such as the cross statistics or the profit curves when a variable in the data set is used to estimate the target variable Get Descriptive Statistics for a Data Set Before reading this document you should be familiar with the section Essential Concepts of the Infinitelnsight User Guide CUSTOMER SAP Infinitelnsight 7 0 3 2014 SAP SE or an SAP affiliate company All rights r
2. B 38Private Tente aad 9pivorced 4 S3Pvate mg 3 7 ee 5 Private 338409 Bachelors 13Married cv 5 37Private 284582Masters 14Married iv 7 Private woh 5Married spo e 52seifempmo 209642 HSgrad D SMarried cw AA O ES EE ever married 10 4Private 159449 Bachelor larried civ MT arrivate 2804945omecolege 0 larried civ Emu ee larried civ 13 Private 122272Bacheors 13Mever married a 22Private 208010 Assocacdm A ever married 15 4ofPrivate 121772 Ass0cwwoc 11Married dv 16 34Prvat 3 2454877h 8h 4Maried cw 17 25Bef emp o 176756HS gad 9Never married l ctn ever married JS Sms ase Married lt iv EE 21 be 193524Doctrate 16 22 SalPrivate 30214HS gad 9Separated 23 35 Federalgow 768459tH 5Maried cw larried civ 25 s9Prvatt 109015HS gad Divorced v All mi Bl First Row Index 13 Last Row Index 100 ei al CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved Data Viewer DN 3 pE MIT I Oo 11 To Select the Number of Lines to Display In the field First Row Index enter the index of the line before the first one you want to display for example to start on line 1 enter 0 In the field Last Row Index enter the index of the line before the last one you want to display for example to end on line 10
3. CUSTOMER End User Documentation Document Version 1 0 2014 11 2 2 3 1 32 4 1 4 2 4 3 9 5 2 6 2 6 3 About this Document EE 3 COMMON ee 4 See e da Ett A M LL C E I UU EE 4 2 1 1 Special Case Data Stored in Databases the Explain Mode 5 2 1 2 Sub sambline abate E 6 DesoribIne the Bata e o a I ee 7 bI qcRdiI lgete UR 9 IECH te BR Siro E 10 Diales Dita e CP mA a RR ea 11 Data Transfer E 12 Transierine a Data MampulatiO e ie coso ds lo eee 13 4 1 1 Mella AA 14 OS CLIO vana EStdt td alto M E id LOL a u Eh 14 Savne tE NEw Data A O O mE Ore eee morte ace 15 4 3 1 DEHMINE Text EIS EUNE E 15 List RIL TTA ATH 17 Selecting the Val lable to a le eeh ee 18 UTE Te o AA a ee ee ee 18 Descriptive SEatISHCSo TREE EEE ERA OU DEP DC URL DURAN 20 FROM Ee Start fs EEUU 20 6 1 1 Seleetins the Variables EE ee Ste 21 6 1 2 CHECKING the Pararpeler ainiin endete 24 6 1 3 Calcio E NR E IR QU ERN EMI IUIS 28 6 1 4 Statistics Rea NE ee en ee ee el 28 Fromthe Panel View EE 29 6 2 1 EENHEETEN 30 6 2 2 Karen E 31 EE Io 32 6 3 1 USNE eooc HN is CLI Ce Rn 33 CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved About this Document 1 About this Document This document presents the Infinitelnsight Toolkit provided in SAP Infinitelnsight KXEN Infinitelnsight X InfiniteInsight Version 6 1 0 Explorer
4. Degrees Minutes Decimal Degrees 1000 Minutes Decimal NMEA Degrees Minutes Seconds CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved Data Transfer 5 List Distinct Values The feature List Distinct Values in a Data Set allows you to export the list of distinct values of a variable from your data set Among other things it allows you to generate a list of unique index values from an existing data set and to use it as a reference table in Infinitelnsight Explorer Event Logging or Infinitelnsight Explorer Sequence Coding Y To Use the Feature List Distinct Values 1 Dn the Start panel click the option List Distinct Valuesin a Data Set in the section Toolkit X InfiniteInsight Version 6 1 0 I Explorer Lo Modeler Create or Edit rer Create a Classification Regression Model Create a Data Manipulation Create a Clustering Model Load an Existing Data Manipulation Create a Time Series Analysis Perform an Event L tion Create Association Rules Perform a Sequence Analysis Load a Model Perform a Text Analysis AL Social A Toolkit Create a Social Network Analysi Open the Data Viewer Load a Social Network is Model Perform a Data Transfer List Distinct Values in a Data Set Get Descriptive Statistics for a Data Set The panel allowing you to select the data set from which the values will be extracted is displayed 2 Fora description of how to select and describe the data
5. OK Cancel Composite Variables x Composite Variables 1 x Name Position dp I2 o Add Edit Remove Type Position v Latitude latitude D kel Longitude longitude CUSTOMER SAP Infinitelnsight 7 0 37 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 38 8 Click OK The Composite Varible newly created is displayed 9 Click Close 10 Back to the Description panel click Next 11 For this scenario with a Target Variable select the variable EmptyPopulation KXEN InfiniteInsight New Descriptive Statistics Selecting Variables Explanatory Variables Selected Target Variables A lt Weight Variable A Exduded Variables gt Index lt Number of Variables 21 A E T Alphabetic Sort CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 12 Click Next 13 Create the model by clicking Generate The Training the Model screen appears 14 Click Next d Ge InfiniteInsight EmptyPopulation BE HEADER EmptyPopulation Training the Model amp EB bk Overview Model EmptyPopulation BE HEADER EmptyPopulation DataSet HE HEADER EmptyPopulation txt Initial Number of Variables 22 Humber of Selected Variables 20 Humber of Records 19 371 Building Date 2012 09 20 10 50 54 Learning Time 15 Engine Name Kxen StatBuilder Author denise ortiz caso Monotonic Var
6. allow you to recognize your model when you want to reopen it with SAP Infinitel nsight Autosave This button opens the panel Model Autosave allowing you to indicate that the model must be automatically saved at t end of the learning process and ot set all the required parameters When the autosave option is activated a green check ma is displayed on the Autosave button At then end of the learning process a warning message will be displayed confirmii that the model has been saved Export KxShell This button opens the panel allowing you to generate a KxShell script reproducing the current model SOL Advanced This button allows you to set estimator variables for the target s and or the clusters For more details see section Advanced Parameters on page 25 CUSTOMER SAP Infinitelnsight 7 0 24 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics Advanced Parameters Target Estimator Variables If you have selected at least one target variable the tab Define Estimator will be activated allowing you to select variables as estimator of the target variables An estimator is a variable that can be used to predict the target variable behavior Using an estimator is equivalent to creating a model If there is no variable that can be used as estimator of the target in your data set do not fill anything in this panel Note Only continuous variables can be used as estimators Y To Select an Estima
7. allows you to visualize the content of your data set and to calculate the descriptive statistics for the variables If the data source is stored in a Oracle Teradata or SQL Server 2005 data base an additional warning may be displayed asking you to validate the execution of the query For more information refer to chapter Special Case Data Stored in Databases on page 5 CUSTOMER SAP Infinitelnsight 7 0 29 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 6 2 1Computing the Statistics To Compute the Statistics 1 Click the View Data button The panel KXEN Sample Data View opens KXEN Sample Data View Data Set censuso1 csv Data Statistics 6X mantalsta s tego readers i3Nevermaried E spite 2is45H amp gad See pite ion SMeriedspo us Soss iZz72Baceers i3Nevermaried 1a Soss 20S0i9Asocacim i2Nevermaried 17 255efempro 1767S6HS grad SNevermaried 15 Soss ege SNevermaried private TH HE 4iSefempno Szeen 14Divorced 22 Soss sui4 Hsgad lseparated 25 ssFededgov esas SMariedci a Wee mmm Maeda s Soe 1osoisfisgrad SDvoced y K E mi Bl First Row Index 13 Last Row Index 100 ei al 3 Select on which part of the data set you want to compute the statistics You can calculate the statistics for 30 the whole data set option Compute statistics over the whole data set t
8. alphabetically select the option Alphabetic sort presented beneath each of the variables list 1 Click the button gt located on the left of the screen section Variables excluded lower right hand side The variable moves to the screen section Variables excluded Also select a variable in the screen section Variables excluded and click the button lt to move the variables back to the screen section Explanatory variables selected 2 Click the Next button CUSTOMER SAP Infinitelnsight 7 0 23 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 6 1 2Checking the Parameters The screen Summary of Modeling Parameters allows you to check the modeling parameters just before generating the model 4 SAP InfiniteInsighti VX y z class Census 1 File Help Summary of Modeling Parameters Model Name class_Census01 Description Kxen RobustRegression Data to be Modeled Samples Census Census01 csv Cutting Strategy Random without test Target Variable class Weight Variable Optional None Compute Decision Tree Enable Auto selection jf Export KxShell Script 44 Cancel AI Previous IF Generate Options Description Model Name The name of model is filled automatically It corresponds to the name of the target variable followed by the underscore si _ and the name of the data source minus its file extension Description Once the model is saved the description will
9. be Rounded CUSTOMER SAP Infinitelnsight 7 0 42 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics Export The export tab enables you to export the Selected or All the Tiles of your model and to open the output file with GoogleEarth software Y To Export the Selected or All the Tiles 1 Select File Type KML i KXEN InfiniteInsight EmptyPopulation BE HEADER EmptyPopulation Tiles Export Type of File En Export KML Position YariablasHAPE_ L longitude latitude Data Set fall Target EmptyPopulation e KE 0 n Previous CUSTOMER SAP Infinitelnsight 7 0 43 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 2 Check the fields Position Variables Data Set and Target 3 Select the Tiles you need to export or keep them all 4 Click Export i KXEN InfiniteInsight EmptyPopulation BE HEADER EmptyPopulation d i tun Tiles Edition Export Type of File km D e Position Variable Position Data Set all Target EmptyPopulation l Description CO ESTERO IO y 0 9 1l 49 50000000 ER soo 5 Precise which tiles you need to export KXEN InfiniteInsight EmptyPopulation BE HEADER EmptyPopulation gek tne Tiles Whe Type of File a y Selected Tile s Position Variable Position mn Data Set All cw Target EmptyPopulati
10. on the right of the Folder field to select the folder or data base where the file will be saved 2 Enter the name of the file to create or use the Browse button located on the right of the field Output Dataset to select an existing file 3 Click the Next button A message box appears displaying a progress bar When the file has been created the main menu is displayed 4 3 1Defining Text File Settings When transferring the data set to a text file you will be able to define various specific settings such as the column separator the date format the number format or the encoding Y To Define the File Settings 1 Click the button Advanced Settings A pop up window opens allowing you to define the text file settings File Settings X Define Separator Tabulation C Comma E Semicolon C Space C Other Specify Date Format Date Order Day Month Year Date Separator Sample Separator not accepted for a date IT Force Encoding G UTFS E Native C Latini Number Format Number af Digits r Choose Angle Format Degrees Decimal E Jddd ddddd vV To Define the Separator 2 Check the box Define Separator The corresponding section is activated Tabulation C Comma Semicolon C Space C Other CUSTOMER SAP Infinitelnsight 7 0 15 2014 SAP SE or an SAP affiliate company All rights reserved Data Transfer I o On ER O 10 11 12 16 Select the chara
11. reserved Descriptive Statistics 2 Goto the section Geolocation 3 Enter a Geographic Information System Protocol 4 Click OK to confirm Edit Options JN E Wien Geolocation Metadata Repository Geolocation amp Reset all 6 3 1Using Geolocation Feature 1 Infinitelnsight Start Panel gt Data Toolkit section gt Get Descriptive Statistics for a Data Set KXEN InfiniteInsight X InfiniteInsight Version 7 0 0 Open the Data Viewer Perform a Data Transfer List Distinct Values in a Data Set EU Descriptive Statistics for a Data Set CUSTOMER SAP Infinitelnsight 7 0 33 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 34 The screen Load Input Data Set is displayed C KXEN InfiniteInsight Load Input Data Set Data Type TextFiles y Folder K Benchmarks Georeferenced Data SampleData donwload geonames org_export Data Set PM ias P d A El Browse Metadata C Users Public Team_MDR Text les Select a Data Type a Folder and a Data Set For the example K Benchmarks Georeferenced Data SampleData donwload geonames org_export and select file BE_HEADER_EmptyPopulation txt where there is a target variable CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 3 Click Next 4 Inthe panel Data Description click Analyze KXEN InfiniteIns
12. 0 enter 99 Click the Refresh button to display the selected lines To Search for a Variable Click the Search button Magnifier icon The window Search Variable by opens Select the type of search you want to perform by index or by name A variable index is its column number in the data set In the displayed drop down list select the variable index or name Click the OK button The searched variable column appears highlighted in the window KXEN Sample Data View To Display the Variables Statistics for the First Data Set Lines In the field Number of Lines select the number of lines for which you want to see the statistics To display the statistics for the whole data set enter a number below 1 Click the Statistics button graph icon The window Statistics for lt DataSetName gt on the first lt n gt Lines opens For more details on statistics refer to section Descriptive Statisctics gt From the Panel View Data see From the Panel View Data on page 29 3 2 Deleting a Data Set To Delete a Data Set 1 11 Select the data set you want to delete The button Delete Selected becomes active KXEN InfiniteInsight Data Set Explorer amp View Data Ag Delete Selected um Click the button Delete Selected A dialog box is displayed asking you to confirm the deletion Click the Yes button The data set is deleted CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All righ
13. 50 14842000 50 C 24 0 0 Gr Un lt OO ESTA EE uw A O Pp A E CUSTOMER SAP Infinitelnsight 7 0 47 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics Web Feature Server WFS The WFS feature is used to load the selected tiles from a dedicated geoserver e Tiles GeoServer Adress http Dell27 8080 User Workspace Position Variable p MSS er D 29 782 D 00129058 59 me a B00N974 S Raa ege TS 7 7 LRS EL H HT S S S S s d ien ez S a 7 02 Li ser Lee Jm m mes 8j s ES 8 m 1577ES E Do Not Use Scientific Notation ran will be Rounded Gn uza WI CUSTOMER SAP Infinitelnsight 7 0 48 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics www sap com contactsap O 2014 SAP SE or an SAP affiliate company All rights reserved No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company The information contained herein may be changed without prior notice Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors National product specifications may vary These materials are provided by SAP SE or an SAP affiliate company for informational p
14. Descriptive Statistics for a Data Set in the Toolkit section ll MN X InfiniteInsight Version 6 1 0 Je Explorer Ic Modeler Create or Edit Explorer Obj Create a Classification Create a Time Series Va Toolkit Open the Data Viewer Perform a Data Transfer List Distinct Values in a Data Set Get Descriptive Statistics for a Data Set CUSTOMER SAP Infinitelnsight 7 0 20 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics The panel allowing you to select the data set you want to analyze is displayed 2 Fora description of how to select and describe a data set refer to the section Common Steps on page 4 then go on with reading the sections below 6 1 1 Selecting the Variables Once the training data set and its description have been entered you can select different variables oneor more Targets Variables possibly a Weight Variable and the Explanatory Variables To Select Targets Variables 3 Onthe screen Selecting Variables in the section Explanatory variables selected left hand side select the variables you want to use as Target Variables E SAP InfiniteInsight VX y z New Regression Classification Model File Help Selecting Variables Explanatory Variables Selected 14 Target Variables 1 workclass fniwat education education num marital status occupation relationship race sex Alphabetic Sort capital gain Weight Variable 0 cap
15. able Target Table Edit Field Mapping Oo S B k g Guess Check an r ic NEO S Click the Guess button located on the lower part of the panel Infinitelnsight modeling assistant tries to find in the target data base the tables used in the analytical data set definition based on their name For more information on field mapping see section Mapping Fields see Mapping Fields on page 14 For each table not found or incorrectly identified click the corresponding cell in the column Target Table A table selector is displayed When all the tables are mapped click the Check button Infinitelnsight modeling assistant checks if the mapping is correct for all tables If an error is found a diagnostic message is displayed else the Next button is enabled Click the Next button to start the transfer CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved Data Transfer 4 1 1 Mapping Fields When the fields from the target table do not have the same names as the fields from the source table you need to map the source fields to the target fields The column Edit Field Mapping indicates the state of the field mapping P the transfer definition has not yet been validated or the default mapping is correct E the mapping has been edited and is correct x 43 the mapping is incorrect whether it has been edited or not vV To Define the Field Mapping 1 Inthe column Edit Fi
16. allowing you to select the location where your data sets are stored is displayed C KXEN InfiniteInsight Data Set Explorer Select a Directory or a Database Data Type Text Files ff Samples Census Metadata C Users Public Team_MDR Textes Data Sets Census0 Licsv esc Census 1 csv amp Refresh d vi Data Af Delete Selected Ir Alphabetic Sort Gu CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved Data Viewer 2 In the list Data Type select the type of storage the data sets you want to browse are located in Text File Database Use the Browse button located on the left of the Folder field to select the folder or database containing the data sets If you want to explore data sets stored in a password protected database do not forget to provide the user name and password granting you access to the database The data sets list is displayed in the field Data Sets IN THIS CHAPTER Visualizing a A ee EE ee rer 10 REITER Da ser ee ee A E ee abe 11 3 1 Visualizing a Data Set Y To Visualize a Data Set 1 2 10 Click the data set you want to visualize The button View Data at the bottom of the panel becomes active Click the button View Data The first hundred lines in the data set are displayed in a new window KXEN Sample Data View 5 joj sl Data Set Census01 csv marital status Hs ees 13 Never married a eee ee larried civ
17. base P Borders and Labels 3 Places Photos ISS Roads Og 3D Buildings M ocean O 3 Weather los Gallery mr Global Awareness O 2 More Y Layers magery Date 1 1 2000 CUSTOMER A D o Brugge e SIT e Ke F J i N 2014 SAP SE or an SAP affiliate company All rights reserved J B 5 Eindhoven oAntwerpen ams AE Brussel KT j Gewest oO Liege o Charleroi 9 e 4 22 54 5056 elev Walloon Region SAP Infinitelnsight 7 0 Descriptive Statistics Geographic Information System GIS The GIS feature is an interface with another Geo Software In this scenario the software is Odyssey3D KXEN InfiniteInsight EmptyPopulation BE HEADER EmptyPopulation Data Set all Target EmptyPopulation lt 49 50000000 49 lt 49 50000000 49 lt 49 50000000 49 lt 49 50000000 49 lt 49 50000000 49 lt 49 50000000 49 lt 49 78333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 49 73333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 49 78333000 50 lt 50 14842000 50 lt 50 14842000 50 lt 50 14342000 50 lt 50 14842000 50 lt 50 14342000 50 lt
18. cter to be used as the column separator in the generated text file There are four predefined choices Tabulation Comma Semicolon and Space but you can define your own separator by selecting the Other option and entering the character of your choice in the provided field To Specify the Date Format Check the box Specify Date Format The corresponding section is activated Cate Order Day Month Year E Date Separator Sample Separator not legal for a date In the list Date Order select in which order you want the day month and year to be displayed Inthe field Date Separator enter the character s that will appear between the different date parts An example is displayed below the field Date Separator To Force the Encoding Check the box Force Encoding The corresponding section is activated UITF8 UTFI6 O Native C Latin Select the encoding you want to use for the generated text file Four types of encodings are available UTF8 UTFI6 Native Latin To Define the Number Format Check the box Number Format The corresponding section is activated h Number Format Se of Digits 1 74 In the field Number of Digits enter the number of digits to display after the decimal To Define an Angle Format Check the box Choose Angle Format The corresponding section is activated IZ Choose Angle Format Degrees Decimal ddd ddddd fig Select one of the four avaible options Degrees Decimal
19. efine Sub Sampling First Line o Last Line o In the field First Line enter the number of the line you want your sub sampled data set to begin with In the field Last Line enter the number of the line you want your sub sampled data set to end with To Set a Random Sub sampling Check the option Random Selection in the section Define Sub sampling O Advanced Mode Proportion lll In the section Random Selection use the Proportion slide to select the percentage of the original data set you want to keep In the field Random Seed enter a seed value for the sub sampling This step is optional Use the Proportion slide to select the percentage of the original data set you want to keep 2 2 Describing the Data Set To describe your data you can Either use an existing description file that is taken from your information system or saved from a previous use of SAP Infinitelnsight features Or create a description file using the Analyze option available to you in Infinitelnsight modeling assistant In this case it is important that you validate the description file obtained You can save this file for later re use If you name the description file KxDoc SourceFileName it will be automatically loaded when clicking the Analyze button Important The description file obtained using the Analyze option results from the analysis of the first 100 lines of the initial data file In order to avoid all bias we encourage y
20. eld Mapping click the icon A window opens allowing you to edit the field mapping 2 Click the Guess button Infinitelnsight modeling assistant tries to map the fields based on a name similarity and on the fields storage format Note Two fields can be mapped together only if they have the same storage format 3 To modify a mapping that seems incorrect or that has not been found 1 On the line corresponding to the mapping to modify click the Target Field column 2 Inthe drop down list select the target field you want to map with the source field 4 When all the fields are mapped click the Check button If all the fields are correctly mapped the OK button is enabled else a diagnostic message Is displayed 5 Click the OK button to validate the mapping 4 2 Selecting Variables The panel Variable Selection allows you to choose which variables you want to exclude from the data set To Exclude a Variable 1 Select the variable to exclude in the Variables Selected for Transfer list 2 Click on the gt button located on the left of the Excluded Variables screen section Note All the lists can be sorted by the order in the file or alphabetically CUSTOMER SAP Infinitelnsight 7 0 14 2014 SAP SE or an SAP affiliate company All rights reserved Data Transfer 4 3 Saving the New Data Set This panel allows you to duplicate a data set into a file or a data base table Y To Save the Data Set 1 Use the Browse button located
21. emove Estimator CUSTOMER SAP Infinitelnsight 7 0 27 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 6 1 3Generating the Statistics Y To Generate the Statistics 1 Dn the screen Summary of Modeling Parameters click the Generate button The screen Training the Model will appear The model that will compute the statistics is being generated A progress bar will allow you to follow the process E InfiniteInsight VX y z class _Census01 File Help Training the Model EA ECK a ala pee B Stop View Type Copy Print Save FXPortto PowerPoint Starting Model learning Ai Stop Current Task 44 Cancel 4 Previous lk Next 2 Once the model has been generated click the Next button 6 1 4Statistics Debriefing The screen Statistics Debriefing allows you to display the statistics generated for the data set to test a new data set for deviation and to save the statistics Displaying the Statistics The Display section provides you with the following tools to debrief the statistics the model Summary displays information on the model generated such as the number of variables the performance indicators the target information and so on Note If you have not used an estimator of the target the performance indicators are not filled the Model Graphs depending on the type of the target the model graph plot allows you to View the realizable profit that pe
22. eserved About this Document 2 Common Steps This section of the document describes the data source selection the data description which are steps common to several of the Toolkit features IN THIS CHAPTER Selec Ino a Data OO luis pisto 4 Descibino the Daa RE ERE EDT 7 2 1 Selecting a Data Set Y To Select a Data Set 4 In the list Data Type select the data set file type Use the Browse button located on the right of the Folder field to select the folder or database containing the data set Use the Browse button located on the right of the Data Set field to select the data set file or table E KXEN Infinitelnsight Select Data Set Source Data Type Text Files Folder Samples Census Data Set Census0Lesy C Users Team Text Als un Click the Next button If the data source is stored in a Oracle Teradata or SQL Server 2005 data base an additional warning may be displayed asking you to validate the execution of the query For more information refer to chapter Special Case Data Stored in Databases on page 5 CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved Common Steps 2 1 1 Special Case Data Stored in Databases the Explain Mode Before requesting data stored in a Teradata Oracle or SQLServer 2005 database SAP Infinitelnsight uses a feature called the Explain mode which categorizes the performances of SQL queries in s
23. ess CUSTOMER SAP Infinitelnsight 7 0 41 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics Edition The Edition tab shows the Postion Variable the Data Set used for the Geolocation and the Target It also offers the options Selection Copy Graph and Settings Lee d d r tay Tiles Position Variable Position Data Set ai CEET lt 49 50000000 4 782 5 49 50000000 49 782 49 50000000 49 782 lt 49 50000000 49 782 0 0069691 lt 49 50000000 49 782 lt 49 78333000 50 148 lt 49 78333000 50 148 lt 49 78333000 50 148 lt 49 78333000 50 148 lt 49 78333000 50 148 lt 49 78333000 50 148 lt 49 78333000 50 148 lt 49 78333000 50 148 lt 49 78333000 50 148 0 013370 1 63221E 49 78333000 50 148 1 46839E lt 49 78333000 50 148 0 010634 1 34812E 49 78333000 50 148 0 00934 1 19037E 49 78333000 50 148 5 71315E lt 50 14842000 50 333 3 09741E 4 7 58316E lt 50 14842000 50 333 2 1189E 50 14842000 50 333 7 73088E 50 14842000 50 333 1 49919E 50 14842000 50 333 1 73479E 0 00418151 00418151 lt 50 14842000 50 333 0 0041815 1 7483E 50 14842000 50 333 0 00418 1 57172E E Do Not Use Scientific Notation Values Will
24. everal classes defined by the user In order to be as fast and as light as possible this categorization is done without actually executing the full SQL query l Note 1 For all versions of Teradata 2 For all versions above and including Oracle 10 The objective is to allow you to estimate the workload of the SQL query before executing it and then deciding possibly thanks to an IT Corporate Policy if the SQL query can actually be used For example an IT Corporate Policy may favor interactivity and then define 3 classes of SQL queries each with its maximum time Immediate duration lt 1s The query is accepted and executed immediately Batched 1s lt duration 2s The query is accepted but will be executed on next idle time Rejected Zs lt duration The query will never be executed The number names and limits of classes are defined by the user in order for these values to match the current DBMS configuration and DBMS usage policy The Explain Mode has been Configuredlf the Explain mode has been configured by your DBMS administrator there are two possible outcomes to a query the query is accepted and executed this is completely transparent SAP Infinitelnsight accesses the data without further input from the user the query needs to be validated before being executed a pop up window opens displaying a message configured by the DBMS administrator A query that needs validation can be categorized in t
25. he first n lines of the data set option Compute statistics over the n first lines a sub sample of the data set Advanced option ec Sample Data View Mp xl DataSet Keeser O S Compute statistics over the whole data set Compute statistics over the 2 000 first lines CUSTOMER 2014 SAP SE or an SAP affiliate company All rights reserved SAP Infinitelnsight 7 0 Descriptive Statistics The time needed to compute the statistics depends on the quantity of data to analyze so the larger the number of lines the longer the analysis When you click on the selected option the statistics generation starts A progress bar is displayed allowing you to follow the process soc Learning When the analysis is over the statistics are displayed X KXEN Sample Data View Ioj xj Data Set census01 csv Variables Category Frequendes Continuous Variables Debug Tree aj asu Variable Value Storage Missing Count age continuous integer workclass nominal string fnhwgt continuous integer education nominal string education num ordinal integer marital status nominal string occupation nominal string relationship nominal string race nominal string Sex nominal string apital gain continuous integer capital loss continuous integer hours per week continuous integer native country nominal string class nominal integer Kxindex continuous integer B c B Oe Oe OO e Oe OO e OO OO CH Edit Settings am
26. iables Detected Yes Nominal Targets Target Key 0 Frequency 5 87 1 Frequency 94 13 The panel Statistics Debriefing is displayed CUSTOMER SAP Infinitelnsight 7 0 39 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 15 Gotosection Tiles i KXEN InfiniteInsight EmptyPopulation_BE_HEADER_EmptyPopulation Statistics Debriefing alii Display Summary Category Significance Statistical Reports Parameters Tiles d ee Run Analyze Deviations Apply Model EI Save Save un Cancel Previous The Tiles screen appears It is composed of four tabs Edition Export GIS Geographic Information System CUSTOMER SAP Infinitelnsight 7 0 40 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics WES Web Feature Server e Tiles stc Sco i amp Position Variable Position longitude latitude 8 sel lt 49 78353000 50 148 TENE II EE e 5 o 00289092 a e Lime Les E Ae es SE rc USO sze isi 0 00834386 119037655 lt 49 78333000 50 148 328 0 00144546 f SEE PET INN enee ee m S 30974E4 7 7 088E 80 14942000 50 333 l 0 00454287 1 49919E 5 50 14842000 50 333 0 00531723 ees lt 150 14842000 50 335 8 0 00418151 lt 50 14842000 50 333 sa 0 00418151 aries o a a anaona E Do Not Use Scientific Notation zn will be D
27. ight New Descriptive Statistics Data Description Add Filter in Data Set Lg Analyze LD open Description KL Save Description view Data exa E3 metri e acc opena en f The described data appears KXEN InfiniteInsight New Descriptive Statistics n Guessed Description mm vm H 7 mtinuou Be taladmindcode Integer continuous p b III portion integer continuous p o O O 1 9 i amp eewton kg nominal 9 raf ASS Y _ Add Filter in Data Set Qe Dome Moo H EIL CUSTOMER SAP Infinitelnsight 7 0 35 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 5 Selecta variable click right choose Composite Variables KXEN InfiniteInsight New Descriptive Statistics d Guessed Description 15 populatio SEH zeen Missing NS Translate categories for population Define Structure The panel Composite Variables appears 6 To Adda Composite Variable click Add Composite Variables Edit Remove CUSTOMER SAP Infinitelnsight 7 0 36 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 7 Enter a Name a Type a Latitude a Longitude Composite Variables l x Name Position Type Position ka K Composite Variables Name Position Type Position cd EEE Latitude Longitude Lx a Longitude
28. ital loss hours per week d ne Excluded Variables 1 c H _ Alphabetic Sort EI H M Alphabetic Sort I Note On the screen Selecting Variables variables are presented in the same order as that in which they appear in the table of data To sort them alphabetically select the option Alphabetic sort presented beneath each of the variables list CUSTOMER SAP Infinitelnsight 7 0 21 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 4 Click the button gt located on the left of the screen section Target Variables upper right hand side The variable moves to the screen section Target Variables Also select a variable in the screen section Target Variables and click the button lt to move the variables back to the screen section Explanatory variables selected To Select a Weight Variable 1 Un the screen Selecting Variables in the section Explanatory variables selected left hand side select the variables you want to use as a Weight Variable 4 SAP InfiniteInsight VX y 27 New Regression Classification Model File Help Selecting Variables Explanatory Variables Selected 14 Target Variables 1 workclass fniwot education education num marital status occupation relationship race sex _ Alphabetic Sort capital gain Weight Variable 0 capital loss EN hours per week en native country Excluded Variables 1 _ Alphabetic Sort H M Alphabetic Sort I Note O
29. n the screen Selecting Variables variables are presented in the same order as that in which they appear in the table of data To sort them alphabetically select the option Alphabetic sort presented beneath each of the variables list CUSTOMER SAP Infinitelnsight 7 0 22 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 2 Click the button gt located on the left of the screen section Weight Variable middle right hand side The variable moves to the screen section Weight Variable Also select a variable in the screen section Weight Variable and click the button lt to move the variables back to the screen section Explanatory variables selected To Exclude some Variables from Data Analysis 1 Un the screen Selecting Variables in the section Explanatory Variables Selected left hand side select the variable to be excluded 4 SAP InfiniteInsight VX y 27 New Regression Classification Model File Help Selecting Variables Explanatory Variables Selected 14 Target Variables 1 workclass fniwot education education num marital status occupation relationship race sex _ Alphabetic Sort capital gain Weight Variable 0 capital loss hours per week native country Excluded Variables 1 _ Alphabetic Sort H M Alphabetic Sort I Note On the screen Selecting Variables variables are presented in the same order as that in which they appear in the table of data To sort them
30. on n Previous CUSTOMER SAP Infinitelnsight 7 0 44 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 6 Save the file File name Geoloc_test kml Files of type DO 7 A pop window indicates that the export has been completed and that the file can be opened Note For the first export click Close Go to the folder where the file was saved and open it manually with GoogleEarth software Check the box Always use the selected program to open this kind of file so that you will be able to open directly your file from Infinitelnsight interface 8 Open the file KXEN InfiniteInsight EmptyPopulation_BE_HEADER_EmptyPopulation Position Variable Position Data Set All Target EmptyPopulation x je SE Mean m 80 9307 9 0498 lt a9 78333000 S6 re fa 5553000 CTC k ser s g E 4 kema 9 mM 146 2n amp una Cancel TO The Tiles appear in GoogleEarth CUSTOMER SAP Infinitelnsight 7 0 45 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 46 Google Earth File Edit View Tools Add Help Y Search S ex er 01 SE Search ex pizza near NYC Get Directions History Y Places E G Sightseeing Tour Make sure 3D Buildings layer is checked E MS Temporary Places Kl Geoloc_test kml Dal lo Earth Gallery O M Primary Data
31. ou to mix up your data set before performing this analysis For more information on data set description see Infinitelnsight User Guide M i To Load a Description File On the screen Data Description click the button Open Description The following window opens Folder Samples Census ka File Name Em CUSTOMER SAP Infinitelnsight 7 0 2014 SAP SE or an SAP affiliate company All rights reserved Common Steps 2 Inthe window Load a Description select the type of your description file 3 Inthe Folder field select the folder where the description file is located with the Browse button l Note The folder selected by default is the same as the one you selected on the screen Data to be Modeled 1 Inthe Description field select the file containing the data set description with the Browse button A Caution When the space used for model training contains a physical variable named KxIndex it is not possible to use a description file without any key for the described space When the space used for model training does not contain a physical variable named KxIndex it is not possible to use a description file including a description about a KxIndex variable since it does not exist in current space 1 Click the OK button The window Load a Description closes and the description is displayed on the screen Data Description a SAP InfiniteInsight Vx y 7 New Regression Classification Model File Help Da
32. owse Output Data Set age_categories txt 2l Browse Click the Next button A progress bar is displayed allowing you to follow the process CUSTOMER SAP Infinitelnsight 7 0 18 2014 SAP SE or an SAP affiliate company All rights reserved List Distinct Values 5 When the file has been created successfully the following panel is displayed Click View Output C KXEN InfiniteInsight Data Transfer V ES o Distinct Values Extraction Successful Input kxsrvmulti2 sglserver2005 dbo CensusFromText ren COR gt are Output C Wsers Public age Categories txt ren Alestore um SEN 6 Click the Next button to go back to the Start panel CUSTOMER SAP Infinitelnsight 7 0 19 2014 SAP SE or an SAP affiliate company All rights reserved List Distinct Values 6 Descriptive Statistics This component allows you to generate variables statistics for a data set such as the cross statistics or the profit curves when a variable in the data set is used to estimate the target variable It can be accessed either through the option Descriptive Statistics of the Start panel or by using the option View Data provided when selecting a data source in any KXEN component IN THIS CHAPTER sitio ET SE AT EEA A TE EAEE A TEET 20 From the Panel View Data 29 E o A NESEHENEERER ORESRPEEREELESIRANR 32 6 1 From the Start Panel vV To Access the Descriptive Statistics from the Start Panel 1 Dn the Start panel click the option Get
33. p Help 6 2 2 Viewing the Statistics Once the statistics have been computed the following tabs are displayed Variables which displays a list of the variables found in the data set with their value their storage value the number of missing value for each variable and their role during the modeling Category Frequencies which displays for each variable the complete set of its categories their frequency and the number of occurrences of each category Weighted Count Continuous Variables which displays for each continuous variable the minimum the maximum the mean and the standard deviation CUSTOMER SAP Infinitelnsight 7 0 3l 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 6 3 Geo location Pre requisites Install GoogleEarth Add Preferences in the Geolocation section To Add Preferences in the Geolocation Section 1 Launch the SAP Infinitelnsight Preferences panel KXEN InfiniteInsight X InfiniteInsight NX Toolkit Open the Data Viewer Perform a Data Transfer List Distinct Values in a Data Set tive Statistics for a Data Set z Message level L B Log Maximum Size Message Level for Strange Values 12 Display the Parameter Tree Number of Store in the History Always exit without prompt Indude test in default cutting strategy CUSTOMER SAP Infinitelnsight 7 0 32 2014 SAP SE or an SAP affiliate company All rights
34. rtains to your business issue using the model generated when the target is nominal Compare the performance of the model generated with that of a random type model and that of a hypothetical perfect model when the target is nominal CUSTOMER SAP Infinitelnsight 7 0 28 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics Compare the predicted value to the actual value when the target is continuous Note The model graphs are not available if you have not selected an estimator of the target beforehand the Significance of Categories the importance of each category of nominal or ordinal variables and the importance of each bin of the continuous variables are displayed the Statistical Reports SAP Infinitelnsight provides you with a set of reports allowing you a detailed debriefing of your data set Running the Model The option Analyze Deviations of the Run section allows you to load a new data set to control if any deviations exist between the new data set and the one used to build the model Saving the Model The Save option allows you to save the statistics and to load them at a later time like any KXEN models 6 2 From the Panel View Data The panel View Data can be opened from various panels of SAP Infinitelnsight especially from any panel allowing you to select or describe a data source It is identified by a button with a magnifier such as Ja or 1 a View Data This panel
35. set refer to the section Common Steps on page 4 then go on with reading the sections below IN THIS CHAPTER Selecting the Variable to n e sssrscosi interan rene kor EE na EHn rora RENANE EE E rN ENE NKE IEEE Or r HA KEERATA ETORREN nitisi 18 SE Mee e el 18 CUSTOMER SAP Infinitelnsight 7 0 17 2014 SAP SE or an SAP affiliate company All rights reserved List Distinct Values 5 1 Selecting the Variable to Extract The Settings panel allows you to select the variable for which you want to extract the categories Y To Select a Variable 1 Check the variable in the list Select Columns to Extract C KXEN InfiniteInsight Settings Select Columns to Extract KxIndex age capital gain capitaldoss F dass T education T education num l fnlwat 2 Click the Next button 5 2 Saving the Categories 1 Thenext panel allows you to save the variable categories extracted from the data set vV To Save the Variable Category List 2 Inthe list Data Type select in which format you want to save the category list 3 Usethe Browse button located on the right of the Folder field to select the folder or data base where the file will be saved 4 Enter the name of the file or table to create or use the Browse button located on the right of the field Output Data Set to select an existing file or table KXEN InfiniteInsight Output Store Space Data Type Text Files Folder C Wsers Public r El Br
36. ta Description Li Open Description 3 Save in Variable Pool Y a Kri T Analyze Lal save Description Remove from Variable Pool View Data Properties Description O Description Desc_Census01 csv Index Name Storage Value Key Order Missing Group Description Structure 1 age number continuous 0 0 79 2 workclass string nominal 0 0 3 3 fnlwgt number continuous 0 0 gl 4 education string nominal 0 0 dl 5 education n number ordinal 0 D 6 marital status string nominal 0 0 T occupation string nominal 0 0 Mi relationship string nominal 0 0 da Brace string nominal 0 0 E 10 sex string nominal 0 0 if 11 capital gain number continuous 0 0 99999 gl 12 capital loss number continuous 0 0 a 13 hours per w number continuous 0 0 Mi 14 native country string nominal 0 0 15 class number nominal 0 0 79 16 KxIndex integer continuous 1 0 Automaticall E Add Filter in Data Set pm m 2 Click the Next button CUSTOMER SAP Infinitelnsight 7 0 8 2014 SAP SE or an SAP affiliate company All rights reserved Common Steps 9 3 Data Viewer The Data Viewer allows you to visualize existing data sets and if needed to delete them vV To Display the Data Sets List 1 Dn the Start panel click the feature Open the Data Viewer in the section Toolkit Version Open the Data Viewer Perform a Data Transfer List Distinct Values in a Data Set Get Descriptive Statistics for a Data Set The panel
37. tering used to generated the cluster index was supervised select the Cluster Target Cluster Target EE UN Un CUSTOMER SAP Infinitelnsight 7 0 26 2014 SAP SE or an SAP affiliate company All rights reserved Descriptive Statistics 6 Repeat steps 2to 5 if there are more than one cluster index For example if the data set contains the results from two different clustering tools so that you can compare the statistics directly on the same data set 7 Inthe Distance list located below the estimators list select the distance that was used to evaluate the proximity of two given individuals in the original clustering model EY KXEN Infinitelnsight class apply K25 census Model Advanced Parameters The available distances are defined as follows Chessboard maximum of absolute differences between coordinates LInf Euclidean square root of sum of square differences between coordinates L2 City Block sum of absolute differences between coordinates L1 8 Inthe Encoding list located below the estimators list select the encoding that was used in the original clustering model The encoding used by default when generating a clustering model with SAP InfiniteInsight is Target Mean if the model is supervised Unsupervised otherwise 9 Once all cluster estimators have been indicated click the Validate button To Remove a Cluster Estimator 10 Select the estimator variable to remove 11 Click the button R
38. tion the panel Data Manipulation Transfer will be displayed see Transferring an Analytical Data Set see Transferring a Data Manipulation on page 13 CUSTOMER SAP Infinitelnsight 7 0 12 2014 SAP SE or an SAP affiliate company All rights reserved Data Transfer IN THIS CHAPTER Transferring a Data Manmpulaton nenne neuen nnennnnnnnnnnnnnnnnn nenne nnnnnnennnnnnennnnnn nennen 13 Selecting EE UE 14 Saving the New Dala Set E E OE a A ERE E EEE 15 4 1 Transferring a Data Manipulation When transferring a data manipulation the panel Data Manipulation Transfer allows you to select the target database to define the mapping between the source tables and the target tables and if needed to define the mapping between the table fields Y To Define a Transfer 1 To select the target database that is the database in which you want to transfer the definition of the analytical data set click the Browse button then select a database in the displayed dialog box Click the OK button to validate your selection In the field Transfer as enter the name you want the analytical data set to be identified by KXEN InfiniteInsight Data Manipulation Transfer Target Settings Target Database kxsrvmulti2_sglserver 2005 El Browse Transfer as kxenodbeclient_to_transfer El Browse Target Metadata Repository C Users denise ortiz caso Documents Samples OM Text Files El Browse Table Mapping Source T
39. to be executed without validation In that case check the box Do not request validation anymore for similar requests The validation message will then only appear for larger queries This configuration will only be used for the current session when closing SAP Infinitelnsight it will be lost For a permanent configuration see your DBMS Administrator who will find the necessary information in the support document Explain Mode available in section Support and Integration Documentation of SAP Infinitelnsight documentation 2 1 2 Sub sampling a Data Set Sub sampling can be achieved by selecting a specific first line and last line from the original data randomly selecting a proportion of the original data A random seed can be used to select the same records from the original data when sub sampling mixing the selection by line and the random selection vV To Define the Sub sampling Settings Click the button Advanced Settings located on the right of the field Data Set A pop up window opens allowing you to set the sub sampling parameters Random Seed 1960 Define Sub sampling E Line Selection First Line 0 Last Line E Random Selection Adwanced Mode Proportion CUSTOMER SAP Infinitelnsight 7 0 6 2014 SAP SE or an SAP affiliate company All rights reserved Common Steps Y To Set a Line Selection 1 uli AA Check the option Line Selection in the section Define Sub sampling D
40. tor of the Target 1 Select the tab Target Estimator 2 Inthe Variables column click the variable you want to use as an estimator 3 Click the corresponding cell in the column is Estimator of A list of available targets is displayed Model Advanced Parameters Target Estimator Cluster Estimator Variables Is Estimator of age eoigs molas E houspemk 00 OD 4 Select the target to be estimated 5 Repeat steps 2 to 4 for all the estimator variables 6 Click the Next button SAP Infinitelnsight 7 0 CUSTOMER Descriptive Statistics 25 2014 SAP SE or an SAP affiliate company All rights reserved Cluster Estimator When using a data set that results from a model apply and that contains identified clusters for each record this tab allows you to indicate the columns containing the cluster indexes It can be useful to generate statistics such as the size of each cluster and the residual sum of squares on these clusters One typical use is the comparison of clustering results obtained thanks to different tools or with different methods To Add a Cluster Estimator 1 Select the tab Cluster Estimator 2 Click the button Add Estimator A variable is added to the list of estimators 3 Click the variable name to display the list of all variables KH KXEN Infinitelnsight class_apply_K2S_census Model Advanced Parameters Select the variable containing the cluster index in the list 5 Ifthe clus
41. ts reserved Data Viewer 4 Data Transfer The component Data Transfer allows you to transfer a data source to another location or format vV To Start a Data Transfer 1 Dn the Start panel click the option Perform a Data Transfer in the Toolkit section Ed KXEN Infnitelnsight aa x X InfiniteInsight Version 6 1 0 Create a Clustering Model Create a Time Series Perform a Text Analysis Y at Social Create a Social Network Analysi Perform a Data Transfer List Distinct Values in a Data Set Get Descriptive Statistics for a Data Set The panel allowing you to select the data set you want to transfer is displayed 2 Select the data set you want to transfer see Selecting a Data Set see Selecting a Data Set T on page 4 If you want to transfer an analytical data set a message box will be displayed after clicking the Next button asking you whether you want to transfer the data contained in the analytical data set or if you want to transfer only its definition Transfer a Data Manipulation O Would you like to transfer the data or the definition of the data manipulation irte do If you choose to transfer the data the data transfer component will act as if it was a classical data set and ask you to describe the data see Descriptive Statistics on page 20 and to save the new data set see Saving the New Data Set on page 15 If you choose to transfer only the analytical data set defini
42. urposes only without representation or warranty of any kind and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such i products and services if any Nothing herein should be LB EP Ist construed as constituting an additional warranty SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks ID P E 2 or registered trademarks of SAP SE or an SAP affiliate company in Germany and other countries All other product and service names mentioned are the trademarks of their respective companies Please see hti WW SsaD C or additional trademark information and notices ei P N E A
43. wo ways n e medium sized You will probably have to check with your administrator to know which action to take Ifthe administrator authorizes the query click the Continue button The pop up window closes and the requested action is carried out ftheadministrator does not authorize the query click the button Stop Query the pop up window closes but no action is executed e huge It means that the query will take too much time and resources In that case the behavior of the Continue button depends on the configuration set by the DBMS Administrator for example it can automatically refuse queries that are considered too heavy In any case you should check with them to know the line of action to follow CUSTOMER SAP Infinitelnsight 7 0 5 2014 SAP SE or an SAP affiliate company All rights reserved Common Steps The Explain Mode has not been Configured If your DBMS Administrator has not configured the Explain mode the following pop up opens when you try to access the data SC Query Validation B xj o The Explain feature is not configured Your validation will be required for all queries E No longer request validation for similar queries Show Details um Stop Query Vp Continue You need to contact your Administrator who will tell you which action to take and configure the Explain mode If the Administrator validates the execution of the query you may want all queries with the same duration

User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents