Home

Veera User Manual - Rapid Insight Inc.

1. r W Rapid Insight Veera Workstation Job Demo Complete II ja EEN ei File Edit View Job Connection Node DataView Schedule Tools Window Help SE debe Down Conglahe A Job tab also known as the Job Workspace opens connections GE sl sob SY EISE be Es SBP o de when a user creates a new job rer Exolmert Das Or CA E gf Zon or selects an existing job Jobs G i Major Lookup sot Vu dbo Financial Aid data Type dad are projects created by users Tasks that gather data from one or hr EEN N SS L na a a Zo more data sources known as N ien e gie E s eme Get ge F Connections manipulate D gz n EER men Teer T 1 00 1 2 3 j that data with various tools or vn da O Qg v R known as Tasks and Aggregate 8 Reports za ek produce one or more outputs ui IS ak in the form of files or report s ai A Lookup known as Reports and By Students Top 10 Runables Many Job tabs may be opened though only one can be viewed at a time MAIN MENU The main menu appearing at the top of the window provides several options unique to Jobs tabs when one is in view Rev 7 14 ig Rapid Insight Veera User Manual Data View Tabs DESCRIPTION A Data View tab opens when a user selects Data V Rapid Insight Inc Veera Data View Transpose Example View from the toolbar menu or View Data when __ Eie Vi
2. RAPIDINSIGHTINCMfeischer OPEN Opens the job selected in the list 03 05 2010 08 45 04 03 05 2010 08 45 21 SCHEDULE Opens the Schedule Viewer window for that job jon D ass schedule l Be 100 DELETE Deletes the selected schedule dob finished with Success STOP Stops the selected scheduled job from running ee Paced 461 Rowe OE Last Status DETAILS Displays details of the last running of the selected job eee cessed 1000 Rons 100 s Reading schedule ae Processed 10000 Rows 100 Last Status Reading HISTORY Displays details of all the scheduled runs of the job Node selected Merge Processed 1016 Rows 100 MAIN MENU The main menu appearing at the top of the window provides options identical to those offered by a Data View tab Rev 7 14 Rapid Insiahte Veera User Manual Docking Undocking Windows DESCRIPTION With the exception of the Workspace tab tabs may reordered in the program or even undocked from Veera to float as a separate window This is done by selecting the tab then clicking and dragging it to a new location The tab will be removed from the list and a free floating window of the same name and contents will appear on the screen To dock a floating Veera window select the frame then on its copy of the menu click VIEW gt DOCKED The free floating frame will disappear and a tab of the same name and content s will appear in the program window
3. i High School GPA from the previous node You have the option of Gm S 9 Ascending lt Use the same rank for ties New Rank Column Name High School GPA_Rank Rapid Insiahte Veera User Manual selecting any of the input columns into Group By or Rank By Rank By is used to sort and rank If no Group By is chosen rankings are created for the entire population or for every record based on the Rank By variable Only one variable may be chosen to rank by If values are null they are excluded from the rank If duplicate values exist Veera ranks them all based on the first one it comes to Rank order is set to either Ascending or Descending New Rank Column Name displays the new column name The optional Group By field orders the ranked values by the selected column s which should contain a limited number of unique values CREATE INDEX If neither the Rank By nor Group By fields are populated the task will rank records by their position in the dataset starting with 1 TRANSPOSE COLUMNS ale Loaded Data Statistics Co Hz zt ZJ AX 34 Total records queried 10000 gt Transpose allows users to identify the unique entries d person Obs person month sales fe D 2 1 ik found under a specific column and build one or more J sales EE sets of new columns from them All the data records mike mar r julie jan are then reorganized to populate the new columns julie feb with the selected val
4. Collaborative Cloud Title Healthcare dashb Veera Category Veera Job CONTRIBUTING TO THE COLLABORATIVE CLOUD EE E Healthcare dashboard featuring 2 dial indicator 30 day and 60 day Ri g ht click on the item to be u p loaded j ob tran sform j readmit rates and 4 column charts showing demographic breakdowns of readmission rates chart style add in then select the Contribute item type to RI Collaborative Cloud menu option For example right click on a Veera job within the Jobs section of the Attachments Optional Workspace tab Once selected the Contribute to Rapid Insight Collaborative Cloud window will open with the original name of the item already entered at the top Readmit N Rates csv The user must enter a unique name a description of the item and check the Terms and Conditions box before the EE Eg al e item can be contributed Additional files typically related 1 file attachment s sample data may also be contributed as part of the 7 accept the Tems amp Conditions dd Click the Contribute button to perform the Era transter GETTING ITEMS FROM THE COLLABORATIVE CLOUD To copy an item from the Collaborative Cloud and add it to the list of those available right click on the table or folder where items of that type are listed For example right click a job folder within the Workspace Jobs section where the job should be stored Select Get Job from RI Collaborative Cloud
5. EE Rapid Insiahte Veera User Manual Edit Parameters This control manages the parameters established by users and DER available for use in configuring the nodes of the current job Oe Parameters named variables are user defined specific to each job Name Data Type Value Prompt For Value and applied to formulas found in a variety of nodes Analysis Year Integer 2011 Ed Location Text Main Checking the Prompt for Value box will cause a pop up dialog box to appear any time the job is run requesting the user enter a new value for the parameter Undo Redo Use these buttons to undo or redo any recent actions performed in the Job Workspace Save and Save and Exit Use the first button to save any current work Use the green checkmark to save any current work and exit the node or exit the job Wizards IMPORT SCORING MODEL with without SEP Overview When users of the Rapid Insight Analytics product create a predictive model it is saved as an rism file That file contains the mathematical formula the optional standard error of the prediction SEP and all the related variables that define the model It s typically used within Analytics to apply probability scores to records trying to predict the behavior the model was designed to address The Import Scoring Model Wizard allows a user of Veera to make use of that same rism model file This way Veera can be used to assign probability scores then b
6. Because these scores are being aggreagated by na Gender one record of median SAT scores will Visited Campus appear for each unique value of gender found in the incoming data CLEANSE COLUMN DATA Overview p H Cl Cle cE Cleanse Data is used when column data need Wh Cleanse State Cleanse fe File Edit Sort to be replaced or rounded based on one or 5J EI A laa I more user defined tests Student T Replace Operation When State Replace with NH T Replace With Lag 1 Financial Aid Offered _ v Name State_Cleanse nar met ithe malla da Ka Cleanse Operation Name Cleanse Type Cleanse Operation Rapid Insiahte Veera User Manual Defining a Replacement Test Clicking on a column name from the list on the left selects it as the source of the data to test Then the type of test is chosen from the following options e Equals e Not Equals lt gt e Greater Than gt e Greater Than or Equal To gt e Less Than lt e Less Than or Equal To lt e In specified list e Not In specified list e Contains found within column value e Does Not Contain not found within column value e Starts With the specified value e Ends With the specified value E 5 Cleanse High School GP e Is Missing no value exists may be File Edit Sort filled with the value of an earlier TT d Student 10 EE Found Operation SERGE
7. Double clicking on a converted INPUT PROXY node opens its setup window Here the column names and data types found in the original INPUT node may be seen and if desired changed OUTPUT PROXY WS An OUTPUT PROXY is a type of output node It s the point where data is returned to the SUBROUTINE node that originally caused the job to run e Only one OUTPUT PROXY may be added per job e Data can enter this node from only one source Rev 7 14 Rapid Insiahte Veera User Manual e The OUTPUT PROXY need not be the only output from the job though when called from a SUBROUTINE node only the OUTPUT PROXY will be updated There are no configuration settings for this node SUBROUTINE A SUBROUTINE node defines the location and the conditions for incorporating one job s E process into another The node itself acts as a gt matchmaker marrying the individual data 2010 seen gt 88 PK m Ca S sources entering the SUBROUTINE node with specific INPUT PROXY nodes found in the called E Subroutine Aggregate Report job Once that called job finishes running any data entering its OUTPUT PROXY node is then 2009 Enrollment passed back to SUBROUTINE to continue on through the job Unlike most nodes SUBROUTINE can accept multiple streams of data as inputs CONFIGURING A SUBROUTINE NODE To configure add the SUBROUTINE node to the job then double click on the icon to access its setup window This window is divided into three secti
8. Reverse REVERSE Returns the reverse of a character expression Right RIGHT len Returns the right part of a string the specified number of characters in length Round ROUND Round value to the nearest integer value RTrim RTRIM _ Returns a character string after truncating all trailing blanks Second SECOND Returns an integer that represents the second part of a specified datetime SecondsBetween SECONDSBETWEEN date Returns an integer representing the of seconds between 2 dates Sign SIGN Returns the positive 1 zero 0 or negative 1 sign of the given expression Sin SIN Returns the trigonometric sine of the given angle in radians in an approximate numeric real expression Space SPACE Returns a string of repeated spaces Square SQUARE Returns the square of a given expression Rev 7 14 Rapid Insiahte Veera User Manual Sart SQRT Returns the square root of the given expression Str STR Returns the character data converted from numeric data Stuff STUFF start len new Deletes a specified length of characters and inserts another set of characters at a specified starting point SubField SUBFIELD fieldNum Returns the Nth sub field from a string where the fields are delimited by commas SubField SUBFIELD fieldNum Returns the Nth sub field from a string where the fields are delimited by the specified delimiter default is comma SubString SUBSTRING start
9. and then release the mouse button e Drag anode over an existing connection between two other nodes When the connecting line turns blue drop the node to insert it into the existing path at that point e Drag and drop a new node the destination onto an existing source node When connected a line graphic be drawn between the nodes An arrowhead at one end of the line will indicate the direction data will flow Disconnection Methods To remove a connection to a node e Right click on a connecting line and select Delete from the menu e Select a connecting line and press the DEL key e Select a connecting line and then use the Delete Selected Item s tool from the Job Workspace Toolbar e Right click on any node except those with multiple input or output connections and select DISCONNECT or DELETE from the menu Connection Rules Some connection rules to consider e Data Connection nodes can never be the endpoint of a connection from another node Rev 7 14 Rapid Insiahte Veera User Manual e Except for Output Files runable nodes cannot be the starting point of a connection to another node e Call Job Command Compress Uncompress and FTP nodes can never be connected to another node e Only a few nodes can accept more than one input These include o Append Table o Merge Table o Lookup Column Data o Output Report e These nodes should directly output only to Output Table and Repor
10. 1 The column name may be changed by entering a new one in the Flag Column Name field LOOKUP COLUMN DATA File Edit Sort We ARIE Input Source Lookup By a Enrollment Major_CD Column Name Type a International Applicant Integer 5 GE MAJOR CD Lookup Column provides a fast and efficient way to se retrieve values from a lookup table One data Fe eg source will appear as the Input source and the second is the lookup source In the example shown the first source contains a code for Major and the second source contains the description being looked up The user chooses the Lookup By column in this case it s the Major_CD field It is joined to the MAIOR CODE in the Lookup Source The column to add to the output is the one containing the value looked up above it s the Major Description coming from the lookup source Lookup Column is limited to 10000 unique values in the Lookup By column SAMPLE RECORDS Sample Records outputs a subset of the data entering it The user determines the number of records to be output or skipped and the method of their selection There are five different sampling methods e Random Sample Type Top e To D File e Bottom Sample Types e Skip top N rows D Random Top Bottom Skip top N rows Top N records to sample D 1000 e Range From To An integer parameter may be used in place of an explicit number of recor
11. Also note that there are three Excel file types to choose from Database Oerder two Office 2007 versions xIsx and xlsb and the legacy version EG N ER di xls The correct file type must be selected for the intended data Workbook folder source to appear as an option I Rapid Insight Excel Driver It has come to our attention that Microsoft Excel Input data drivers attempt to determine a column s data type using the first eight records and as a result often passes numeric values as nulls Formatting of the corresponding column in Excel has no effect on this behavior To mitigate this Rapid Insight has developed its own Excel data driver for use when connecting to data sources and destinations It appears in the driver list as Excel File xls xlsx xlsb and is the default driver selected when the Excel icon is clicked The driver actively reads the formatting of the original worksheet cells to develop its columnar data types When this information is not available it will attempt to infer this information from the fields in a column The number of fields used to make this educate guess is specified in the Type Guess Sample Size field under the Options menu As an output driver it takes the Veera column types and matches them to corresponding Excel format types when writing to a worksheet ORACLE SOURCE TYPE Setting up a PC to connect to your Oracle Database If the user is currently connecting to
12. EET HEER Round Column e Always always replace with the value ST manens some y y p State Round Up Round away from of an earlier lagging record ers AE ae Round Down Roundto Nearest Enroll Precision Integer 0 id S Visited Campus Clicking on ADD will save the test and the een ae H D Intemational Applicant 34 4 becomes 34 intended action When the conditions are Financial Aid Offered 34 Sbecomes 25 O asem ere ne i 34 5 becomes 35 met Cleanse will overwrite the existing data ainarra es 35 4 becomes 35 A percent with kids 35 5 becomes 36 E with the new value percent poverty eer ad assistance Name High School GPA Add Sample rows 5000 v Cleanse Operation Name Cleanse Type Column Name Cleanse Operation Rounding Tests When a numerical column is selected for evaluation additional test options are made available These include Enter the value to replace e Round Up e Round Down e Round away from zero e Round to the Nearest even In the second example shown the column High School GPA was selected from the column on the left A test was added to Round Up the values encountered Multi Select Bulk Replacement or Rounding If the same Cleanse action needs to be performed on several columns hold the Ctrl button while clicking on the desired names This will select multiple columns around which a test may be designed Once added a separate entry for each colu
13. New Quantile Column Name Custom quantiles may also be entered in the of Quantiles field Quantiles may be assigned in ascending or descending order RENAME EXCLUDE COLUMNS 12 J Rename Exclude Columns Column Source 77 File Edit Sort Be DO 2 Ay AA ra oO Zz Column Name New Name The Rename Node changes the names of columns or excludes them completely from appearing on the output The new names appear in any node that is connected after the rename node When the rename node is first opened a list of all of the fields appears To rename a field type the new name in the New Name column directly to the right of the old name To exclude a column uncheck the corresponding KEEP box MAJR_DESC1 Major PIDM_KEY_Distinct Total Students Spring Retention falltospring retained_Mean falltospring retained_Sum Spring Count falltofall retained_Mean Annual Retention falltofall retained_Sum Annual Count 6 of 6 columns selected Rev 7 14 Rapid Insiahte Veera User Manual CONVERT COLUMN DATA TYPE 1 00 LG 4 Convert Column Data type is used to easily change column data types For example when attempting to merge two disparate data sources that have the same information but are of different data types like INTEGER and TEXT Also used when fa ivy Type Convert need to append information of the e same content but different type A Z Ax A All of the input columns are listed
14. OPERATION ASSOCIATIVELY Expression Left to right Scalar Functions Left to right el s reent jeten 7 lt s gt le Is Equality mr Bitwise AND Left to right itwise on inclusive 1 tefttoright BETWEEN 10 11 12 BETWEEN Logical BETWEEN Left to right 7 2 List Left to right SSES SES SS RSC a a a Rev 7 14 Rapid Insiahte Veera User Manual Date and Time Format Specifiers Many functions require or allow certain formatting options to be specified SPECIFIER DESCRIPTION EXAMPLE wd The day of the month from 1 through 31 6 1 2009 1 45 30 PM gt 1 gg The day of the month from 01 through 31 6 1 2009 1 45 30 PM gt 01 dda The abbreviated name of the day of the week 6 15 2009 1 45 30 PM gt Mon en US dddd The full name of the day of the week 6 15 2009 1 45 30 PM gt Monday en US The tenths of a second in a date and time value 6 15 2009 13 45 30 617 gt 6 The hundredths of a second in a date and time 6 15 2009 13 45 30 617 gt 61 value The milliseconds in a date and time value 6 15 2009 13 45 30 617 gt 617 ffff The ten thousandths of a second in a date and 6 15 2009 13 45 30 6175 gt 6175 time value fffff The hundred thousandths of a second in a date 6 15 2009 13 45 30 61754 gt 61754 and time value ffffff The millionths of a second in a date and time 6 15 2009 13 45 30 617542 gt 617542 value fffffff The ten millionths of a second in
15. Returns part of a string beginning at the specified start position to the end of the string SubString SUBSTRING start len Returns part of a string beginning at the specified start position and continuing for the specified length Tan TAN Returns the tangent of the input expression Today TODAY Returns the current date Upper UPPER Returns a character expression with lowercase character data converted to uppercase Week WEEK Returns an integer expression representing the week that the specified date falls in 1 53 Weekday WEEKDAY Returns Weekday or Weekend WorkdaysBetween WORKDAYSBETWEEN Returns an integer representing the of workdays date between 2 dates Year YEAR Returns an integer that represents the year part of a specified date YearsBetween YEARSBETWEEN date Returns an integer representing the of years between 2 dates YearsBetween YEARSBETWEEN date 1 Returns an integer representing the absolute of years between 2 dates ZipCode ZIPCODE Returns a 5 character zipcode converted from string or numeric data Illegal values are output as text Rev 7 14 Rapid Insiahte Veera User Manual Function Operators Because functions have such a high priority they almost always reduire their parameters be in parentheses to achieve the expected correct result ABS A is the same as ABS A but ABS A B is not ABS A B but is ABS A B PRECEDENCE SYMBOL TYPE OF
16. Rev 7 14 Rapid Insiahte Veera User Manual WORKSPACE TAB OPERATIONAL WORKSPACE Data Connections in the Workspace DATA CONNECTIONS OVERVIEW A data connection or just connection can be thought of as a pointer It shows Veera where data is located on the local computer or on another computer on the local network It can reference either a file folder or a database on a server Once created a connection may be used over and over again by any number of different jobs The Data Connections section of the Workspace tab is where all connections used throughout the product appear and are managed created modified or deleted New connections can also be made from any Job tab _ Rapid Insight Inc ol File View Job DataView Schedule Tools Window Help Workspace 4 Jobs 7 39 CRM Reports 7 3 Folder 1 Testing 4 Demo Local Complete A Licenses Activation Report 4 NEW Freshmen Retention A SQL Job O Tutorials 4 App Lost Reports mj Data Connections L l Access E Excel a SQLServer a CRM a KEEN ik TESTING SQL a LE Tutorial Aid Text Active Processes Creating a Data Connection Note creating a data connection does not actually create any folders files or tables It only creates a reference within Veera pointing to an existing folder on the host computer or network Define a new connection to a data source or clone an
17. Student distance from school Enroll Visited Campus Major_CD scholarship_amt work_study_amt SAT Combined V Consider Null Values to be Duplicates GQ Student ID Selection Rule s T Discard All Copies of Duplicate Records Min Not Null Nall When duplicate records are found based on the DeDup By columns follow the Selection Rule s until no duplicates exist control over which duplicate record continues towards the output In the example below the SAT Math is being used as a Selection Rule Therefore if a duplicate Student ID is found it takes the record with the Max SAT Math score Other options are Min Not Null and Null Any values in the Input Columns may be used in the Selection Rules Applying the Discard All option removes each and every copy of a record that has duplicates FIND DUP RECORDS He Find Dup is used to find duplicate records that may exist in a data source and output these records All of the input columns will appear on the left hand side The user can then select one or more columns to find duplicates by One can then connect an output node to this to receive all of the duplicate Find Dup By Columna J Consider Null Values to be Dupkcates Rev 7 14 Rapid Insiahte Veera User Manual records In order to get just a list of those duplicate records the user may wish to add a dedup node right after the find duplicate to see a list of those IDs or
18. Type Fixed Width Fields Tab This tab appears only if the FIXED WIDTH option was chosen on the File Properties Tab The user may manually set the data column s start and end points or may import a format schema to do this automatically e FIELD POSITIONS RECORD WIDTH sets the intended width in characters of each row of data e FIELD POSITIONS FIELD To E 7 File Properties D jfleischer Desktop fixedwidthexample tt Fixed Width Fields Define Fixed Width Fields To define fields you must pick the fields out in the row data Confirm that the field properties are comect before proceeding Field Positions Format File supported data types are shown below Specify the starting position of each column Col 1 Text 15 1 i Col_2 Real 5 16 To create a column click the desired first character Col 3 Gase 6 21 D To delete a column click the first character of the column Col_4 DateTime 8 27 1 f Col 5 Boolean 1 35 p emee Soo ES EI 10 A 35male NJblue M 44femaleNHred 31male CTorange 76femaleWAgreen 88femaleNJred SSmale CTblue lt Back Net gt Cancel Ne Ede bede manually set column start and end points the user clicks on the point in the sample data where a data column starts Columns will alternately shade as they are added User may remove a column pointer by clicking on the same point The TOT
19. Veera Data View Students w Aic O E File View Job Data View Schedule Tools Window Help node in order for the headers to be used otherwise they will appear as Loaded Data Statistics a row of data S ba Sy Z x GA Total records queried 10000 gt LY Obs Coll Col Col3 Col4 Col5 Col6 NOTE Regardless of their Original 1 Legacy Gender Frequency Percent Cumulative Frequency Cumulative Percent 2 Non legacy Male 2603 58 2603 58 column types all data emerging Non legacy Female 1615 36 4218 94 from this node are converted to type ae ee EE f Legacy Student Female 122 3 4498 100 Text Because of this care should be taken when using the output of this task GROUPBY REPORT File Edit Sort GroupBy Report is used in designating how an output ZRNA A should be sorted and grouped and the associated column values formatted GroupBy must output to a Report node in order for the headers to be used otherwise they will appear as a row of data NOTE Regardless of their original column types all data emerging from this node are converted to type Text Because of this care should be taken when using the output of this task Include Totals for Data Columns PROFILE REPORT A Profile Report is used to summarize a column s basic Statistics The user may choose any column to profile Select from the left side and double click or use the arrow to identify the Profile columns There a
20. a job involves several steps These steps may Jb SPENT SSP dy be performed any number of times and in any order desired V B R I PLACE NODES CONNECTIONS TASKS AND RUNABLES Winter Se Transpose Aggregate Output INTO A JOB These components are placed into the Job Workspace En SPSS in one of three ways i Output 2 e Double clicking on the Connection Task or Runable icon or e Dragged and Dropped e Right click on a Connection only and select Add Input Node Once in the Job Workspace icons are referred to as nodes Nodes may be repositioned by dragging and dropping them Nodes may be removed from the Job Workspace by e Selecting the node and pressing the DEL key e Right click on the node and selecting Delete from the menu e Draw a group select box around several nodes and then use the Delete Selected Item s tool from the Job Workspace Toolbar RESYNCRONIZING A TEXT SOURCE INPUT NODE A Changes made to a text file data source may not always appear in the related Input Node or worse an error may result In the past replacing an affected Input Node was the only solution Now clicking Rev 7 14 Rapid Insiahte Veera User Manual the Resynchronize to Connection button allows an Input Node to recognize and reflect any changes in its text source s schema Resynchronizing an Input Node to reflect changes in its text type data source is a two step process First check to
21. days Viewing Cached Data Caches allow users to directly view cached data by right clicking the node 02 16 2010 09 17 AM and selecting View Data from the menu This feature is the same as that ache 02 18 2010 09 17 AM found on Data Connections and Output Tables nodes Flush Cache Now SUBROUTINES OVERVIEW Subroutines allow designers to make use of existing jobs from within a new process shortening development and running times while opening a new range of processing possibilities Nodes in Target Job Input Proxy Handle Missings Calculate Probability Output Proxy C d College Enrollment Data Cleanse FA_WM csv E e d m Be Major lookup Lookup Report 24 gt p Aggregate By Students Top 10 Rename An effective subroutine requires the following e A base job containing one or more SUBROUTINE nodes must be created Each SUBROUTINE node is configured to send data to and pass on data received from a target job Rev 7 14 Rapid Insiahte Veera User Manual e One or more target jobs must be created Such jobs are designed to be used only as part of a subroutine and not run on their own o Atarget job may receive some or all of their data from a SUBROUTINE node through one or more INPUT PROXY nodes o Atarget job must contain one and only one OUTPUT PROXY node Data entering this node is passed back to a SUBROUTINE node The effect is as if all the nodes pr
22. duick reference and tutorial includes several How To examples e n program Help accessed from the Veera Toolbar menu e In program Tooltip help placing the mouse cursor over a feature often causes a brief description to appear Rev 7 14 NA Rapid Insight Veera User Manual VIEWS IN VEERA Workspace Tab DESCRIPTION The Workspace tab also known as the Operational Workspace automatically opens when the program first starts It serves as the place where users organize and manage data projects see Jobs in the Workspace data source connections see Data Connections in the Workspace and see what gd File View Job DataView Schedule Workspace 4 Jobs o 39 CRM Reports ij Folder 1 3 Testing 4 Demo Local Complete amp Licenses Activation Report Tools Window Help se NEW Freshmen Retention jobs might currently be running known as Active 2 SAL Job a 49 Tutorials Processes App Lost Repos MAIN MENU g Data Connections E Access 38 Excel E say SQLServer CRM Ui Financial Aid Data i TESTING SQL Lk Tutorial Aid o H Ted The main menu appearing at the top of the window provides several options unique to Workspace when in view Note that there is only one Workspace tab If closed it can be reopened by selecting Workspace from the program s Window toolbar menu P Active Processes Job Tabs DESCRIPTION
23. ee Ee Ge ee ke eie ee GE ee de Ge Gie 27 CLEANSE COLUMN DATA NENNEN 27 TRANSFORM e BE IC 29 ORT RECORD oe E N ee ee ge ee AR De ne ee ee n ee EE Ee 32 De DUPRI CORD ae ins ee N OE De OGE OE EN Ee be We ee OE SE RM EE OG GE Ge GE GE EE 32 FINO DUP RECORDS ee soe soe GE Ee ee a DE ee EE ee EG Ge EE N Ge De oi RE Ge 32 OUANTIIE REEORD aie store sie Ge ie Go n Ge ee N se re Do n ee Ge ei 33 RENAME EXELUDE OH Heer 33 CONVERT COLUMN DATA TYPE oos ee reed oe ee ed EON ee Moe ee Mi ee eed 34 RANKING RECORDS ss ged EE 34 TRANSPOSE COLUMNS ser see see ei ee EE Ge EE Ee oe DIe 35 KEE EH 36 SUBROUTINES OV EIR WIE WY esse eene Gee ee oe ee ee ee RO RE oe a Ga GE oe ei 36 INP dad POO EE N N EE EE IE Ee N 37 OUTF UI PRE ES EE 37 lee RR osse ee ie ee ie ee NR Gee ee ee ei ee ee ee n ee GE Re Gee De ee oe 38 REDUCE VAR DIES ese os ione eect oe ii ee Ge n mtn ee bo ie ee ie ee ee Ge ee ER ei ed 39 PERIE G E 40 MODEL E 40 EE 42 FS DOI AE N EE OE EE EE EE EE 42 Rev 7 14 Rapid Insiahte Veera User Manual KREE EE 42 FORMA COLUMN DA TA essens ee cree ce telnet aes alee eva trea ea oem ee Dee eee EE GED ee ee toa ae EE eie 42 CROSS TAB KEPORT sos ge ees ee ie ee ee oe ee ee Ge de Ee Se ee Ge ee ee EG ere Ee 43 FPREQUENCY REPORT ese ee ct covets Re GE Ee ct vests Re GE Ee at EE Re GE Ee EE 43 GROUPE de EN EE N EE EN N N EE EE EE EE NE 44 PROFILE REPORT RE EE EE ER EE EE EE EE NN 44 PP E 45 FCI OS aes be RR EE N EE EE N N OE EE OER ER N 4
24. existing one New Existing e Open the Create New Connection dialog box Connection Name by doing one of the following o Right click anywhere in the Data Source A aa 3 Lx hr N org EA GE ty 28 Workspace gt Data Connections section and select New Connection Microsoft OLE DB Provider for Excel Z Database Connection Select the folder with the Excel workbook files o Right click in any Jobs gt Connections section and select New Connection or o Select Toolbar gt Connection gt Add New e Enter a unique Connection Name e Select a Data Source by either o Clicking the icon of the corresponding data type or o Selecting the corresponding data type from the drop down list e The dialog box changes to request the information unique to each type This means either o Identifying the folder location or o Identifying the database server location database name and connection information Rev 7 14 Rapid Insiahte Veera User Manual Selecting Tables for a Data Connection Once a data connection is saved the user can create references to the specific files worksheets or database tables views found in that location These specific references are collectively referred to as tables Tables appear beneath their parent connections in alphabetic order To add a table e Right click on the data connection and choose Select Tables e Select the file s worksheets etc to be used from
25. formula parameter it acts as a wildcard with features beyond those of an asterisk a Functional STE COMBINE INPUTS Table Pattern Example SCH Parameter Regex CX xlIs Selects all worksheets from all Excel xls files that start with the characters CX followed by exactly two characters When an underscore in square brackets is used as a formula parameter it applies the value of the previous record Typically used in conjunction with the ISNULL function to avoid problems with the first record in the dataset Parameter Lag TRANSFORM Multi variable Example IF _ IS NULL 100 _ 1 Creates an incrementing series in the new column Starting at 100 Contact Us For any issues questions about Rapid Insight Veera please send an email to RI Support at support rapidinsightinc com Rev 7 14
26. jon macmillan rapidinsightinc com use the Tableau Online Refresh Extract Password Password Node Sitename Text rapidinsightinc Datasource Text Scored Apps NOTE it is important that for this add in to Project Tert default be used the original file will have to be in Original File Text Scored Apps csv csv format Once all values are entered this behaves just like any other runnable node There are 7 required parameters for this node e Server URL this is the destination site for the data source This does not include your personal site name but rather the Tableau Online site name and this value should already be entered and should not change e Username the username that you use to access Tableau Online This is generally an email e Password the password that you use to access Tableau Online Rev 7 14 Rapid Insiahte Veera User Manual e Sitename This is specific to your institution s online account If you are unsure what your site name is this can be found in the web address to tableau online ad https online tableau corm sitelfapidinsigftine datasources e Datasource The name of the data source as listed in your Tableau Online account If you go to the Data Sources tab in Tableau Online this will be the value that is listed under Name H it tableau Projects Workbooks Views Data Sources 1 v 0 selected t Name Connection type Connects to Live Last extract Project Owner M
27. produce an error or unpredictable results This node is available only from the Job Tabs Program Toolbar under the NODE gt ADD TASK menu Reports OVERVIEW These are report formatting options designed to be used in conjunction with an Output Report runable to provide a particular look or style Veera provides 6 unique report styles that can be incorporated into any job There is no limit to the number or types of reports styles that can be used though there are some restrictions on their order The 6 report types styles are 1 Format Column Data found only under the Node gt Add Report menu Cross Tab Report Frequency Report Group By Report ee HI Profile Report 6 Chart Data Right clicking on a report will open the Help Menu entry for that icon in a separate window rm Format Data FORMAT COLUMN DATA Be Et Sot ma DO 2 il ri Column Name Data Type Format Major Integer Verbal Min Integer Format Data is used to set specific formatting on fields for Verbal Max Integer S S f Decimal report outputs Other options exist such as those listed The Math Min Integer Hexadecimal n Integer Scientific Keep column allows users to select which columns will or will e Se Currency not appear at the output of the node ayes Real mr Regardless of their original column types all data emerging Rev 7 14 Rapid Insiahte Veera User Manual from this node are converted to type Text Because of this care should be ta
28. see if the File Properties of the Connection Table need to be updated e Right click on the table s entry in the Connections window and select Text Properties e If you receive a Schema doesn t match file message click the Discard Schema button located in the upper right of the window e Click Finish Second open the configuration window of each affected Input Node by double clicking on it The button will be found in the bottom right corner of the configuration window Click on the button to resync the node to the new schema Removals will appear in red new entries in blue Save and close the window CONNECTING NODES TO CREATE PROCESS PATHS Connection Methods Nodes can be connected in one of several ways e Use the Job Workspace toolbar tool Node Connect Mode fr Input Test_csv csv File Edit Sort AY 2x a Ha On 2 Column Name Area Number Section Name Day Time 1 Time 2 Location Room Instructor ID Size Crosslisting BLERM CONSTANT TERM iii EA SS ils il Optimization Help dv Text Text DateTime DateTime Text Text Text Integer Text Text Integer Text Connection Test_csv csv Input e Use Alt Left Mouse to drag the source node to the destination node dis e Right click the source select Begin Connecting Nodes then select the destination e While holding Alt Left Mouse draw a group select box around several unconnected nodes
29. the Oracle Fm server from their machine then it s a simple matter of picking an appropriate driver from the list of Define a new connection to a data source or clone an existing one available drivers as part of their Veera data a ae connection We recommend either the Oracle Connection Name OLEDB ADO NET for Oracle or NET for Oracle ae iese drivers though any Oracle driver that appears in the Des Suen BEEF OGEESBAABE list of available drivers should work EE EET If the user isn t currently connecting to Oracle their machine needs to be configured to do SO Usually this To connect to Oracle Server you must specify the data source name user name requires an IT person to setup the machine EES Database Connection Use Windows Authentication Use Provided Credentials e Verify that the IT department will allow the Veera user to directly access the Oracle Varia Database Password e Have IT create access credentials on the Database Oracle server granting the Veera user at ae able least read access to the desired database EE schemas or specific tables e Identify and install the correct Oracle Client with all available drivers on the Veera user s computer The Oracle Client version should be compatible with the Oracle server s version Rev 7 14 Rapid Insiahte Veera User Manual If known the user may type the Oracle server and database names directly into the appropriate fields The only
30. to which source is which appears at the bottom of the screen Renaming Output Columns In the example shown the columns Phone and Telephone will both appear in the Append output as separate columns even if the data contained in them is the same Fortunately users may rename columns in an Append This allows data from two or more sources to end up in the same output column even when their source column names are different To rename a column right click a column name and choose Rename or just double click the column name then type in the new name Once entered the Append will re align with other fields of the same name In the example re naming the column Telephone to Phone will keep the column Telephone from having to be created The Telephone data coming from source 2 will now appear under the output column Phone along with the data from source 1 EE Append Data Sou File Edit Sort dy Ay ds Gender High School GPA SAT Verbal SAT Math SAT Math BINS State Legacy Student distance from school Text Text Text Integer 2 A Al A A A A A E E Enroll Integer Creating a Source Id Column E Create Source ID Column Name Source_ID Checking the box Create Source ID Column creates the new variable Source ID in the output file It stores a value indicating from which input the specific record came from By default the values w
31. tum Integer Gave to Annual Fund Integer ID Text Legacy Indicator Integer E E E ee ui N ui F or Chi Best Fit Related p value threshold loot e Y Variable lt jave to Annual Fund dv Find Related Now Create Related Best Fit Transforms Create Related Category Transforms X Y R Exclude whens 0 33 of 33 columns will be kept Identifying Related Fields When the Find Related Now button is clicked the node will perform a series of statistical tests Chi Square F Test etc on the data in each column In addition to the variable itself several mathematical transformations of the original are also evaluated for relevance These variations include square square root cube cube root log10 and natural log g Variable Reduction File Edit Sort MM OO Aa AA OO Z Options AJ 2x AA Column Name RI_ 25plus_wBA_G state Legacy Indicator Reunion Year Flag RI_ HHs_wRetirelnco Forbes500zip On Linkedin Major Do not call flag RI_ Vacant_Housing On Committee RI_totHouseHolds_T RI totHouseHolds G RI totPopulation T RI totPopulation G Urban Rural Indicator ID Age zip Twitter Follower parent_grand_cur_stu 29 of 33 columns will be kept Type Keep FValue w Real Text Integ Integ Real Integ Integ Text Integ Real Integ Integ Integ Integ Integ_ Text Text Integ_ Text Integ T
32. will consist of all the entries found in the Input node regardless of whether this data had been removed at some stage Use the report s Remove Empty Column setup option to hide any unwanted columns bE TA Zl xia feb NOTE Regardless of their original column types all data emerging from this node are converted to type Text Because of this care should be taken when using the output of this node FREQUENCY REPORT lt gt File Edit Sort OOK ODER Frequency Reports help to understand the counts of unique values represented in the data for any particular field In the example below the frequency is being determined by Gender At the bottom right of the window you can select the sort by and sort direction of the data You can also choose the percent format Running this to an output gives each unique value of gender the number of times it was represented in the Column Name Student ID High School GPA SAT Verbal SAT Math SAT Math BINS State Student distance from school HN Enroll International Applicant Financial Aid Offered percent with college degree percent with hs degree percent older than 65 rcent with kids Frequency Columns Column Name ui Descending Der L WC Rev 7 14 Rapid Insiahte Veera User Manual data the it amounted to as well as the cumulative freduency and percent Freg uency must output toa Re port V Rapid Insight Inc
33. will update and overwrite the existing data source If you would like to just append to the existing data source use the Tableau Online Append Extract Node Rev 7 14 Rapid Insiahte Veera User Manual NOTE it is important that for this add in to be used the original file will have to be in csv format Once all values are entered this behaves just like any other runnable node There are 7 reduired parameters for this node Server URL this is the destination site for the data source This does not include your personal site name but Addin Tableau Online Refresh Edract Node rather the Tableau Online site name Add In Parameters Name Data Type Value and this value should already be Sener URL Text https online tableausoftware com entered and should not change Usemame Text eise aan amr Password Password m Username the username that you Gian Text BCEE use to access Tableau Online This is Datasource Text Scored Apps l Project Text generally an email Gel File Text Password the password that you use to access Tableau Online Sitename This is specific to your institution s online account If you are unsure what your site name is this can be found in the web address to tableau online https online tableau com site datasources Datasource The name of the data source as listed in your Tableau Online account If you go to the Data Sources tab in Tableau Online this will be the value tha
34. 31333 0 70795092 0 863556766 0 825542 4 w p e ROW DELIMITER Determines what Se constitutes a new data row Selectappropriatefileproperies CS Options are CR carriage return LF line feed CR LF default comma semicolon tab and vertical bar Rev 7 14 Rapid Insiahte Veera User M e TEXT QUALIFIER Determines how anual data that contains a column delimiter is quoted Options are Double Quote default Single quote and none e SAMPLE SIZE Defines the number of data rows to load to evaluate the structure Default is 20 Delimited Fields Tab This tab appears only if the DELIMITED option was chosen on the File Properties Tab Provides a sample of the data set using the Field Del FIELD DELIMITER Options include and other with entry field e FIRST ROW CONTAINS FIELD NAM imiter chosen comma default semicolon tab vertical bar tab colon ES Yes or no checkbox e COLUMN COUNT Drops E File Properties Q Demo Data College Enrollment Data FA csv existing or adds new data columns Default is based on the current column count detected by the delimiter selected IMPORT FORMAT FILE If the user chooses to set up the data columns automatically the user needs to import a Delimited Fields Define Delimited Fields To define fields you must first choose the delimiter and set the field count Confirm that the field properties are cor
35. 5 2009 1 45 30PM gt 06 Mmmm The abbreviated name of the month 6 15 2009 1 45 30 PM gt Jun en US ts KE KE The second from O through 59 6 15 2009 1 45 09 PM gt 9 The second from 00 through 59 6 15 2009 1 45 09 PM gt 09 The AM PM designator MMMM The full name of the month 6 15 2009 1 45 30 PM gt June en US ywy The year with a minimum of three digits 1 1 0001 12 00 00 AM gt 001 wyw 1 Theyear as a four digit number 1 1 0001 12 00 00AM gt 0001 z 1 Hours offset from UTC with no leading zeros 6 15 2009 1 45 30 PM 07 00 gt 7 Hours offset from UTC with a leading zero for a 6 15 2009 1 45 30 PM 07 00 gt 07 single digit value ween Hours and minutes offset from UTC 6 15 2009 1 45 30 PM 07 00 gt 07 00 pt Thetime separator 6 15 2009 1 45 30 PM gt en US The date separator 6 15 2009 1 45 30 PM gt en US Rev 7 14 Rapid Insiahte Veera User Manual Special Parameters This section documents unidue parameters that do not fit neatly into other categories yet expand the user s abilities and contribute to the utility of the program SYMBOL TYPE BEHAVIOR DESCRIPTION When an asterisk is used as a formula parameter it acts as a wildcard COMBINE INPUTS Table Pattern Example Parameter Wildcard Gase DEG nrollment Data Selects all files regardless of type that start with the characters Enrollment Data When the function is used as a
36. 51 183 0 048741689 0 218329894 0 005 504174 Male 2 909 650 480 NH Non legacy 10 0 0 45 12 5 1 13000 0 176445699 0 114648724 0 859373111 0 084532071 0 1764 e FILE TYPE S pec ja fo rmat ty pes 941891 Male 2 342 620 560 ME Non legacy 90 0 0 44 12 1 1 12400 0 325332144 0 0625307 0 882583363 0 298308585 0 32533 722819 Male 2 068 530 600 ME Non legacy 50 0 0 50 12 1 10600 0 887588627 0 132030981 0 659904358 0 219229673 0 88758 m 378790 Male 2 455 710 480 NH Non legacy 75 0 0 45 12 1 14200 0 360543079 0 0887027 0 42031131 0 104902305 0 36054307 use d un d ef specia circumstances 608665 Male 2 249 500 510 NH Non legacy 140 0 0 48 11 7 1 10000 0 381320558 0 316074737 0 529793783 0 160525764 0 381 780531 Male 2 901 480 600 Non legacy 20 0 0 40 12 8 0 9600 0 972855237 0 70173725 0 908409572 0 622612621 0 97285523 O oti ons are Default OEM ASCII 150941 Male 2 029 550 550 MA Non legacy 30 0 0 55 9 6 1 11000 0 489145261 0 567791245 0 267320687 0 106936839 0 48914 652758 Male 3 549 480 710 NH Non legacy 45 0 0 43 13 6 0 9600 0 317450536 0 882303851 0 582799203 0 89303686 0 31745C 544796 Male 2 506 790 470 NH Non legacy 40 0 0 39 12 5 0 15800 0 233557058 0 170962451 0 580588498 0 975192862 0 233E U nico d e U TF 8 U TF7 919187 Male 2 707 540 540 NY Non legacy 15 0 0 54 11 6 0 10800 0 6172791 15 0 467509006 0 225868667 0 509512058 0 6172 829597 Male 2 934 440570 NH Non leaacv 185 0 0 56 12 5 0 8800 0 825542433 0 997
37. 8 RUNABLE OVER ATTEN 48 OUTPUT TABEE ii ee E E E EE 48 TP KW ORI sere EEE ee A EE EEE ee OTE 49 FTP GET OR PUT FILE EEN 51 COMMAND EXECUTE EXTERNAL ENTITY sesse os n eed see a Ge Se Ge ee ee er 52 COMPRESS OR UNCOMPRESS FILES esse see see ses ee see see ees ee ee see see ee ee ee ee ee ee ee ee Ee ee ee ee ee ee ee ee ee ee ee 52 CALL ANOTHER JOB 53 CALL ANOTHER JOB FOR EACH INPUT esse ee se ee ee ee ee ee se ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee 53 SOP OD EE TE EE ER EE EE N ET RO EED 53 DYNAMIC EIIENAMING ees ee see se ee see see ee ee ee See Ee Ge ee GR Ee Re ee ee ee ee ee ee ee Ee ee ee ee ee Re ee ee ee Ee Re ee ee ee ee 53 C stom Nodes GROG WAS esse ER Oe DE ee T OD So GR EE De ER 54 SLEEP AD EEN n oe ee ated nies mete Ee eN ee ee Doe ee AR De ee Ee A ee EE Se ER ee Ee 54 TOE SUERG RRE RTR RE 55 TABLEAU ONLINE APPEND TO EXTRACT NODE ccceceecsecseceececcecsecsecscceceeeseesececeussesseeeeeeeoeseees 55 TABLEAU ONLINE REFRESH EXTRACT NODE ee see ses ee see see ees ee ee see see ees ee ee see see ee ee ee ee ee ee ee ee ee ee ee 56 Job Worker RE Ee ee ER AE ei ei Ee EG Ee 58 JOB WORKSPACE EE 58 JOB WORKSPACE TOOLBAR EE EE 58 EE ie er AE N EE EE N EA N E EO 60 IMPORT SCORING MODEL with without SEP ees see sesse ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee 60 JODS OVEFIC AE EE EE EE EO EE NE EE 62 CST le ee EE EE EE EE EE OE EE EE EE 62 PLACE NODES CONNECTIONS TASKS AND R
38. AL COLUMNS counter keeps track of the columns designated Rev 7 14 Rapid Insiahte Veera User Manual IMPORT FORMAT FILE If the user chooses to set up the data columns automatically the user needs to import a format file fmt with Format File Properties the desired parameters To start the me rors process the user clicks on the IMPORT E ee E op EE Caa DateTime 8 27 In the example shown a format file has Co Boolean 1 35 been selected Its contents appear in the Bees sample window The user uses the Field 1 nar Ges Geste ie j Column Name Starting Column e Field Length Field 2 Field 3 and Field 4 entries to help sane Veera interpret the layout of the format EE file This in turn defines the four columns 3 in the data file Starting Column Column W S Name Length and Type should all be defined The sample format file displayed shows the valid choices for Type Column Properties Tab This final tab of the File Properties window defines the data types and labels of each data column The user clicks on the column from the sample data field and then sets the following values CURRENT COLUMN Alternate method for selecting the column being configured NAME Column s name DATA TYPE The supported types include Integer Text Date Yes No Unknown and Decimal DATE FORMAT If the column s data f File Properties Q Demo D
39. Bins Binning High School GPA Low when High School GPA lt SAT_TOTAL Formula SAT Verbal SAT Math Real IF AJ gt 0 AND B 0 A B date time columns are found the column S list is blank Select column Editing a Transform Operation Transforms can be edited at any time by clicking the transform at the bottom of the window Once the edits are made click the Update button to update the transform A transform can also be removed by clicking the transform and clicking the Delete button Copying a Transform Operation Formulas and bins may be copied by right clicking the entry in the Transform Operation list at the bottom of the window and selecting Clone Transform An identical copy of that operation will appear in the list Exporting and Importing a Transform Operation Formulas and bins may be exported by right clicking the entry in the Transform Operation list at the bottom of the window and selecting Export Transform The program will allow the operation to be saved as a ritd file Formulas and bins may also be imported by right clicking the entry in the Transform Operation list at the bottom of the window and selecting Import Transform The program will allow the user to select a saved ritd file and add its operation to the existing list Rev 7 14 Rapid Insiahte Veera User Manual SORT RECORDS ai Sort reorders the records as specified by the user The left column shows th
40. Chart entering the node Each set of bars is labeled using data found in the column selected to be the Y Axis Label Gees Column Note that each data row must contain a unique DEER value in this column otherwise an error will result Single unit house How many bars appear in each set is determined by the HEM MedianYearsSchool Mean1 number of columns selected to be Selected Data lee ee Mean Columns The length or height of each bar is determined mm Eg N Moes by the values of data found under these same Selected Data Columns Note that the Selected Data Columns must be numeric Rev 7 14 Rapid Insiahte Veera User Manual Line Chart A Line chart is displayed as a grid The horizontal X axis is labeled with data found in the column selected to be the X Axis Label Column Note that each data row must contain a unigue value in this column otherwise an error will result The number of lines apearing in a Line chart is determined by the number of designated Selected Data Columns The Y axis of a Line chart grid is scaled automatically using all the values found in these same columns Note that the Selected Data Columns must be numeric Column Chart A Column chart is displayed as a grid The horizontal X axis is labeled with data found in the column selected to be the X Axis Label Column Note that each data row must contain a unique value in this column otherwise an error will result The number of vertical columns appea
41. Currency 712 345 68 Number 12 345 68 Percent 1 234 567 89 Integer 12346 Fixed 1 12345 7 Fixed 2 12345 68 Fixed 3 12345 679 Fixed 4 12345 6789 Fixed 5 12345 67890 Fixed 6 12345 678900 Fixed 7 12345 6789000 Fixed 8 12345 67890000 Fixed 9 12345 678900000 Fixed 10 12345 6789000000 Fixed 11 12345 67890000000 Fixed 12 12345 678900000000 Fixed 13 12345 678900000000 Fixed 14 12345 678900000000 Fixed 15 12345 678900000000 Integer w Sep 12 346 Fixed 1 w Sep 12 345 7 Fixed 2 w Sep 12 345 68 Fixed 3 w Sep 12 345 679 Fixed 4 w Sep 12 345 6789 Fixed 5 w Sep 12 345 67890 Fixed 6 w Sep 12 345 678900 Fixed 7 w Sep 12 345 678900 de sd SSS SS SSA A iii Connection Students w Aid ENE Fixed 8 w Sep 12 345 678300 d creating a new destination or overwriting any existing content e The dialog box changes to request the information unique to each type This means either o Identifying the folder location file name etc or o Identifying the database server location database name and connection information Once the information is populated the Test button becomes active so the connection information entered can be checked Once saved an Output dialog box appears listing the columns in order e Columns can be excluded by un checking the Output box e Columns may be individual
42. Impa ct on th e Visited Campus 0 0546667235748327 0 00822235733139639 EI International Applicant 0 065698452070168 0 012258895669997 5 R Square SSE CTSS 0 143973536572612 1332 74409120135 1556 8958999997 0 Starting Model Intercept chosen Y variable and when appropriate they will appear in the model formula m r 0 columns included 0 columns excluded other columns included based on p value threshold Build Model Now The easiest and fastest way to build a model is by clicking the Build Model Now button This option allows Veera to build what it feels is the best model that can be built on the current dataset It takes all non linearities in the data into account and makes all of the appropriate transformations on the candidate variables automatically Rev 7 14 Rapid Insiahte Veera User Manual MODEL INFORMATION The Model Information window contains all of the variables available when building a model It also displays the model s variable coefficients standard errors t values and p values All of the regression analysis steps taken to obtain the current model are also available by expanding the Model Steps section Share j A process that splits at a Share may be recombined later in the same job using a node such as Merge or Append This is a behavior unique to the Share and Cache nodes splitting a process at any other node and attempting to recombine it further on will
43. Input Columns Selected Legend Column In the last six months have you used the Internet to lo The Chart Data task permits users to incorporate charts into reports graphically depicting selected data The node offers six charting types Pie Bar Line Column Radar and Scatter All charts except Scatter use a Selected Data Column Name Format RespondentID_Count Dial Options Dial Area LI similar screen to select data for display This screen is vas EI tote ER ial ges also where a chart s presentation style is selected from a das Label Min Max Width Color list of available options Chart styles are user configured et u o ees ange low on the Chart Styles screen accessed from the TOOLS Ee an fae 1 See menu Pie Chart The number of slices appearing in a Pie chart is determined by the record count of the data entering the node The slices are labeled with data found in the column selected to be the Selected Legend Column Note that each data row must contain a unique value in this column otherwise an error will result Sample Pie The size of each slice is determined by the values of data found in the column selected as the Selected Data Column Note that only a single data column may be selected and that column must be numeric mmu 1 EE Bar Chart The number of sets of horizontal bars appearing in a Bar chart is determined by the record count of the data Title Appearing Within
44. List select Export and select the location where the file will be created To import a vcst file as a new chart style right click in any empty space in the Chart Styles List and select Import to load the new style into the system Rev 7 14 Rapid Insiahte Veera User Manual Runable RUNABLE OVERVIEW Runables are the finishing steps for jobs in Veera They provide the point where the results of the process are saved reported on and or sent along to someone else There are no limits to the number or types of runables that can be used in a job though there are some restrictions on their order e Output Table Runable e Output Report e FTP get or put File 5 d al WE RP e Command e Compress or Uncompress Files e Call Another Job e Stop Job Right clicking on a runable will open the Help Menu entry for that icon in a separate window OUTPUT TABLE Overview The Output Table Runable provides the means of saving data to a file or table Data can enter this node from only one source Connection Name Once the Output Table setup window is opened Students w Aid Configuring an Output Table Destination e Enter a unique Connection Name Data Destination A aa SP ae br N ora sy O amp e Select a Data Destination The types of data destinations available for use are generally the same as those available as data sources i e Connections As with Data Connections which data destination types are ava
45. Plan o m V dra data intelligence User Manual glat Insight ae decisions Rapid Insiahte Veera User Manual TABLE OF CONTENTS TS DOCOMO EE 6 Hardware Requirements esse sees see ee ee ee ee ee ee ee ee ee ee ee ee ee ee RE ee ee 6 Additional POS OUL EE 7 WOK PICE UO ai Ee GR ae ee GO re GE Oe GE Ge Re Go 8 DE ERIP OM E 8 Male Ale IR EE OE ess gene EE OR eee ER 8 Job WEE 8 DESCRIP NON EE EE EE IE 8 MAIN MENU EE EE EE N ORE ER ER Gade EE OE EN EE EE 8 BERUS Ee OE OE ET OE OE EE EE EN 9 DESCRIPTION EE EE OE ER OE EE EE 9 Mb Ale IR EE OE OE N EE RO SS 9 SCM CCG Here 9 DESCRIPTION WE 9 vale Hele IR EE EO OE ME OE EE EE EE EA 9 Docking Undocking WindOWS esse ee ee ee ee ee ee ee ee RE EE ee 10 BE els oa eN N RR RE EE N N RO ER OR RE 10 WORKSPACE TAB OPERATIONAL WORKSPACE cscsccscessscsssccscecssees LL Data CONNECTIONS in the Workspace sssssesssesssereesressscressrroserresrersseeessereseersseersseeesseeo 11 DATA CONNECTIONS OVERVIEW es Gn nee ie in nee des ee oe ee Ge ee ei ie de Go ee ie ie Ge De oie 11 Creating a Datatonne l Om sis SIE EN E GE GR ENE DS ERGE EG 11 Selecting Tables for a Data Connection 12 Data CONNECTIONS Source TYPES ENNEN 12 AEEESS SOURCE TIPE AAA 12 PACER SOURCE TI PE pects EE EE N RE N ON N Er 13 ORACLE 6 URER TYPE de n ee N Gee Ge ee ie oe Gee ee 13 SA CE TYPE ER ESE E Ge so vse GO Ee ees oe es 14 SP URCE TIEPE E 14 SOL SERVER SOURCE TYPE iis ees sei Ge ee
46. Project node is determined by the script it s running This will either be a report based upon a single text based column or a multi column dataset The Model node is used to perform the mathematical computations necessary to build a statistical model predicting behavior of a chosen Y variable The model is a mathematical formula that is comprised of one or more of the other variables found in the dataset Rev 7 14 Rapid Insiahte Veera User Manual In order for the Model node to be used effectively it must be preceded by a VRE node It s there that TEXT variables are evaluated for their model worthiness and when appropriate broken apart and converted into categorical BINARY variables for use at the modeling stage dv Type Use in Model Y Variable Text Enroll Text Model Type OLS C Logistic V Use forward backward elimination Student distance from school Integer E Sar AE oy V Use fast model method wise p valu ges High School GPA Real T V Use Y Intercept SAT Verbal Real m Create Scoring Subroutine Job SAT Math Integer E Legacy Integer Include VRE generated columns ApplicationDate Date Build Model Now Visited Campus Integer a International Applicant Integer dia Model Information 0 columns included 0 columns excluded other columns included based on p value threshold Model Types By using the Model Types users can customize their regression model Logisti
47. UNABLES INTO A JOB ees sees ese ee ee ee ee ee ee ee ee ee ee 62 RESYNCRONIZING A TEXT SOURCE INPUT NODE esse see sesse see see ee ee ee ee Ee ee ee ee ee Ee ee ee ee Ee Re ee ee ee ee 62 CONNECTING NODES TO CREATE PROCESS RATIHER ees sesse see see se ee see see ees ee ee see see ees ee see see ee ee ee ee see ee ee 63 CONFIGURE NODES TO DEFINE A PROCESS siese n deed 64 ENABLING OPTIMIZATION TO IMPROVE A RROCERbR ees sesse see ses ee see see ees ee ee see see ee ee ee ee ee ee ee ee ee ee 64 CLONING COPYING AND PASTING NODES ees sesse see se se ee ee GR ee ee ee ee Ee ee ee EER ee ee ee ee Ee Re ee ee ee ee ee 65 Notating Jobs Floating Notes 65 Rev 7 14 Rapid Insiahte Veera User Manual FeS Ne JODS es SEE EE EE E Ge E E Ge EE N EG Ge Si 66 VALIDA TE JOB tee ee see Ge ee ee ee ee ee Ge a ta ee ee oe ee ee ne oe 66 PRE GIE W KE 66 RONDINE JOD EE 66 RUNAGOE TOOLBAR CONTROL as asses Ee ei Be Ge RE ed de e BR GES oe ee GR De ee Re RA SE 66 RUN TO THIS OUTPUT ON 66 B is da RA RE EA EE HA EE EE 66 RUNNING JOBS FROM THE COMMAND UNE ese ee see see see see ee see see See ee ee ee ee ee ee ee ee ee ee ee ee ee ee Ee 66 eebe 67 SCHEDULE EDITOR iese ee GE ae re EE ee Ge De ie Ge Ee GE EG ss nesta aise ee ee er NE ee 67 SCHEDULED JOBS TAB eet 67 SCHEDULED JOBS DETAILS AND HISTORY ere Ge Ge Ge GE SNR OR Ge GE GN Re Ge WEG Ge Re ke Ge Gee eg 67 SENDING EMAIL NOTIFICATIONS FROM SCHEDULED JOBS esse see see see see s
48. UTING AND READING COMMENTS ABOUT Z Details ITEMS IN THE COLLABORATIVE CLOUD Title Retention Dashboard Contributor Jeff Fleischer Users may read comments on Collaborative Cloud items EE EG TUN pn by clicking in its Comments field or by clicking the ZE cription Comments button on the items Details window A EE separate Comments window displaying all the comments Tm 7 5 2012 9 55 AM Added Attachment Retention Dashboard vg their authors and their contribution dates will open 7 5 2012 3 55 AM Added Attachment Fal08 Al Students csv 7 5 2012 9 55 AM Added Attachment Fall09_AllStudents csv i 7 5 2012 9 55 AM Added Attachment Retention Dashboard vjf To add a comment click into the lower half of the 7 5 2012 9 55 AM Added Attachment Fall09_AllStudents csv Comments window and start typing Clicking the Add er Comment button will upload the text as a new entry al e al N Fall08_AllStud Fall09 Ai DELETING ITEMS FROM THE COLLABORATIVE CLOUD se oh Only the contributor of an item may delete it from the EES EG Collaborative Cloud A Delete button will appear at the RE SEE bottom of the item s Details page Clicking the button Geste will permanently remove the item i Printing Jobs There is an option to print the job Go to File and then Print Preview It will then generate a preview of what the job looks like If printing from there it will have the job itself as wel
49. User Manual menu The Email Notifications tab lists all the email recipients entered rapsie Demo sat into Veera It provides two fields On Success and On Failure into ee ee EE REISE arameters E Mail Notifications which they may be copied When a scheduled job is run an outcome SSS es email is sent to those on the designated distribution list Distributing Reports by Email Reports can be set up to auto email themselves when created by a job Deeg leer homain 77 run To configure this feature EE aT e Select Tools gt Options from the main toolbar menu Emad Address e Enter local email service setting on the SMTP Information and Reply To Address Distribution Lists tabs EE Host Name or IP Address To configure a particular report node to use the feature Port Number 25 Enable SSL Logon Information User Name Password e Open the report setup window and check Enable Distribution e Click the Distribution Setup button and select the recipient s Note Atest email will need to be sent Jest SMIE in order to test the SMTP information Save Saving Jobs Jobs are saved by e Clicking the Save or Save and Exit controls on the Job Workspace toolbar or e Selecting the Job gt Save option from the main program menu Exporting and Importing Jobs Veera allows users to share their jobs by exporting and importing them individually This is done by ei
50. Validate Formula A This button appears above the formula field It checks the contents of the formula field for possible syntax issues If a potential problem is detected an Invalid Formula error is displayed No message appears if the syntax is successfully validated String Functions Only TEXT columns are available on the String Functions tab Choose the text column to work with then fill in any parameters that are requested the function definition as well as the parameter definitions are contained in the Function Definition box Once the required parameters are filled in name the new transform and click the Create button If no text columns are found the column list is blank D D i ra sl LEI Date Time Functions el CRE de Only DATE TIME columns are available on ee the Date Time tab Choose the date field to deeg rg al e SE DateStr work with from the left Next fill in any ETT oe D 7 parameters that are requested the function Function Definition ee Retums a hy representing the day datepart of the specified date Sunday Minute definition as well as the parameter a Me a E 2 Quarter v definitions are contained in the Function New Variable Name Definition box Once the required mcmes Sos parameters are filled in name the new Wegen Geteste Gemeen SAT Combined Formula SAT Verbal SAT Math Real A B tra nsform then click the Create button If no High School GPA
51. a date and time 6 15 2009 13 45 30 6175425 gt 6175425 value If non zero the tenths of a second in a date and 6 15 2009 13 45 30 617 gt 6 time value If non zero the hundredths of a second in a date 6 15 2009 13 45 30 617 gt 61 and time value If non zero the milliseconds in a date and time 6 15 2009 13 45 30 617 gt 617 value If non zero the ten thousandths of a second in a 6 1 2009 13 45 30 5275 gt 5275 date and time value If non zero the hundred thousandths of a second 6 15 2009 13 45 30 61754 gt 61754 in a date and time value If non zero the millionths of a second in a date 6 15 2009 13 45 30 617542 gt 617542 and time value If non zero the ten millionths of a second in a 6 15 2009 13 45 30 6175425 gt 6175425 date and time value h The hour using a 12 hour clock from 1t0 12 6 15 2009 1 4530AM gt 1 hh The hour using a 12 hour clock from 01t012 6 15 2009 1 45 30AM gt 01 H 1 thehour using a 24 hour clock from Oto 23 6 15 2009 1 4530AM gt 1 hH The hour using a 24 hour clock from 00 t023 6 15 2009 1 45 30AM gt 01 K 1 Time zone information 6 15 2009 1 45 30 AM 07 00 gt 07 00 m The minute from O through 59 6 15 2009 1 09 30AM gt 9 Rev 7 14 Rapid Insiahte Veera User Manual mm The minute from 00 through 59 6 15 2009 1 0930AM gt 09 m 1 The month from 1 through 12 6 15 2009 1 45 30PM gt 6 Mm The month from 01 through 12 6 1
52. a tab offers custom formatting options for the section Though a Section Title can be added at any time most options can only be edited and applied once the Use Default Settings box is unchecked Adding Charts to Reports Report sm As with data sources each connection made between a Chart node and a Report node will appear in the Report node s setup window as a tab labeled with the chart node s title The order of these tabs will determine their presentation order in the report itself and can be changed by using the left and right Move Section arrows The display order is also depicted in the Layout image appearing on the right side of the setup window File Edit gt Header l Aggregate Dial Radar Med Pie Scatter Aggregate 2 Layout Section Title Chart Size for layout Chart Type Dial 5 Tiny 4 Smal mi V Force new section Custom Width 427 Height 320 A a e B Medium 4 D Large Ga Jumbo Opening a tab offers custom formatting options for the specific chart Some of these options such as title font and section margins can only be edited and applied once the Use Default Settings box is Rev 7 14 Rapid Insiahte Veera User Manual unchecked Others such as Section Title can be entered at any time Some of these options are unique to charts appearing in reports with the effects of choices seen in the Layout depiction the selected c
53. a test is defined it is added to the filter Er by clicking the Add Filter button green funnel File Edit View Sort Optimization It will then appear in the area just below the control A corresponding SQL statement describing the test will also appear in the bottom most box An existing test may be removed from this area by highlighting it then clicking the Delete Filter button blue funnel SAT Math Ge SAT Math gt 550 Multiple tests may be combined to construct ST State IN MAN VY sophisticated filtering criteria The following tools are provided to facilitate this Rev 7 14 Rapid Insiahte Veera User Manual Insert Remove Parenthesis Parentheses may be useful when combining several tests The parentheses are used to group test criteria together so they can run together instead of separately The parentheses can also be removed Select each one then use the arrow next to each parenthesis and choose the remove option And Or Statements And OF Multiple tests may be joined together by adding AND or OR between them To change one to the other select the value then click the desired button to change it Selecting the OR Otherwise by default tests are initially joined by AND Move Up Down t If there is more than one test their order can be changed using this tool Select the test and click the move up or move down arrow Delete All Filters x l This deletes all of t
54. are copied connected and configured to construct a Job in Veera JOB WORKSPACE TOOLBAR ob y b Aka HP av A toolbar is located at the top of the Job Workspace These controls provide a variety of tools and functions for use with the Job in view The individual controls on the toolbar are described below Validate Job Use this to check the job before running it Reviews the job and alerts the user to any potential issues in the job Veera highlights each issue with a yellow warning symbol above any nodes that are causing a problem Placing the mouse over the warning displays a description of the error Run Job Pause Job Use this to run or pause a job When the job is running the button toggles to pause Press the button at any point to halt the current status of the job Hide Job Status F This control hides the job progress bar Stop Job Use this button to stop a job The button becomes active red when a job is running Press it to stop the running of a job at any point Note that under some conditions a job will be waiting for an external driver to reply before it can respond to this control Rev 7 14 Rapid Insiahte Veera User Manual Delete Selected Item s Use this button to delete any items that are selected in the Job Workspace Connect Nodes Use this button to toggle on off the ability to connect nodes together Once on select the source node then the destination node A line will connect the two An arro
55. ata College Enrollment Data FA csv type is DATE this field sets the paa date formats as they will appear in Define Column Proverties SE SS To define columns you must assign names and types to the fields Confirm that the column properties are correct before finishing Veera coming from this source EE RE 1 of 20 Name Student ID Width e DECIMAL PLACES If the column Daa pe pm O Ta Dae ae Fama GEE Er g Yes No Unknown Decimal Decimal Places floating Delete Column data type is DECIMAL this field f seimi sets the n u m be r of d igits as th ey GE e S Sen S Math State Eie Ee dist a e e f 500700 Male 2 384 520 520 NH Non legacy 145 0 0 will appear in Veera coming from N sosi we e e ae NA Nariegsoy 10 0 o f 941891 Male 2 342 620 560 ME Non legacy 90 0 0 th IS SO u rce 722819 Male 2 068 530 600 ME Non legacy 50 0 0 378790 Male 2 455 710 480 NH Non legacy 75 0 0 Leer male 2 249 500 510 NH Non legacy 140 0 0 N S E RT D E LETE CO LU M N D ro ps 780531 Male 2 901 480 600 Non legacy 20 0 0 existing or adds new data columns EE ig el kee which can then be CO nfigu red Set confirm appropriate column properties XML SOURCE TYPE Veera makes use of an integrated driver to both read and write XML formatted data Users should be aware of the following conditions that may affect their use of this data type The XML driver will Read the records from any XML formatted data file Pa
56. c regression is used when the Y variable is a binary The resulting model looks to predict the likelihood of an event to take place Ordinary Least Squares OLS Regression is used when the Y variable is continuous Users may select the Logistic regression method to model continuous variables though this is not recommended The resulting model looks to predict the rate or quantity of an event r z EF Model i i File Edit View Sort Help dv as aa oo 7 24K aa Include VRE Generated Columns Column Name Use in Model Y Variable Gend Text lt Enol Checkboxes Ze lt Se ZipCode Text Model Type OLS Logistic V Use forward backward elimination i ee distance from school Integer m aAa ee m Use fast model method This option should be used when aar da ad ee the Model node is preceded by a Am a a VRE node where related category a aaeain International Applicant Integer E Model Information and best fit transform variables Variable Coef SE Y Intercept 0 0136617734661202 0 0692763678715413 0 1 We re C re ate d j Th e n th e n ew SAT Verbal 0 000811106882904078 5 71804185282233E 05 de H High School GPA 0 0815213984363614 0 00700282371500664 11 CO u m n S WI b e eva u ate d fo r Student distance from school 0 000675239473934364 7 88295089144537E 05 8 ZE R SAT Math 0 000832648076232076 7 15641082814837E 05 1 th eir statistica l
57. check boxes users may select a schema mode to further control how this node behaves e FIXED will not adapt to changes to the list of columns Discrepancies will be reported as errors e EXTENDABLE will automatically allow new data columns to appear in the output Missing columns will be reported as errors e DYNAMIC will automatically alter the columns output to match the first table schema e LOCKED will always output the original columns list Missing columns will populate with nulls Rev 7 14 Rapid Insiahte Veera User Manual EDI NODES ADDED TO JOBS EDI An EDI Node is a special form of connection It can only be created from a data source that Veera interprets being formatted as an EDI electronic data interchange file To make use of this node on such a data source right clicking on the file entry in the Connections field and selecting Add EDI Node from the menu that appears An EDI Node icon representing that connection will appear in the Job Workspace Tasks OVERVIEW Tasks are tools used from within a job to manipulate data Veera provides 25 unique tasks that can be incorporated into any job There is no limit to the number or types of tasks that can be used though there are some restrictions on their order The 25 tasks are 1 Append Tables 18 Cache 2 Merge Tables 19 Subroutine 3 Lookup Column Data 20 Input Proxy 4 Get Sample Records 21 Output Proxy 5 Filter Records 22 Reduce Variabl
58. corporate ina command or action Reorder Columns The up and down arrows move the selected column up or down in the display order These controls also adjust the order in which certain dependent activities like sorting is done Save Save and Exit el w The Save button blue disk icon saves without closing the setup window Save and Exit green check saves the completed work and closes the setup screen Sorting Options A J SI AL G The A Z option sorts the data in ascending order The Z A option sorts the data in descending order The AxZ option un sorts the data putting in its original order APPEND TABLES uu Overview Append stacks records from two or more sources to create one combined output For example if two datasets are appended one containing 5 000 records and the other containing 10 000 records the appended dataset will contain 15 000 records Rules For Appending Data Append is intended to combine datasets with the same type of data more or less using the same columns variables This however is not mandatory When column names of the data sources do not exactly match the resulting output will contain each unique column Rev 7 14 Rapid Insiahte Veera User Manual Whether columns from several sources line up can be verified by reviewing the Is in Source checkboxes if a box is checked then that source s data will appear under that column in the Append output The key
59. cting New Folder Folders and the jobs Z Demo Local Complete S S amp Licenses Activation Report they contain are ordered alphabetically Jobs BEET can be dragged and dropped between folders BS zap 4 App Lost Reports JOB DETAILS SECTION HI Data Connections E Access The Job Details section reports the properties of m dd Excel 3 E eo SQLServer the current or most recent job selected from a CRM the Workspace Jobs list Details include geg grag 71 dbo dbo demo test D Job Nam e S a TeSTINGSOL e Create Date gt Active Processes e Last Modified e Last Used e of Output Nodes e of Nodes e Connections e of Input Nodes e Notes By clicking the appropriate control this section may be hidden gt gt or viewed lt lt at any time Active Processes The Active Processes section of the Organizational Workspace displays the names and elapsed times of jobs currently running in Veera If no jobs are running this portion of the Workspace remains blank Backing Up The Workspace The content and structure of the Workspace may be backed up and restored EET to guard against catastrophic loss and corruption or to allow users of Veera as to share their content Open the File gt Database menu from the main program toolbar Veera automatically performs a backup when the program is updated 4 NEW Freshmen Retention X SQL Job Note that individual jobs may be exported and imported w
60. deling Name s ear Sample rows 10000 W i Z a rd Cleanse Operation Name Cleanse Type Column Name Cleanse Operation j Handle Missings in High School GPA Clone_High School GPA Replace when is null with Mean Handle Missings in SAT Verbal Missing To Mean Clone_SAT Verbal Replace when is null with Mean If th em od e uses cre ate d varia b es th at IN Handle Missings in SAT Math Missing To Mean Clone_SAT Math Replace when is null with Mean Handle Missings in Visited Campus Replace Clone_Visited Campus Replace when is null with 0 tu rn j were use d to cre ate sti more Handle Missings in International Applicant Replace Clone_International Applicant Replace when is null with 0 Handle Missings in LOGe SAT Math Missing To Mean LOGe SAT Math Replace when is null with Mean Va ri a b es th en mu Iti p e tra N sfo rms m ay b e Handle Missings in LOGelStudent distan Missing To Mean LOGe Student distance from school Replace when is null with Mean produced to enable this in the job Enter the value to replace Clone Columns Transform All variables participating in the modeling that weren t created at the Create Variables stage are duplicated here This is done to permit more effective replacement of missing values later in the A modeling process Duplicate fields are labeled using the prefix Clone_ Missing Values Handling Cleanse eP Transor
61. ds value FILTER RECORDS Overview Filter is used to filter records based on one or more user defined tests Rev 7 14 Rapid Insiahte Veera User Manual Defining a Test Double clicking on a column name from the list on the left selects it as the source of the data to test In the example shown State has been selected Then the type of test is chosen from the following options e In specified list e Not In specified list g SES Contains found within column File Edit View Sort Optimization GES JURA e Does Not Contain not found within column value e Starts With the specified value d aa gt e Ends With the specified value e Like matches a pattern bei State ICT MA ME HH BLW e Equals e Not Equals lt gt e Greater Than gt e Greater Than or Equal To gt e Less Than lt e Less Than or Equal To lt e Between two specified values e Is Missing no value exists e Is Not Missing a value exists e EXPRESSION offers range of DATE specific operators that rely upon the computer system clock for reference such as TODAY Next the user must enter the data value s to test for As an aid a Get Sample button is provided permitting the user to view unique values found in the column being tested Values may be selected directly from this list holding the Ctrl key allows multiple selections Creating Multiple Tests Once
62. e Input columns These are the available columns you can select to sort by There may be many columns chosen to sort by In the example State was selected using the arrow and then appears in the Sort By list From there select how it should be sorted Ascending or Descending If many columns are added to the Sort and the order needs to change use the up and down arrows in the header to move in the proper order Note The default sorting direction can be changed from the toolbar TOOLS gt OPTIONS menu DEDUP RECORDS E IL Sort Bes File Edit Sort Optimization 2 il a ri Column Name d e Sort By Column Name Sort Direction scholarship_amt Ascending gt Ascending Dedup identifies and removes duplicate records based upon criteria set up by the user There are 3 elements in the DeDup Node e Input Columns Input columns are the available columns coming from the node they were connected to You can use these columns in the DeDup By Columns window or as a selection rule e DeDup By Columns These are the column or columns that identify duplicate values In the example below duplicates are identified based on the same Student IDs You may have multiple columns that identify duplicates such as Last Name First Name and Birth date e Selection Rules These allow you to have e g DeDup Records File Edit Sort 24K 2 a Legacy
63. e able to report on the results Create Variables Clone Columns Handle Missings Calculate Probability Drop Created Columns ale Scheduling a scoring process is also possible something not available in Analytics The wizard translates the contents of the model into nodes recreating the formula creating additional variables if necessary replacing missing data with the appropriate substitute values etc Adding a Model to a Job The Modeling Wizard is accessed by right clicking on a node or connection and selecting the menu entry Wizard gt Import Scoring Model A navigation window opens allowing the desired rism modeling file to be selected Once a model file is chosen several nodes are added at that location Rev 7 14 Rapid Insiahte Veera User Manual Create Variables Transform If new variables created in Analytics also 1b Cleanse Column Data SS N eS appear in the predictive model s formula Sen ed the Modeling Wizard creates a Transform Zen Pepeoe Operation Round Operation 24 A 2x AE node to recreate them in Veera This NN SS Transform behaves just like the standard Ee RE node added by a user Contents can be See T Replace With Nul edited removed or the whole node etse er deleted If no variables created in Analytics V appear in the model s formula then this lose Clone_Intemational Applicant Clone_SAT Verbal node will not be created by the Mo
64. ees see see see see see ee ees see ee ee 67 Distributing Reports by Email 68 SEIN 68 Exporting and Importing Jobs iss ie Ee Ge Seg Ge ee ee ee ee ie 68 CO HAO aS ld EE 69 CONTRIBUTING TO THE COLLABORATIVE OOUD esse see see see see ees see see see ee ee ee ee ee ee ee ee AE ee ee ee 69 GETTING ITEMS FROM THE COLLABORATIVE CLOUD an 69 CONTRIBUTING AND READING COMMENTS ABOUT ITEMS IN THE COLLABORATIVE CLOUD 70 DELETING ITEMS FROM THE COLLABORATIVE CLOUD esse sees see see see see see ee ee ee ee ee ee ee ee ee ee ee ee Ee 70 FP UUM TNS JODS Ee EE ei EE RR Ge gauss cued anne ee Re SS E 70 APPENDIX A TASK FUNCTIONS SUMMARY cccccsccscesccsccsccccscescescees Z L Function Descriptions Multi Variable Transform Task ccccccsssececseseeeeveeeeeeeees 71 FUP UON OD SG ge SE EE EN ER EN ER 75 Date and Time Format Species eike EN Di ed ee DE ee 76 SIC lal e E 78 CONTAC SE DT OE a N EL Rev 7 14 Id Rapid Insiahte Veera User Manual ABOUT VEERA Veera Visual Engine for Enterprise Reporting and Analysis is a powerful tool that allows you to turn data into actionable knowledge Using Veera you can transform data into workflow processes create and share jobs with colleagues and simplify data and reporting needs Having the ability to merge and integrate data from any one or multiple disparate data sources allows for e Arevolutionary new way of working with data e Implementing solutions quick
65. elds may or may not be active in Selected Mother ad a j i jy Selected Yeardays Once a day response to the choice In most cases a Commence and Conclude Periode ected 7 date and time must be entered When additional days times might also are SA need to be chosen this is done by clicking the Selected Times button pecial and Periodic Special and Periodic with Selected Times To select a date or time on the screen that appears select the choice with the mouse then click the Set button IN Rapid Insight Inc Veera Scheduled Jobs aa ER SCHEDULED JOBS TAB cal File ver Job Data View Schedule Tools Window Help Select Schedule gt Scheduled Jobs from the toolbar menu to review all jobs currently scheduled This will open a new tab in the program labeled Scheduled Jobs NOTE Veera must be open for a scheduled job to run Com Cree Coe Se Status Next Run SCHEDULED JOBS DETAILS AND HISTORY Scheduled Jobs History The Detail and History buttons on the Scheduled Jobs tab open windows that provide additional information on jobs that have been run and their results when selected SENDING EMAIL NOTIFICATIONS FROM SCHEDULED JOBS Scheduled jobs may be configured to email notification of their success or failure to one or more recipients Right click on the job name listed on the Workspace Tab and select Properties from the Rev 7 14 e Rapid Insiahte Veera
66. es 6 Aggregate Records 23 R Project 7 Median of Column Data 24 Model 8 Cleanse Column Data 25 Share under NODE gt ADD TASK 9 Transform Columns menu only 10 Sort Records 11 DeDup Columns o gt 12 Find Dup Records p gt x 13 Quantile Records 14 Rename Exclude Columns Seta ter 15 Convert Column Data Type ra Ve ra ala 16 Rank Records e e 17 Transpose d w D CES e Right clicking on a task will open the Help Menu entry for that icon in a separate window SETUP TOOLBARS Tasks are configured once they are place in the Job tab s Working Area Though the setup options of each task are unidue there are some controls that are common to most These are typically found as one or more toolbars within the task s setup screen Rev 7 14 Rapid Insiahte Veera User Manual Find 33 The binoculars bring up a dialog box to search for a particular column if there are a number of entries Get Values WER ees Sample rows The Get Values control displays a list of every unique value found in the selected field An associated Sample Rows drop down selects how many rows to search through to gather the sample Parameter D Parameters i e named variables are user defined specific to each job and configured under the Edit Parameters button of the Job Toolbar The parameter button appears in association with many nodes and tools It opens a List Box allowing the user to select a pre defined parameter to in
67. es ound ee eg GE ee ed ed Ge ee ee Ged Ge GO eb Ge ke ed bg od 14 TW OT Ge TIP AA AR EE ER RE IE EE EE 14 ML SOIT RCE TYP E ea E de ee Ge ee Oo Ge EG Ge Ge ee ee seq Ge Ge Gee Ge Ge Ee 16 Jobs in the ge EE AE Ge EG Oe EE ER Ge ee GE EE 17 JOB SOVER VIENY EE N Ee N eine Ge Ee OG Ee eens os 17 HOM JOBS ARE ORGANIZE RE 17 Rev 7 14 Rapid Insiahte Veera User Manual JOB DETAILS SECTION issie se se Go GR Ee Or ok Ge ee Ge Ee DE Ee eo Ge 17 Active ProcesseS ss EE ee RE Ge Ge ER Ee oe DE ee EO ei de 17 Backing Up The WOLKE PES ee ies RE Ge ee io ee ee Si Ge Ge EG ee 17 Beie le et 18 INPUT NODE ADDED TOJOB SS EE SE ee oie ee ee ee ed ie ee ie oe N EG GE Ge NE 18 QUERY NODES ADDED TO JOBS esse se ee ee ee ee ee ee GR Ee Ee ee ER Ee Ee ee ee ee Ee ee ee ee Ee ee ee ee ee ee ee ee ee ee ee 18 COMBINE INPUTS NODES ADDED TO JOBS i s sein eer sesse ke Ee OE SG Gee Se ER DA EG ee oe De GE RO ee GR ee oi 19 EDINODE ABDED TOJOB es ed ee ie ee See N ee Ee ee ee A A EA 20 ER OE N EE EE ORE RE 20 OVERVIEW EE 20 PTOP TOOLBAR ee 20 AFPENDTABEES asses ee ie ede Ee oe ie ee ee ae ee ER ee Ge ee N oe de ee cee be ER ee Re 21 MERGE TABLES RE EE N EE 22 OO MP EOLLUMN DA FA oe versien onse BERG RE ee Ge Ge EE GR OE SR Ge GE EG ee ee Ed 24 SAMPLE RECORDS sd ese Ge OO DS ee ee SE DE ee SO ee se Ge EG Ge Gee OR ee ee DIE 24 FILTER RECORDS see ei ee ee re ee ee ee Ge ee ee ee ee 24 AGGREGATE e E RE 26 MEDIAN OF COLUMN DATA soe ies ee Ges es ni se Hoe
68. etween 2 dates Degrees DEGREES Given an angle in radians returns the corresponding angle in degrees DistanceBetween DISTANCEBETWEEN Returns a real representing the of miles between zipcode 2 zipcodes DistanceBetweenLatLon DISTANCEBETWEENLATLON Returns a real representing the of miles between lon1 lat2 lon2 2 Latitude Longitude coordinate pairs DistanceBetweenMGRS DISTANCEBETWEENMGRS Returns a integer representing the of meters mersCoord between 2 MGRS coordinates in same GZD DistanceFrom DISTANCEFROM zipcode Returns a real representing the of miles between a zipcode and a constant zip code DistanceFromLatLon DISTANCEFROMLATLON Returns a real representing the of miles between varLon1 constLat2 a variable and a constant Latitude Longitude constLon2 coordinate pair DistanceFromMGRS DISTANCEFROMMGRSI Returns a real representing the of meters mgrsCoord between a MGRS coordinate and a constant MGRS coordinate in same GZD Exp EXP Returns the exponential value of the given real expression Floor FLOOR Returns the largest integer less than or equal to the given numeric expression Greatest GREATEST expr Returns the largest value in a list of 2 or more values Hour HOUR Returns an integer that represents the hour part of a specified datetime HoursBetween HOURSBETWEEN date Returns an integer representing the of hours between 2 dates If IF trueValue falseValue Tests an expressi
69. ew Job DataView Schedule Tools Window Help SSS EE EE Eg Workspace Job Demo Local Complete Bata View Transpose Example Cv right clicking on a connection task or runable The tab will display a sample of the data records from the file currently selected Many Data View tabs Loaded Data Statistics Co Total records queried 10000 gt Obs person month sales may be open though only one can be viewed at a 1 mike jan time If the toolbar menu View gt Tabs is turned off mke and the Window menu to Tile the windows is used F several data views can be reviewed simultaneously julie feb julie mar MAIN MENU The main menu appearing at the top of the window provides options similar to those offered when the Workspace tab is selected Scheduled Jobs Tabs DESCRIPTION IN Rapid Insight Inc Veera Scheduled Jobs Ee o mm Fal File View Job DataView Schedule Tools Window Help The Scheduled Jobs tab opens when a user Workspace Scheduled Jobs selects Schedule gt Scheduled Jobs from the toolbar menu The tab will display the names of those jobs scheduled to run along with the current status next scheduled run date time last scheduled run date time and the last run result See Scheduling Jobs for a description of job scheduling Next Run A user may also use the buttons located at the bottom of the tab to perform a number of tasks These include
70. ext 237 23 213 11 198 94 182 64 174 29 140 22 90 20 88 59 69 63 48 71 32 25 9 113 5 197 4 875 0 6149 0 5269 Best Fit Square Root Square Log 10 Cube Square Log 10 Square A m Help dv Clear Related v Create Related Best Fit Transforms d Create Related Category Transforms Y Variable lt Age Related p value threshold 0 01 X Y R Excludewhen lt 0 Mean of Y ethnic_cd E Not Related NE Related Rev 7 14 Rapid Insiahte Veera User Manual Those variables in the list that are sufficiently related to the selected Y Variable will be colored green those related but not meeting the p value threshold will be colored red and those not related will be colored black Beside each variable is also listed its statistical test results and the transform providing the strongest statistical fit Output Options There are three main Variable Reduction configuration options e Keep Column Columns marked in blue will be kept if relevant and left behind if not This setting may be manually overridden to always keep checked or always discard unchecked e Create Related Best Fit Transforms Checking this option will direct Veera to create those transformed variables that were judged to be the best statistical fit e Create Related Category Transforms Checking this option will direct Veera to create binary variables from those individual categories judged to be statisticall
71. from the list of options A clean copy of the Rapid Insight E Rapid Insight Collaborative Cloud Veera Job Collaborative Cloud window will Search Vera Job Search All open To see what items of that By Contributor ND Sort by Contribution Date type are available to download Type Click on an item below to view details and or download Date Posted Contributor Times Downloaded Comments enter specific search criteria or Simple_Job S teven l atthews apid Insight Inc 07 19 2012 Steven Matthews 1 use Search All in the Search field S Thate this job delete t BE before clicking the Search button Tons of Cache Nodes i tae ED EE weng 07 19 2012 Steven Matthews A list of items their titles lt s This is a job with many Cache nodes k is very us inti Connections2 descriptions and dates posted to De eegen aie DS BEE the Collaborative Cloud will list This list may be sorted on one of EE EE several options selected from the Sort By control Rev 7 14 Rapid Insiahte Veera User Manual Double clicking on an entry will open the item s Details window In addition to information on the item itself attached files will also be listed Once the Terms and Conditions box is checked clicking the Download button on the Details page will start the process of adding the item Any attached files will also be downloaded with the user being directed to select the destination folder CONTRIB
72. hart highlighted in blue e Chart Size This governs the relative size of the graphic and how it will fit with other items in the report e Force New Section This checkbox locates a chart to a new row in the report regardless of other spacing considerations FTP GET OR PUT FILE The FTP Runable provides a connection between a Job and an FTP site Data can be downloaded from or uploaded to the site ostensibly for use in the Job This can be done using one of five selectable protocols e FTP e Secure FTP SFTP e SCP e HTTP e WebHDFS Hadoop In all cases the user must fill in the File Transfer appropriate host port and user Help information The connection can e then be tested using the TEST button to ensure everything functions properly The remote and local file information will also need to be configured to specify the file names and locations As with all Runables the Set Run Order Job Workspace Toolbar Protocol FTP WebHDFS FTP Connection Host Address ftp2 rapidinsightinc com Host Port 21 Use passive mode Anonymous C Use active mode Usemame Password control is used to determine when Upload Pol Duration minutes the Command Node is run Unlike Download most other nodes connections are EET not made from or to it Filename _D fleischer Documents DATA Data From FTP bt Ploeg Select the Download radio button Remote File ae to have the Runable automaticall
73. hat is entered here accomplishes three things e New File oF q o Names the file where the report Mal N data will be stored oo Name Sue Te Ge a HO Temp VA partial draft4 pdf 749 96 KB e Acrobat D O Names the location where the an OUTPUT _pdf pdf 19 5KB e Acrobat D 2 17 201 Oo report data file will reside and o Designates what the report type will be Supported file types include PDF HTML MHT Word Excel and Rich Text rtf e Entera Title A title for the report can be added by selecting the Title checkbox Ee and typing a name to appear in the TE header Excel Workbook C dei e Make other formatting choices affecting the main body of the report These include o Adding a timestamp to the report o Section the report by data source o Formatting the Title Header and report body Data text o Document Margins o Presentation Style Portrait or Landscape o Column and Row auto sizing and removal of empty fields Adding Data Sources to Reports For each connection made between a source of data and a Report node a tab will appear in the Report node s setup window labeled with the data node s title The order of these tabs will determine their presentation order in the report itself and can be changed by using the left and right Move Section arrows The display order is also depicted in the Layout image appearing on the right side of the setup window Opening
74. he test criteria from the filter Filtering Parameter This button appears in conjunction with most filter operators It opens a List Box allowing the user to select a parameter to incorporate in a filter Parameters i e named variables are user defined specific to each job and configured under the Edit Parameters button of the Job Toolbar AGGREGATE RECORDS is The Aggregate Records task allows the user to aggregate the data 54 Aggregate File Edit View Sort CheckAll Optimization entering it A single aggregate can ile ABOBBRETO 7 Output Columns Min Max Count Mean Sum _ Count Distinct First be produced from the entire em dataset which would produce one Gender State row of data ZipCode Student distance from school Alternately the user can choose to Aggregate By specific fields One row of aggregated data will be produced for each unique Se Enroll combination of Aggregate By Visited Campus International Applicant values LOGe SAT Math LOGe Student distance from school The following may be calculated Probability for those records matching the Rev 7 14 Rapid Insiahte Veera User Manual unidue Aggregate By combination e Min minimum value found in that field e Max maximum value found in that field e Mean average of all non null values for a numeric field e Count count of all non null values for a field e Sum sum of all non null val
75. ilable is often To open an Excel spreadsheet you must specify the spreadsheet filename dependent upon whether the drivers for that Workbook folder type are installed on the computer ODBC OLE EE DB and ADO net drivers are freely available for Sens download from many manufacturers These can Worksheet include o Access o Excel o FoxPro o Oracle o SAS o SPSS o SQL Server Rev 7 14 Rapid Insiahte Veera User Manual Text CSV UDL Vertica xBase XML O O e Select an Output Connection Type o Output Create This creates the output file or table Note that this option may not be available or functional for every Destination Type By default Veera ships with the ability to create tables in databases like Oracle and SQL Server turned off To enable check Allow Create Table in Databases option under the toolbar TOOLS gt OPTIONS menu window o Output Append Adds the data to an existing file or table rather than File Edit MM OO A AA OO Zz Sort ki ox Aar Column Name Student ID Gender High School GPA SAT Verbal SAT Math SAT Math BINS State Legacy Student distance from school Enroll Visited Campus median_age median school International Applicant Financial Aid Offered percent with college degree percent with hs degree percent older than 65 percent with kids percent poverty percent public assistance Major CD Scientific 1 234568E 004
76. ill be integers from 1 to of files being appended The column name may be changed by entering a new one in the Name field To change the values used double click on one and type in a new value If any value contains a character the Text radio button should be Type Data Sources Source ID 1 Enrollment 1 Bud 2 selected a MERGE TABLES ae File Edit Sort aa EIDEN Col WI 1 Enrollment 2 ease oer Output Column Source Column Student ID 2 Aid Name Gender e percent withh percent withh 1 Enrollment Se High School GPA Overview SAT Verbal SC percent older t percent oldert 1 Enrollment Enrollment Enrollment SAT Math SAT Math BINS State scholarship_amt percent with ki percent with ki loan_amt t t yes percent poverty percent poverty percent public percent public Enrollment Major CD Major CD Enrollment scholarship a scholarship a 2 Aid Merge is used to combine records from two or more related data sources together making one record from lan zm lean am 2 Ad S temationa i work study a work study a 2 Aid several Each data source entering the gees Major major lo 2 Merge is represented as a separate box in the working area with the name of the source at the top and the list of its column names below Major Descript 3 major lookup cs e lt 4 mm Source Table Flag Columns Table Create Flag Column N Name Source 1 Flag 1 Enro
77. ing Note from the menu that appears A text box opens where the content of the note is entered To save the note the user simply clicks the se mouse outside of the text box There is no cap on the Bx TE number of floating notes that can be added to a job ooregate Like other nodes floating notes may be repositioned cloned copied pasted and deleted Their contents may be edited by double clicking on the node or by right clicking and selecting Edit from the menu Rev 7 14 ee Rapid Insiahte Veera User Manual Floating notes may not be attached to other nodes however The contents of a floating note are always visible and appear against a selectable background color This background color may be changed by right clicking on the note and selecting Set Color from the menu Floating note defaults background color font color type and size are not editable Testing Jobs There are several tools available to evaluate a job during and following its construction VALIDATE A JOB Use the Validate Job tool from the Job Workspace Toolbar to check the job before running Reviews the job and alerts the user to any potential issues in the job Veera highlights each issue with a caution symbol above any nodes that are causing a problem PREVIEW DATA The user can right click on any node except Connections report or FTP to select Preview Data from the menu to begin This runs a sample set of records through the job
78. ing a different type Dashboard Dial CHART STYLES LIST Chart styles are managed from the Chart Styles List window This window can be accessed from either the chart node itself or from the TOOLS gt CHART STYLES menu All chart styles appearing in this list may be selected for renaming copying editing or deletion The name of a new chart style is assigned from this window before proceeding into the Chart Style designer window CHART STYLE EDITOR Chart styles are created and edited in the Chart Styles Editor window This window can be accessed from either the chart node itself en Oh OM ON Sample Chart or from the Chart Styles list The presentation e options available on this window are primarily 7 Des Orar Te the same regardless of the chart type bar borat column pie etc being styled Attributes Te include titles boarders chart legends data labels color palettes and display fonts A 3 D r Chart Style Editor Default 0 200 Font Family Sze Style Color Background Chat Tee Arial lin B Z U Bak White rendering of charts all except Radar is also eg Si LE EE available Each chart type also has one or C more attributes tabs unique to its type wa SHARING CHART STYLES Chart Styles may be developed and exported from one user then imported and used by another To export a chart style as a vcst file right click on its entry in the Chart Styles
79. ion is enabled or disabled in the job based on the program s S lt Properties for Demo global Optimization setting e Box is empty Optimization is disabled and cannot be used by any node in the job Nome DES e Box is checked Optimization is enabled for use Path DEMO by nodes in the job subject to their specific settings SR JONS E Use Optimization Rev 7 14 Rapid Insiahte Veera User Manual Optimization Node Property Each Input Node may be individually configured by the user to permit or deny the use of its data server to optimize filtering and or sorting functions when the job is run These setting only have an effect when Optimization is also enabled in the job s properties E Input Aid e Enable default Disable Filter Optimization Fle Ede Sent Optimization Help ZE e BA OO A 2 Ein Disable Filter Optimization e Enable default Disable Sort Optimization ES did EE Additionally each Filter Node in a job may be individually VI Student_D configured to permit or deny optimizing its specific filtering task EE Each Sort Node may also be individually configured to permit or 7 loan_amt G deny optimizing its specific sorting task In both cases these WI work study am setting only have an effect when Optimization is also enabled at both the Job and Input Node levels Connection dbo Financial Aid data ve CLONING COPYING AND PASTING NODES Cl
80. is runs the job using the first 1 000 records from any inputs and shows the results with the new variable as the last variable Note If the variable being used to create the binned variable is a categorical variable like state users can retrieve the unique values by clicking the get sample button in the upper right corner Users can then choose the in operator hold down the shift or control keys and choose any values to be placed into each bin S Transform s x Multi Variable Formula File Edit Sort ZEIT The contents of a new column can be Del Marco Formda BEE derived from a single solvable formula ae ee EI Enroll H using one or more existing columns SAT Math Major CD lication Date First choose any columns to be used as Function Definition y Visited Campus variables in the formula Veera assigns ee BS E GN Resut Type Integer v Missings e E Treat Missings in Formula as Zeros Variable Name e Distance From Campus Update Cancel Delete Transform Operations Name Transform Column Summary SAT Combined Formula SAT Verbal SAT Math Real AE Distance From Campus Formula ZipCode Integer DISTANCEFROM A 038 4 m gt Update transform Rapid Insiahte Veera User Manual formula tags to each of the chosen colu
81. ithout having to a ne 4 App Lost Reports resort to backing up and restoring the whole program content Rev 7 14 Rapid Insiahte Veera User Manual JOB TAB The Job Tab in Veera is where users can build edit and view a job Each tab is divided into five sections Connections Tasks Reports Runables and the Job Workspace Connections Jobs need data in order to work Connections point to sources of data In order for a job to use a set of data a connection pointing to that data must appear in the Connections section of the Job tab This can be done in one of two ways e Anewconnection may be created while on the Job tab see Creating a Data Connection or e An existing connection may be imported into the job s Connections section DH Select Existing T Mew Connection a Select Tables To use an existing connection choose Select Existing from the menu that appears when e Right click anywhere in the job s Connections section e Clicking the down arrow to the right of the z Connections TE Connections section label Once a data connection appears in a job s Connections section specific file and table connection references may be added to it see Selecting Tables for a Data Connection To use an existing connection choose Select Tables from the menu that appears when e Right click anywhere in the job s Connections section e Clicking the Connections section labe
82. jor CD scholarship a When a column is selected it appears in bold type within the data source table It also appears in the Output Column list on the right side of the screen along with its source Deleting a column from the Output Column list removes the column from the Merge output This is done by right clicking the entry and selecting delete or selecting the entry and pushing the DEL key i loan_amt work study a Major percent with ki Output Columns Table Source Column percent with h percent older t percent with ki percent poverty percent public Major_CD scholarship_a_ loan_amt work study a Major Descript 1 1 1 1 1 1 2 2 2 3 Name Enrollment Enrollment Enrollment Enrollment Enrollment Enrollment Aid Aid Aid major lookup cs p The column may be renamed when it appears in the output Enter the new name in the Output Column field Rev 7 14 Rapid Insiahte Veera User Manual Creating a Source ID Column Source Table Hag Columns Users have the option to create one new variable for ra every data source participating in the merge These Create Flag Column N eliane store a value to indicate whether that source Source 1 Flag 1 Enrollment contributed data to the record Placing a check in the Source 2 Flag 2 Ad Create box beside the source creates the variable Source 3 Flag 3 major lookup csv The indicator values will be O or
83. ken EES Dees Dein Type New Date lype Pn Student ID Real followed by their Original Data Type Ges Ce These are read only fields scholarship_amt Real loan_amt Real The New Data Type has the following rr ger Real options e Text e Integer e Date e Real e Time e Boolean e DateTime Designating the Format becomes possible if selecting a new data type of TEXT DATE TIME or DATETIME Format options are e Scientific e Date e SSN with and without dashes e Time e Phone various styles e DateTime e Currency e Integer e Number e Fixed 1 15 This allots the number of e Percent characters after a decimal point DATE TIME and DATE TIME provide a wide range of formatting options for column values All of the available formats appear in the drop down box After you make your choices select the green checkbox to save and exit from the node Multi Select and Bulk Convert If the same convert action needs to be performed on several co located columns select a range of New Data Type fields using the mouse and the SHIFT key Then select the new data type for the topmost entry in the highlighted list An additional option to convert all fields to text can be found under the window s Edit menu RANKING RECORDS EE He Fi File Sort 24K 2x a This task creates a new column and assigns a tae rank to each record based on ranking criteria Sg i SAT Math BINS Input Columns contain all of the columns coming dl Rank By
84. ken when using the output of this task NOTE Format appears only under Node gt Add Report CROSS TAB REPORT A x 4 Y f M e Cross Tab reports create summaries counts means sums across two or more E x CrossTab File Edit Sort SEL N WE t Min Max Count Mean Sum Count Distinct First Column Name Cross Tab Rows 1 Column Name Format Sort Direction fields They generate See summary data in a grid where the rows and columns represent groups of data Cross Tab Columns Column Name Sort Direction Values Cross Tab Values Colum Label Format The user selects what the Cross Tab rows and columns will be Clicking the ellipse button under the Values section of a Cross Tab Column will open the Get Unique Values utility This is where unique values that organize and label the columns are defined Identifying these values can be done automatically by clicking the Get Values button by typing values in directly or a combination of both methods Sum Cel Sum Cdl wo EI E E CT CT sales Sales Currency Get Values The Cross Tab values are populated using the checkboxes on the Ee Es left hand side Cross Tab Values may also include Row and Column Sum and Percentage or Cell Percentages by checking the relevant boxes Cross Tab must output to a Report node in order for the headers to be seen The column headers that appear
85. l as all of the underlying functionality connection names location node specifics notes output names amp locations The larger the job the longer it may take to generate yee the print preview Veera will alert you to it s progress in amp P 00 BB M cose the Generating Previews box Job Demo Local Complete ane pe u mmm em N Taret ae Once all pages have cached the Print preview window will appear The first page will contain a screen shot of the job itself Subsequent pages will contain every detail of the job Users can page through by hitting the up or down arrow in the upper right portion Rev 7 14 Rapid Insiahte Veera User Manual APPENDIX A TASK FUNCTIONS SUMMARY Function Descriptions Multi Variable Transform Task Binning Multi Variable Formula String Functions Date Time Assign Variables _ Enter a Formula example A B C IF ACos ASin ATan Function Definition ATn2 Retums the absolute positive value Ceiling expression Char Charindex P1 Numeric expression Contains Cos of Result Type v lt Missings e gt Abs ABS Returns the absolute positive value of the given numeric expression ACos ACOS Returns the angle in radians whose cosine is the given real expression ASin ASIN Returns the angle in radians whose sine is the given real expression ATan ATAN Returns the angle in radians whose tangent is the given real e
86. l dropdown INPUT NODES ADDED TO JOBS Input Node is a generic term used to refer to a data connection added or about to be added to a job It appears as an ADD option when right clicking on any table in the Connections section or under the NODE menu When used the selected table will be added to the current job Double clicking on an Input Node allows the user to review the data structure column names and data types of the connection Check boxes are also available that select or deselect specific columns from appearing at the node s output Changes made to the data source structure since the last time the window was opened will be represented removals will appear in red new entries in blue Saving and closing the window will incorporate the changes into the node QUERY NODES ADDED TO JOBS A Query Node is a special form of connection It can only be created from a database table connection by right clicking on the table entry in the Connections field and p selecting Add Query Node from the menu that appears A SELECT FROM DEMO bol Financial Aid daal Query Node icon representing that connection will appear in the Job Workspace File Optimization Connection Financial Aid Data Rev 7 14 Rapid Insiahte Veera User Manual Running SQL Scripts in Veera Using a Query Node The Query Node setup window is different from that of other connections Instead of displaying a list of available variables it presents a query
87. les that are not available at this location in the job the formula will be displayed in red indicating a problem Note that this Transform behaves just like the standard node added by a user Contents can be edited removed or the whole node deleted The scoring results are stored in a new field called Probability Update transform Drop Created Columns Rename This node removes the cloned and created columns produced as part of the model import Only the new Probability column is retained Rev 7 14 Rapid Insiahte Veera User Manual JOBS IN VEERA S IR Rapid insight Veera eegen ab Dame Ge ON chaea J obs Over VI CW op File Edit View Job Connection Node Data Vuen Schedule Tools Window Help x Workspace Job Demo Complete Jobs are projects created by users that Sen Be sl jb y D EI de EA S P IN dy gather data from one or more data 4 Eesreeetgg DR ken sources Data Connections manipulate dbo Fanci Ad Sas Type oet that data with various tools known as ee BR i i Tasks or Reports format that data using 5 oes Aries er on OP 2 Z Si al a t D Eers Data Convet_2 Merge NH Only Transform Report several reporting styles known as EIST Bex Os i j Reports and produce one or more lie outputs in the form of files or reports id e T dh each known as a Runable ve Sk giit By Students Top 10 TE slak DES a Ready ae sl Creating Jobs Creating
88. letion by testing whether there are data records entering the node or not Meeting the criteria selected for the test may stop just the part of the job that the node is a part of or the whole job E Stop when NO records C Stop when ANY records Stop entire job unchecked stop just this output DYNAMIC FILE NAMING File Name Parameter Several Runables allow for the incorporation of one or more parameters into the file name Parameters i e named variables are user defined specific to each job and configured under the Edit Parameters button of the Job Toolbar Rev 7 14 Rapid Insiahte Veera User Manual To use enter a file name in the field provided Then place the cursor at that position in the file name where the parameter value should appear Finally click the parameter icon to view and select from the available list Once done the file name will appear containing the name of the parameter selected When the job is run and the file is created the parameter name is replaced with parameter s value File Name Timestamp S Several Runables allow for the incorporation of current date time information into the name of the resulting file To use enter a file name in the field provided Then place the cursor at that position in the file name where the date time content should appear Finally click the Timestamp icon beside the file name field to view and select from the list of available date time format opti
89. llment Source 2 Flag 2 Aid Source 3 Flag 3 major lookup csv MAJOR CD Major Description Rev 7 14 Rapid Insiahte Veera User Manual Joining Sources The first step in a Merge is to join the data sources together Though the mechanics of joining are straightforward the right approach might not always be so clear The user must consider how these data sets are related and what is the desired outcome Identifying which field s will make a record unique in the output is often a good start Dragging one or more columns from one data source and dropping them onto the matching columns of another data source forms joins between those columns A line is drawn between the columns to represent the join In the example shown there are 2 joins between three data sources Join Types There are four Merge Join types e Only matching records from both sources inner join An output record is created only if records are found in both sources with matching data in the joining column By default the initial join is always of this type It is depicted by a line with no arrowheads Only matching records from both sources All records from both sources Delete All records from Enrollment and matching records from Aid All records from Aid and matching records from Enrollrnent e All records from data source 1 and matching records from data source 2 left join One output rec
90. located On a machine using the Windows 7 OS this would be C Program Files x86 Rapid Insight Inc Veera VeeraWorkstation exe Rev 7 14 Rapid Insiahte Veera User Manual Next would be the actual command to run a job runjob followed by the name of the job and its organizational structure within Veera placed in quotes i e Testing New Freshmen Retention A fully assembled command would read something like this C Program Files x86 Rapid Insight Inc Veera VeeraWorkstation exe runjob Testing New Freshmen Retention Scheduling Jobs Veera permits users to schedule jobs to be run at later dates and times Jobs may be scheduled as single events or as reoccurring actions Scheduled Jobs SCHEDULE EDITOR To configure a new event or edit an Schedule Editor existing one for the current job open the Schedule menu on the main Job Demo Local Complete Type Special and Periodic with Selected Times v Special Type Second Tuesday e program toolbar and select Job The Status Enabled Period None Schedule Viewer will open to display eee 00M v Eie 2 the existing schedule Click the Edit Te Schedule button to open the Specialand Periodic with Selected Deen mms Schedule Editor window a ce on Fixed Dale amp Time Once Anytime The styles of scheduling available are selected from the Type dropdown Gw See Tines list Once a type is selected other fi
91. ly based on existing architecture e Getting the right data at the right time to make the right decisions e Streamlining and automating reporting e Easily finding and tracking errors in current reporting processes e Trusting results In short Veera makes meaningful data highly accessible whenever you need to ask questions of your data This Document Though Veera is designed to be intuitive users may not always agree This User Manual is intended to provide in depth descriptions of all aspects of the program s function and features Hardware Requirements Systems intending to host Veera must meet the following hardware requirements Minimum System Requirements e Windows Vista SP2 or later or Windows Server 2008 SP2 or later e NET Framework 4 0 and its requirements e 2 GHz 32 bit x86 or 64 bit x64 processor e 1GB of system memory e 20 MB available hard drive space e 32 MB of graphics memory o Internet access Recommended System Requirements e Windows 7 x64 or later e NET Framework 4 0 and its requirements e 2 8 GHz 64 bit x64 processor e 4 GB of system memory e 1 GB available hard drive space e 512 MB of graphics memory e Internet access Rev 7 14 Rapid Insiahte Veera User Manual Additional Resources For more specialized information try one of these other Veera documentation resources e Installation Guide provides step by step instructions for installing the program e Getting Started Guide a
92. ly formatted under the Format column Passing Data Out of an Output Table An Output Table can serve as an intermediate save point in a process That is to say connections can be made coming from an Output Table and passing data on to another node continuing the process OUTPUT REPORT ii Overview An Output Report Runable provides users with the opportunity to immediately report on the results of a job Unlike the Table Runable a single Report Runable will accept data from multiple sources combining them into a single multi section report Report File Edit Header Chat Fiter Full Fle Name CATemp TODAY mit T e d Timestamp Report Defaut Settings Put each source in separate report section Oeer se mags ate set to defauk semng a AFGE Fort Family Sre Style Color Background The Arial ia B Z U Bach Header Arial ii BZ U Black Black va sp E H Let 025m Rgt 05n Top 0235n e Remove Empty Rows Remove Empty Columns Potet Bottom 0 251 Landscape Layout Destra Repon Use D ferent Color for Negatins Numbers Rapid C SIS e Negative Data Color Whe EN Rev 7 14 Rapid Insiahte Veera User Manual Configuring an Output Report Once the Output Table setup window is opened perform the following actions on the Header tab e Enter a Full File Name By clicking on the Full File Name ellipse a New File dialog box opens W
93. m h n File Edit Sort 2 AN da Student ID The Modeling file often contains Binning Mutti Variable Formula String Functions Date Time instructions on how to handle values Assign Variables Enter a Fomula example A B P GES ar hi fB Cone SAT Verbal ial 0 514170397088818 EO missing from the dataset Settings within Reie Ree HE D Clone_ Visited Campus C 0 0149185720935733 LAND the Transform nodes will replace missing Boden ee fe 0498012570421409 ES i S G LOGelStudent distance from school F 11 4649551007261 entries with zeros or with the column s En o we 5 ee f t e mean value when appropriate This later EE e E s g elSAT Math Function Definition Cleanse function is available only in the Clone Figh School GPA oo model importation process and is not Gone _Misted Campus BEE Clone Intemational Applicant EE Missings E Treat Missings in Fomula as Zeros otherwise editable Variable Name j e Probability Update Cancel Delete Calculate Probability Transform Transform Operations Name Transform Column Summary Probability Formula Clone_High School GPA Real Score 59 27382610 4 m D The Modeling Wizard always creates a Transform node to incorporate the probability model formula into the Veera job If the formula uses variab
94. method Veera supports for browsing for the available Oracle database servers is TNS In that case the local names can be seen in the drop list for the of the connection window e Using the Oracle Net Configuration or comparable tool generate a tnsnames ora file and placing it in the correct folder If the user gets the error Could not find file TNS_ADMIN tnsnames ora when using the Databases drop down list this means that the computer needs help locating the tnsnames ora file e Confirm that the TNS ADMIN environment variable found under CONTROL PANEL gt SYSTEM gt ADVANCED SYSTEM SETTINGS gt ENVIRONMENT VARIABLES points to the tnsnames ora file folder The IT department may need configure this Once all the required information has been filled out the Test and Ok buttons become enabled The user may test the connection confirming the information is valid or save the contents and exit the window SAS SOURCE TYPE To download the driver for SAS navigate to http www sas com apps demosdownloads oledbproviders PROD 9 1 3 sysdep jsp packagelD 000 366 SPSS SOURCE TYPE To download the driver for SPSS navigate to http www spss com drivers clientSPSS htm SQL SERVER SOURCE TYPE Configuring a SQL Server based data source requires specifying a server location connection credentials database name and table schema TEXT SOURCE TYPE If a text type data connection is saved the user will then need
95. mn will appeared in the list of Cleanse actions Note that the Get Values button is disabled when multiple columns are selected and that all columns selected must be of the same data type text integer real etc Rev 7 14 Rapid Insiahte Veera User Manual TRANSFORM COLUMNS Overview The Transform Node allows you to create new columns from existing columns Once a Transform Node is connected to another node it shows a list of all of the fields that exist in that node There are several options for different types of variables that can be created Along the top of the Transform Window there are four tabs Binning Multi Variable Formula String Functions Date Time Binning N X The binning option allows users to EP Transforms dree S File Edit Sort create bins from another variable To 5J ZI RA uv do this first select the column that Student ID Binning Muti Variable Formula Sting Functions Date Time as High School GPA dBn Hi er EI bs Mssingor 24 Kd A at BF users want to create the bins with on EE E ca EE SES SAT Math High School GPA z sl 3 an sv 1 079 the left side Next name the first SAT Math BINS 112 in category To do that simply type in Sudert dance rom school ES 1222 cs Visite Campus W m 1 Hi ol i a name for that bin where it says First medan sy 2 Hedum hen gh Schoo GPA gt 2and lt 3 E E median_schoo ne
96. mns In the example shown two columns are chosen to work with SAT Verbal and SAT Math A variable of A is assigned to SAT Verbal and B is assigned to SAT Math In the formula box any formula can be entered In the example A B is typed This adds the two fields Next choose a Result Type from the drop down box Then decide how to treat missing values both in the formula and in the results Finally name the new variable and click Create IF Function The IF function returns one value if a condition specified evaluates to TRUE and another value if that condition evaluates to FALSE The syntax for the IF function is if P1 P2 P3 where e P1 isthe condition to test Binning Multi Variable Formula String Functions Date Time e P2 is the value to return if the Assign Variables Enter a Fonda example ABO IF expression is true e P3 is the value to return if the expression is false Result Type Missings As an example IF A gt 50 high low would return the value of high if the field represented by A was greater than 50 and low if it is not greater than 50 Note in this case since the output values are text single quotes are put on high and low and the result type would need to be set to text Functions Operations Clicking the f button displays a list of functions Clicking a function shows the definition and parameter requirements of
97. n a job is managed through its run order much like data outputs FTP nodes etc Integer 0 Seconds Integer 10 Rev 7 14 Rapid Insiahte Veera User Manual TDE OUTPUT ADD IN Ale The TDE Output is an Add In node It allows Veera to store data in a proprietary file format called a Tableau Data Extract This format facilitates the use of the resulting Add In TDE Output Node file as a data source for the wide Add In Parameters range of visualization programs Name Data Type Value offered by Tableau Software Inc Output File Full File Name C Users macmillan Desktop Scored Apps Configuration of the TDE Output is relatively simple Users only need to specify the tde file name and destination path Like other output nodes Veera nodes may feed data into it through a single connection but it will not permit connections to be made out of it TABLEAU ONLINE APPEND TO EXTRACT NODE Te The Tableau Online Append to Extract Node add in node allows users the ability to update a data source automatically to Tableau Online In order for this node to be used there must already be an existing Add In Tableau Online Append to Extract Node data source in your Tableau Online site Add In Parameters This output will append new records to an Name Data Type Value existing data source If you would like to server URL Text https online tableausoftware com update overwrite the existing data source Username Text
98. n2 a Dial Title value ranges These may be specified either in the chart style or in the node s setup window Rev 7 14 Rapid Insiahte Veera User Manual Scatter Chart A Scatter chart resembles a Line chart in that it is displayed as a grid with points representing data entries Unlike a Line chart there are no lines connecting these points The horizontal X axis is labeled with data found in the column selected to be the X Axis Column Note that each data row must contain a unique value in this column otherwise an error will result Sample Scatter Chart The number of points appearing in a Scatter chart is determined by the number of Added Pairs The Y axis of a Line chart grid is scaled automatically using all the values found in these same columns Note that the Selected Data Columns must be numeric Chart Styles How a specific chart looks is dependent upon the chart style i Chart Styles List applied to it Chart styles are selected for use with a specific chart 3 E using the Chart Style drop down control within a chart node s ede ns setup window All user created chart styles will be available for Bar Chart End of Year Reports selection from this list as well as a Default style Chart styles Pie Chart Customer Ratios aren t necessarily associated with a single chart or chart type SE E SEH Rather a single chart style could be applied to a host of charts EE a each us
99. names that are considered duplicates OUANTILE RECORDS SI JE The Ouantile Node creates a new quantile variable that indicates a record s relative location compared to the other records values in that column The quantile is created by ranking the data based on the chosen field and then splitting into N equal groups To create a quantile choose the variable that you want to base the quantiles on choose the quantile type and name the variable or leave it as the default name For example a decile creates 10 groups It creates entries based on a GPA variable so a record with a decile value of 9 means that 90 percent of the GPA values in the data fall below the value for that record Another option is to create quartiles which rank the data and split the records into 4 groups In this case if a record is in the AT quartile that record is 45 Ouantile source Merge_2 higher than of the other records higher than 75 If a File Edit Sort 2 kt aa record is in the second quartile that record is higher than 25 of the other records Below is a list of all of the default quantile options e Quartile 4 e Quintile 5 e Nonile 9 Intemational Applicant Financial Aid Offered m D il 10 percent with college degree ecile percent with hs degree percent older than 65 percent with kids nercent noverty of Quantiles Decile 10 Sort Order Ascending e Duo decile 12 e Vingtile 20 e Percentile 100
100. nthOfYear MONTHOFYEAR Returns a string that represents the month part of a specified date January February etc MonthsBetween MONTHSBETWEEN date Returns an integer representing the of months between 2 dates MonthsBetween MONTHSBETWEEN date 1 Returns an integer representing the absolute of months between 2 dates Now NOW Returns the current date time Nulllf NULLIF expr Returns a null if two expression are equivalent Num NUM Returns numeric data converted from character data PadLeft PADLEFT Hen Returns a string padded on the left with specified character to the specified length PadRight PADRIGHT len Returns a string padded on the right with specified character to the specified length PI PI Returns the constant value of PI 3 14 Power POWER pow Returns the value of the given expression to the specified power Quarter QUARTER Returns an integer representing the Quarter specified date falls between Radians RADIANS _ Returns radians when a numeric expression in degrees is entered Random RANDOM Returns a random number between 0 0 and 1 0 Replace REPLACE find new Replaces all occurrences of the first string expression with the second string expression Remove Left REMOVELEFT cnt Removes specified number of characters from left end of string expression RemoveRight REMOVERIGHT cnt Removes specified number of characters from right end of string expression
101. odified D BH Scored Apps Text File D Scored Apps csv Apr 6 2015 5 52 PM default Jon MacMillan Apr 6 2015 6 04 PM e Project the name of the project that the data source was originally published to This is also available in the data source tab in Tableau Online Hit tr tableau Projects Workbooks Views Data Sources 1 So v 0 selected t Name Connection type Connects to Live Last extract Project Owner Modified p D Scored Apps Text File Scored Apps csv Apr 6 2015 5 52 PM default Jon MacMillan Apr 6 2015 6 04 PM e Original File The original source of the data extract For this node to work the original data source has to be acsv file The value entered into the node should contain the file extension csv If you are unsure of the original file this is also available in the data source tab in Tableau Online under the Connects to field it tableau Projects Workbooks Views Data Sources 1 v 0 selected t Name Connection type Connects to Live Last extract Project Owner Modified D 6 Scored Apps Text File E E 2015 5 52PM default Jon MacMillan Apr 6 2015 6 04 PM TABLEAU ONLINE REFRESH EXTRACT NODE EER The Tableau Online Refresh Extract Node add in node allows users the ability to update a data source automatically to Tableau Online In order for this node to be used there must already be an existing data source in your Tableau Online site It is important to note that this output
102. on result returns one value if TRUE and another value if FALSE IsNull ISNULL Tests if an expression result is null returns the replacement value result if it is not null otherwise a replacement value Is Null IS NULL Tests if an expression result is null evaluates to Boolean Least LEAST expr Returns the smallest value in a list of 2 or more values Left LEET len Returns the left part of a string the specified number of characters in length Len LEN Returns the number of characters of the given string excluding trailing blanks Log LOG Returns the natural logarithm of the given real expression Log10 LOG10 Returns the base 10 logarithm of the given real expression Lower LOWER Returns a character expression after converting uppercase character data to lowercase LTrim LTRIM _ Returns a character expression after removing leading blanks MatchesRegEx MATCHESREGEX regex Tests if an expression result matches a regular expression See TRANSFORM for additional info MetersToMiles METERSTOMILES Returns the real numbers of miles equivalent to the specified number of meters Rev 7 14 Rapid Insiahte Veera User Manual Minute MINUTE Returns an integer that represents the hour part of a specified datetime MinutesBetween MINUTESBETWEEN date Returns an integer representing the of minutes between 2 dates Month MONTH Returns an integer that represents the month part of a specified date 1 12 Mo
103. oning Nodes Cloning one or more nodes effectively copies the selected icons their interconnections and any connections providing data to them and pastes them immediately into another part of the same job Once those nodes to be cloned have been selected by individual Ctrl left clicks or by boxing in the nodes the user may either e Right click on part of the selection and select Clone from the menu that appears or e Ctrl left mouse on part of the selection and drag the cloned nodes to their new location Copying and Pasting Nodes Copying and pasting one or more selected nodes and their connections operates much like cloning nodes but with two important differences the user has more control over where the new nodes are placed and copied nodes may be pasted into other jobs Once the nodes to be copied have been chosen by individual Ctrl left clicks or by boxing in the nodes the user right clicks on part of the selection and clicks Copy from the menu that appears The user picks where in the same job or in another job the nodes are to be pasted before right clicking and selecting Paste from the pop up menu Notating Jobs Floating Notes THIS IS A FLOATING NOTE In addition to the yellow sticky notes that may be attached to nodes using the Edit Notes tool users can imbed floating notes into a job To create a floating note users must right click on any open space in the job and select Create Float
104. ons JOB NAME Field The Job Name drop down is use to SW identify which job this TT Bac SUBROUTINE will ey ef gr F interact with Clicking the control Append Create Variables Handle Missings Calculate Probability Output Proxy will open a view of wei the WORKSPACE gt JOBS area from which Input Proxy 2 E the job can be selected Output JOB PARAMETERS Fields The selected job may or may not have parameters configured ar Subroutine Node If it does the value of the parameter may be changed when the job is run by entering content in the New Value field File Help Job Name Subroutine TARGET z Job Parameters INPUT Field Name DataType Value New Value STATE Text NH RI This section is where the associations between the streams of data entering the SUBROUTINE node and the INPUT PROXY nodes found in the called job are established Each INPUT PROXY node will be represented by a tab The user selects using the Input field which stream of data entering the SUBROUTINE node will be uniquely associated with which INPUT PROXY When a selection is made the grid below will list and compare using check boxes the variables found in EETL N Cen Weeer EE Input 2009 Enrollment Reguired lsin Output Columns Data Type be Bo Source J J Student ID Integer Gender Text State Text W ZipCode Ted M Student distance from school Intege
105. ons Once done the file name will appear containing code designating the format selected When the job is run and a file using a timestamp is created the formatting code is replaced with entries corresponding to the date and or time at the file s creation Custom Nodes Add Ins Add Ins provide users with the opportunity to create their own custom nodes Developing Add Ins requires a strong working knowledge of a NET compatible programming language such as CH There are no restrictions Add Ins are incorporated into Veera as supplemental DLL files stored in the C ProgramData Rapid Insight Inc Veera AddlIns folder of the program A sample Add in DLL is included with Veera to serve as an example to would be node developers Add In nodes won t appear along with the other standard icons on a Job Tab Rather Add Ins are accessed through the NODE gt ADD ADD IN menu Selecting an entry from this menu will place the corresponding 32x32 pixel node image in the Job Workspace For further details on developing integrating and using Add In nodes contact Rapid Insight Customer Support SLEEP ADD IN Sleep is an Add In Node that allows user defined delays to be incorporated into jobs File Add In Sleep Node Add In Parameters Users enter the length of the delay in minutes and ore Typo seconds in the setup window Like other special nodes Sleep does not connect to other nodes directly Rather it s participation i
106. ord is created for each data source 1 record paired with each matching record from data source 2 It is depicted by a line with an arrowhead pointing to data source 2 e All records from data source 2 and matching records from data source 1 right join One output record is created for each data source 2 record paired with each matching record from data source 1 It is depicted by a line with an arrowhead pointing to data source 1 e All records from both sources full outer join Every unique combination of records from both sources will PROGRAM1 ANS POS ANSC EGUINE ANSC PREVET aa 7 e s ess el percent poverty percent public assistance Masor CD Major Description al 254092718 0 701053128 473 g appear in the output This is comparable to a union of both left and right joins To change the Join Type right click on the line joining the two data sources The line turns blue and the Join Type dialog box appears Select the type from the list Selecting the Outputs Once all the joins are defined the user must specify which columns from each source will appear in the output of the Merge There are two options for selecting columns e Select the asterisk at the top of the data source This brings Output Column ALL columns of that source over to the output percent with h percent older t e Individually double click on each data source column percent poverty percent public Ma
107. oviding data to the OUTPUT PROXY in the target job were actually part of the base job at the point where the SUBROUTINE node is located INPUT PROXY INPUT PROXY is a type of data connection node It s the point where Input Proxy data is received from the SUBROUTINE node that originally caused File Eet Sort the job to run b Pislz xia av e Multiple INPUT PROXY nodes may be added to a single job DateTime e Jobs with INPUT PROXY nodes may also include other data Hoas connections eg e This node may provide data to other nodes but cannot Ee ees direetivrecewedata International Applicant Integer y i Legacy Integer e An INPUT PROXY may be configured either by converting an Major Description Text INPUT node or manually Major_CD Integer SAT Math Integer e Note that regardless of setup method any columns SAT Verbal B bee configured in the INPUT PROXY will be considered required State Text Student distance from school Integer Manually Configuring an Input Proxy Node Student ID Integer Visited Campus Integer Double clicking on an INPUT PROXY node placed in a job opens its setup window Here column names and data types may be directly typed into the columns provided 15 columns Replacing an Input Node with an Input Proxy Node Once an INPUT node is place in a job it may be converted into an INPUT PROXY by right clicking on the icon and selecting Replace with Input Proxy Node from the menu that appears
108. pe are installed on the computer Drivers OLE DB ODBC ADO net or native drivers are freely available for download from the corresponding manufacturer ACCESS SOURCE TYPE Configuring an Access based data source doesn t require a server location or connection credentials However unlike other connection types it does require specifying the file name at this stage Also note that there are two Access file types to choose from the Office 2007 version accdb and the legacy JET version mdb The correct file type must be selected for the intended data source to appear as an option D Microsoft OLE DB Provider for Access D Define a new connection to a data source or done an existing one New Existing Connection Name Data Source 2 ca 2 sed Sr D ora GEE ze O Sy ay Database Connection To connect to Access select a database file You may need to provide a user name and password Usemame Admin Password Full File Name Rev 7 14 Rapid Insiahte Veera User Manual EXCEL SOURCE TYPE Create New Connection Configuring an Excel based data source requires specifying the file EE ST folder location When the specific data table is being identified EE Eege the user will specify the workbook file name and choose between SES the worksheets within the workbook In this way each sheet can ER FI ERA serve as a separate data source Microsoft OLE DB Provider for Exel AC SE z
109. r High School GPA Real SAT Verbal Integer SAT Math Integer Rapid Insiahte Veera User Manual both the INPUT PROXY and the SUBROUTINE nodes Excess columns coming from the SUBROUTINE are acceptable but all fields found in the INPUT PROXY of the called job are required and must have a match in the SUBROUTINE REDUCE VARIABLES 14 The Reduce Variables node is intended to facilitate the creation of a predictive modeling dataset for use in Veera s sister product Analytics It looks to identify those columns that statistically relate to a user selected Y variable and output them Y Variable Field The Y Variable represents the one item that a predictive model is intended to predict It can be any linear real or integer or binary 1 or 0 variable present in the list on the left hand side of the setup screen The arrow button to the left of the Y Variable field is clicked to loading the desired highlighted column Setting Test Options There is one main Variable Reduction configuration option affecting testing P Value threshold This determines a minimum level on how confidence the program has in the variable s relatedness The larger the p value the less confidence there is in the specific variable The default is 0 01 t Variable Reduction sort Options OO I no 2 a 2X aa Type Keep Integer Integer Text Text Text Do not call flag Email Domain Extension Email Domain Group ethnic_cd Forbes
110. r og rd EER job will run As with all Runables the Set Run Order Job Workspace Toolbar control is used to determine when the other job is run Unlike all other nodes except Command FTP and Compress no connections are made from or to it CALL ANOTHER JOB FOR EACH INPUT E 7 Call Another Job For Each Input vd File Job Name Like the standard Call Job node the Call Job for Each node runs Jobs CALL JOB ITERATIVE another Veera job that has been selected using its Job Name wg a Sec drop down list Unlike its sister node the Call Job for Each is STATE Ted RI C designed to run the target job multiple times each time ates oe providing a different value for one or more of the target job s E parameters This is done by connecting a data source to the node also unlike Call Job that serves as a reference file The user matches fields found in this reference file to parameters in the job being called The job called run by the Call Job for Each node will be run once for each record found in the reference file Each of these records will pass its values for the parameters its fields were matched up with potentially creating a unique result each time STOP JOB NR t Stop Job The Stop Job runable is unlike any other node in that it can be used either as an intermediate step within a job or as one of the job s endpoints It provides a means of halting a job before comp
111. re several options on how to profile the data They File Edit Sort 24 IE N Rit High School GPA D j 4 i SAT Math BINS State i Legacy E Min Value Student distance from school Visited Campus e Max Value PC median school e Range Max Min EE inancia er M e a n Im e Number of observations e Number of missing values e Number of unigue values All data unable to be calculated due to variable type will be left blank in the output Rev 7 14 Rapid Insiahte Veera User Manual Profile must output to a Report node in order for the headers to be used otherwise they will appear as a row of data NOTE Regardless of their original column types all data Loaded Data Statistics Column Court 9 emerging from this node are ae oo 24 Ad 2 lede Uer db H Obs Coll Col2 Col3 Cold Col5 Col6 Col7 Col8 Col9 CO nve rted to type Text ei 1 Column Type Min Max Range Mean ofobservations of missing values of unique values i Gender Text null null null null 4498 Because of this care should be High School GPA Real 1 4727 3727 30768 4498 0 Gi State Text null null null null 4498 0 taken when using the output Fi Enroll Integer 0 1 2 0 1245 4498 0 of this task CHART DATA TE Chart Data gp h File Edit Sort Help 2J ZJ 4x a dy Chart Type Chart Title Dial Title Overview Chat Style Custom Dil Ser
112. rect before proceeding Field Delimiter Format File supported data types are shown below Comma 5 Semicolon 5 Vertical Bar ot Text 15 1 z Col_2 Real 5 16 Tab Colon Other Col 3 integer 6 21 Col_4 DateTime 8 27 First Row Contains Field Names Column Count 20 format file fmt with the desired parameters To start the process the user clicks on the IMPORT button In the example shown a Student ID Gender High School GPA SAT Verbal SAT Math State Legacy Student distance from school 696603 Male 2 027 790 400 Non leg 80 500700 Male 2 384 520 520 NH Non leg 145 d 504174 Male 2 909 650 480 NH Non leg 10 I 941891 Male 2 342 620 560 ME Non leg 90 722819 Male 2 068 530 600 ME Non leg 50 378790 Male 2 455 710 480 NH Non leg 75 608665 Male 2 249 500 510 NH Non leg 140 780531 Male 2 901 480 600 Non leg 20 150941 Male 2 029 550 550 MA Non leg 30 2 REITEQ Malo Q25AG AAN 74N NH Ninntlan AR w Le lt Back Next gt Finish Cancel Select field delimiter and if first row contains the column names format file has been selected Its contents appear in the sample window The user uses the Field 1 Field 2 Field 3 and Field 4 entries to help Veera interpret the layout of the format file This in turn defines the four columns in the data file Starting Column Column Name Length and Type should all be defined The sample format file displayed shows the valid choices for
113. ring in a Column chart is determined by the number of designated Selected Data Columns The Y axis of a Line chart grid is scaled automatically using all the values found in these same columns Note that the Selected Data Columns must be numeric Radar Chart A Radar chart is displayed as a series of concentric rings The outermost ring is labeled with data found in the column selected to be the X Axis Label Column Note that each data row must contain a unique value in this column otherwise an error will result The number of areas appearing in a Radar chart is determined by the number of designated Selected Data Columns A minimum of three is required with this chart type The radius of each ring is scaled automatically using all the values found in these same columns Note that the Selected Data Columns must be numeric Dial Chart A dial chart resembles an old style automotive gas guage The number of pointers appearing in the dial is determined by the number of designated Selected Data Columns Note that the Selected Data Columns must be numeric and that each data row must contain a unique value in this column otherwise an error will result The Dial Chart is unique in that areas of the dial may be colored differently to denote the importance of certain Sample Line Chart Sample Column HUN RespondentID_Count Age Mean TITLE FROM TASK WE LengthOfResidence Meant E NumberOfAdultsOnRecord_Mea
114. rse incoming data records using schema imbedded in the XML file Parse incoming data records using schema contained in a co located XSD XML Schema Definitions file if it is named the same as the XML file Ignore any attribute information incorporated into data records Such records should be parsed by the user outside of Veera into a more conventional format prior to use Write files which imbed any needed schema information into file itself Rev 7 14 Rapid Insiahte Veera User Manual Jobs in the Workspace JOBS OVERVIEW Jobs are projects created by users that gather data from one or more data sources Data Connections manipulate that data with various tools known as Tasks format that data using several reporting styles known as Reports and produce one or more outputs in the form of files or reports each known as a Runable The Jobs section of the Workspace tab is where all jobs created or imported into in Veera are managed From here users can import export copy rename organize schedule and delete jobs For an explanation on how to build a new job or edit an existing one see the section JOBS IN VEERA pr Y Rapid Insight Inc Vi gd File View Job Data View Schedule Tools Window Help HOW JOBS ARE ORGANIZED Jobs can be easily organized by placing them in Fw folders and sub folders Folders are created by a CRM Reports right clicking anywhere in the Jobs section and e sigh sele
115. s no connections are made from or to it COMPRESS OR UNCOMPRESS FILES J Compression Node The Compress Uncompress Runable is another unique Job tool When placed in a job this Create Compressed File Uncompress File node permits the compressing or Compressed File Name C Temp MyZippedFiles zip uncompressing of files using the ZIP format As with all Runables the Set Run Order Job Workspace Toolbar control is used to determine when the Command Node is run Compress Files Folder DADATA File test csv vV Use File Pattem Unlike all other nodes except FTP Call Job and Command no connections are made from or to it File Name Pattem csv Uncompress Files Select the Uncompress File radio button to configure the Runable to automatically uncompress the selected ZIP file Compressed File Name into the specified folder Uncompress To Compress Files Select the Create Compressed File radio button to configure the Runable to select a single file File or set of files matching a pattern File Name Pattern and compress them into a single ZIP file Compressed File Name Rev 7 14 Rapid Insiahte Veera User Manual CALL ANOTHER JOB i D B Call Another Job File The Call Job Runable is another unigue Job tool This node passes new Job Name parameters to and runs another Veera job selected from the Job Ti Reet Renon ee Name drop down list Note that only the SAVED version of a selected e
116. t is listed under Name did tobleou EEN Projects Workbooks Views Data Sources 1 v 0 selected t Name Connection type Connects to Live Last extract Project Owner Modified D BE Scored Apps _ eee Text File D Scored Apps csv Apr 6 2015 5 52 PM default Jon MacMillan Apr 6 2015 6 04 PM Project the name of the project that the data source was originally published to This is also available in the data source tab in Tableau Online Hit ktableou EEN Projects Workbooks Views Data Sources 1 lt v 0 selected t Name Connection type Connects to Live Last extract Project Owner Modified D D Scored Apps Text File DN Scored Apps csv Apr 6 2015 5 52PM or Macmillan Apr 6 2015 6 04 PM Original File The original source of the data extract For this node to work the original data source has to be a csv file The value entered into the node should contain the file extension csv If you are unsure of the original file this is also available in the data source tab in Tableau Online under the Connects to field Rev 7 14 Rapid Insiahte Veera User Manual H tr tableau Projects Workbooks Views Data Sources 1 El E t Name Connection type Connects to Live Last extract Project Owner Modified D Scored Apps Text File EN 5 20 5 5 52PM default Jon MacMillan Apr 6 2015 6 04 PM Job Workspace JOB WORKSPACE OVERVIEW This is where Connection Task Report and Runable icons called nodes
117. t nodes o Format Column Data o Cross Tab Report o Frequency Report o GroupBy Report o Profile Report CONFIGURE NODES TO DEFINE A PROCESS Each node is configured differently Please refer to the section of this document describing the specific node for guidance ENABLING OPTIMIZATION TO IMPROVE A PROCESS Optimization is a data processing option that takes advantage of the filtering and sorting capabilities of data source host servers if any exist when a job is run Optimization Program Option The Enable In Database Optimizations control under the TOOLS gt OPTIONS menu determines the global default setting of the option Only Jobs whose Use Optimization properties are set to use the program value are affected Enabled is the default setting Optimization Job Property The Use Optimization property under the JOB gt PROPERTIES menu determines the Optimization use status for the current Job The control has three states selected by the user E aJ Options General SMTP information Distribution Lists Display Reset All Window Sizes to Defaults Reset Report Default Settings Max 1K Rows in RAM per Node 20 Default Sample Size 100000 Type Guess Sample Size 1000 Default Units Inches z Default Sort Direction for Numeric Columns Ascending Descending Default Sort Direction for Non Numeric Columns e Box is blue default Optimizat
118. ten this ep OD om PE mmm hd zem dl person l l dataset to just one record per person an aggregate i La iz Co ia SC node will need to be used Aggregate By the person d S fe 7 ike null null 29 column and select the First real value of each of the ree 40 null null other columns null 50 nul null nul 60 Rev 7 14 Rapid Insiahte Veera User Manual CACHE RECORDS Cache is used to shorten processing time when running complex jobs with large data sources When inserted in a job all the data processed prior to and passing through a cache is saved If the running job accesses data from this same point more than once this saved data are used rather than processing through the earlier nodes again A Cache may be configured to retain data between job runs When data is retained between job runs the icon appears with a yellow cylinder superimposed in the upper right corner Data will be retained in the Cache until the preset time expires or the Flush Cache Now button is clicked Splitting and Recombining Process Paths cache Records File A process that splits at a Cache may be recombined later in the same job using a node such as Merge or Append This is a behavior unique to Cache data only for duration of job run Cache splitting a process at any other node and attempting to MEME aos recombine it further on will produce an error or unpredictable results Discard cache after 2 hours
119. the connection location e For Text file data connections the properties often need to be defined see TEXT SOURCE TYPE e If the desired table does not appear in the Files Table list right click in the space and click Add Table By Name to manually enter the file table name into the list not available for Excel or Text Data Connections Source Types e Select Tables Connection Demo Data Files of type Text Files bt asc csv tab X Files acquisition response csv College Enrollment Data FA_WM csv College Enrollment Data FA WM original csv junk csv scored applicants csv Spring 2008 Enrollment PS AS Student_Enroll_S Selected Files 2006 Enrolled Student ID list csv 2007 enrolled sophomores csv 2007 Enrolled Student ID list csv acquisition response demo data Book1 csv A College Enrollment Data FA csv X College Enrollment Data csv x College Enrollment Data_LIMIT X 4 Connections are automatically grouped by data source type Data source types Veera can support include e Access e PostgreSQL e DB2 e SAP HANA e DSN ODBC Connections e SAS e Excel e SPSS e FoxPro e SQL Server e MySQL e Text CSV e Oracle e UDL e OtherDBMS e Vertica e OtherFile e xBase e Paradox e XML Data Source l br Gi br Microsoft ADO NET Provider for SQL Server Which data source types are available is often dependent upon whether the drivers or providers for that ty
120. the function The function can either be manually entered into the formula box or double clicked to automatically appear in the formula box MATCHESREGEX FUNCTION MatchesRegEx is a function that takes a text column and returned a 1 when the text string matches the desired regular expression RegEx In effect MatchesRegEx acts as a universal IS function although users must develop the testing expression Fortunately searching the Internet for regex provides a wealth of examples For example e This RegEx will only match a valid social security number i e it won t match 000 00 0000 000 O 6 d 2 7 0 6 d 7 012 00 d d 3 0000 d 4 e This RegEx will match currency with or without cents and optional sign M S d d 2 e This RegEx will match positive integer d Boolean Operations Users can create Boolean true false or 0 1 variables Choose the columns to work with to assign variable tags Type an expression and choose the output type of either Boolean which results in a true or a false output or choose Binary which results in O or 1 output Rev 7 14 Rapid Insiahte Veera User Manual Formula Parameter P This button appears above the formula field It opens a List Box allowing the user to incorporate one or more parameters into a formula Parameters i e named variables are user defined specific to each job and configured under the Edit Parameters button of the Job Toolbar
121. ther e Selecting the Job gt Export option from the main program menu e Right clicking on the job from the Workspace tab and select Export from the menu e Drag and drop the job from its location in the Jobs section of the Workspace tab to the desired location on the computer Jobs will be saved as files with the Veera Job File type vjf To import a job the new job will appear in the Jobs section of the Workspace tab e Right click in the Workspace gt Jobs section and select Import Job and select the vjf file to be imported or e Select Job gt Import Job from the main toolbar menu and select the vjf file to be imported or Rev 7 14 EE Rapid Insiahte Veera User Manual e Drag and drop the vjf from its location on the computer into the desired folder of the Jobs section of the Workspace tab Imported jobs often need to be reconnected to a data source in the new environment Either e Create connections and select files tables whose names match those in the job or e Remove the job s current connections and use existing connections to replace them Collaborative Cloud Rapid Insight hosts a free forum for users to share and trade copies of their Veera work with one another the Collaborative Cloud Currently four types of content may be contributed to and copied from the Collaborative Cloud jobs transforms chart styles and add ins This forum is accessed from within zez Contribute to Rapid Insight
122. to create references to the specific text files that will serve as data sources If the text file selected does not have an X beside the file name the properties need to be defined NOTE typically the defaults that appear on the following three windows will be acceptable and no changes will need to be made Click the Properties button associated with the file to start the process File Properties Tab The first tab of the File Properties window defines the file s general data formatting These include Select File Format Deco Scho and Stk ee To load data you must first select the file format Confirm that the file properties are correct before proceeding File Properties Q Demo Data College Enrollment Data FA csv D E LI M ITE D or F X E D W DTH Row Delimiter CRKLP v File type Default X Delimited Characters such as comma or tab separate each field Text qualifier Double Quote Sample Size 20 Fixed Width Fields have a required length padded with spaces if needed Determines how the data will be era S e p a rate d i n t O C O u m n S Student ID Gender High School GPA SAT Verbal SAT Math State Legacy Student distance from school Enroll Visited Campus mer y 696603 Male 2 027 790 400 Non legacy 80 0 0 52 10 7 1 15800 0 254092718 0 701053128 0 430555924 0 655907715 0 254092 500700 Male 2 384 520 520 NH Non legacy 145 0 0 58 12 1 1 10400 0 005397312 0 9034
123. ues julie la Transpose File Edit Sort Help TAEAE dv Transpose By Include Transpose By in output As a simple example take a dataset containing three columns salespersons names person sales months month and the number of sales made that month sales The dataset contains several records per person each one reflecting a unque month and its sales figures Suppose it was preferable to have just one record per person It would then be necessary to create a new column for each unique month Jan Feb Mar and store that month s sales number underneath it Transpose Columns gl Transpose By Values Zeng Get Transpose i To do this the column month is selected to be Column Name Transposed By and the data in column sales is SES selected to populate the new monthly columns that will be created EE Ves Clicking the Values button opens the Get Values utility where the ah S 4 2 Au aa unique values are defined Identifying these values can be done cb automatically by clicking the Get Values button by typing values in Move Up directly or a combination of both methods The resulting records still contain an unchanged person column But in place of the original month and sales columns are three new columns that capture the transposed data 3 Values sales jan sales feb sales mar To flat
124. ues for a numeric field e Count Distinct count of the distinct of values for a field only one per aggregate e First the first non null value encountered in that field e StdDev calculates the standard deviation of the numeric field In the example shown there is only one Aggregate By variable Gender and three aggregates selected indicated by the checkmarks placed in the corresponding boxes If Gender contains two values Male and Female the output from the Aggregate Node would consist of two rows and three new output columns Probability Mean Probability_ Sum and Student ID Distinct MEDIAN OF COLUMN DATA 4 s07 S502 Median creates a special aggregate of the source data A column placed in the Median Columns list will be used to create a new variable that displays the median value of that column using all incoming records The output data will consist only of these new variables Columns placed in the Median By Columns list Bi estan Red will also apear in the output Together these columns determine how many records appear in AJ Zz ox A A the output In effect one data record will be Column Name output for each unique combination of values Student ID found in the columns listed in this section Ha seke ea SAT Math BINS In the example shown the two SAT scores are State being aggregated to find their median values Student distance from school Median By Columns
125. up to and through the node where the preview was requested This allows users to evaluate the results of their work at any point in the process The size of the sample set can be edited manually and the default sample may be changed under the TOOLS OPTIONS GENERAL menu Running Jobs RUN JOB TOOLBAR CONTROL gt we Run This Output Only This control is used to run or pause the job currently in view When the job EE is running the button toggles to all pause Press the button at any point to Disconnect halt the current status of the job All available data records are used and all Rename Runables not currently disabled will be populated sege Disable RUN TO THIS OUTPUT ONLY Peien Dais Open Node A user may right click on any Runable node to select Run This Output Only from the menu This runs the job but only through the nodes necessary to provide data to the selected output View Data DISABLE Runables may be individually disabled to keep them from participating in any running of their job Right click on any Runable node and select Disable from the menu Nodes that have been disabled will appear bordered in red RUNNING JOBS FROM THE COMMAND LINE Veera jobs may be run using a command executed from the Command Line Prompt or the RUN function under the Windows Start menu The command itself is comprised of two parts The first is the file path where the Veera program file VeeraWorkstation exe is
126. v Regex may DDR semble ANDRE DDR_sample_test de DDR also be used to specify groups of files to match when DDR sample testxls DDR 1 wildcards alone won t suffice As an example F Create Source ID Column Name Ml n bs Cl xls S will match all Excel Ge Regex C ae atch a an Create File Modified Column Schema Mode Locked Fixed worksheets in workbooks that start with Cl are i Column Name Data Type followed by 2 characters and have a file extension Bill To Customer Code Text b u H Bill To Customer Name Text th at sta rts with xls Bill To Customer Pricing Group Name Text SO NO Integer Invoice NO Text SO Line Close YYYYMMDD Integer Prod L3 Code Text Model Category Code Text Item Full Name Text Sales Qty Real Checking the Create Source ID Column option box and entering a name will add a new column to the incoming data The name of the source file for each record will appear in the field LS IS IS IS SG Checking either the Create File Created Column and or Create File Modified Column option boxes will add new columns to the incoming data They will be filled with the relevant file information for that data row Defining the Schema in the Combine Inputs Node The schema of the first matching table will be used to define the data layout the Combine Input node presents to a job In addition to opting in or out of certain fields using the individual column
127. w variable High Category Next define the definition ees then High School GPA gt 3 146 eegene lee EE ek for that bin percent er ede 1494 percent older than 65 percent with kids Sample rows 5000 v For example perhaps users have a field Vo PE Major_CD Melte containing SAT Math scores and want oor RE R mg pr as Transform ions to define low medium and high eee eem er re e bins In that case name the first SAT Combined Formula SAT Verbal SAT Math Real AB category low Then define that category as SAT Math lt 500 Kies ee Once defined click the validate button Then name and define the next category Perhaps a user wants to name the next category as medium and define it as SAT Math gt 500 and SAT Math lt 600 Click validate again and define the next category Once all categories are defined type the name of the new variable where it says New Variable Name Finally click the create variable button This new Transform now appears at the bottom of the window where it says Transform Operations The Transform can be edited at any time by clicking it making any changes and then clicking the update button A good way to test whether the transform was created correctly without having to run the entire job is to save and exit the Transform Node then right click the Transform Node and choose preview data By default th
128. whead indicates data flow Set Run Order Use this button in cases where there are multiple Runable outputs and the order of those outputs to run is important to specify The order may be specified in one of two ways once this button is clicked The first is to click all visible Runable nodes in the order they should be completed The second is to arrange the Runables within the Rank Order List table Show Hide Grid Use this button to show or hide the grid in the Job Workspace By default the grid is hidden To show the grid press the button When selected the grid pattern appears in the Job Workspace This is OFF by default Snap Moved Nodes to Grid Use this button to force new or dragged nodes to fall onto the grid This is ON by default Align All Nodes to Grid Use this button to move all existing nodes onto the grid This button is only functional when the Snapped Moved Nodes to Grid is off when nodes are dropped onto the Job Workspace Grow Workspace Area Use this button to expand the workspace area navigated using scroll bars Edit Notes Select a specific node then click this button to add a note to that node A yellow note icon will appear in the corner of the node once saved To add a node to the entire job be sure that no node is selected click into any clear space of the job before clicking on the note button To read the note that is created place the mouse pointer above a node s note icon Rev 7 14
129. window The node will be tied to a database connection and it will have a default query if it was created from a table connection The user may edit this script using the syntax for the version of the SQL scripting language native to the database server being accessed In addition to SQL scripting the Query Node can make use of user defined functions and stored procedures hosted on a database server as long as the entire query expression returns a result set i e something that looks like a table COMBINE INPUTS NODES ADDED TO JOBS A Combine Inputs node is a special data connection that appends the records of several co located data files together and makes them available as if they were a single source Once configured it is integrated and used in jobs like any other Input node Right click on a file based Connection entry in the gt Combine Inputs EXCEL ON MY DESK Connections field and select Add Combine Inputs Node from the menu that appears to add one toa job Double click on the node to configure File Edit Sort aa oOo Z A pa OD 2 4 a Connection EXCEL ON MY DESK Table Name Pattem testxds Select the files to be combined by entering some All Tables Matching Tables i 2015_Renewals_wOwners xisx wOw a DDR_sample_test xs DDR common portion of their names Wildcard EE org itera ony characters may be needed to achieve this such DDR soe OR as College Enrollment Data FA cs
130. xpression ATn2 ATN2 y x Returns the angle in radians whose tangent is the quotient Y X of given real expressions Ceiling CEILING Returns the smallest integer greater than or equal to the given numeric expression Char CHAR A string function that converts an int ASCII code to a character Charlndex CHARINDEX string Returns the starting position of the specified expression in a character string Returns 1 if not found Contains CONTAINS string Returns 1 if the specified expression is in the character string otherwise returns O Cos COS Returns the trigonometric cosine of the given angle in radians in the given expression Cot COT Returns the trigonometric cotangent of the specified angle in radians in the given real expression Date DATE Converts a string to a date DateStr DATESTR Convert a date to a string DateStr DATESTR di Format a date as a string Day DAY Returns an integer representing the day date part of the specified date 1 31 DayOfWeek DAYOFWEEK Returns a string representing the day date part of the specified date Sunday Monday etc DayOfWeekN DAYOFWEEKN Returns an integer representing the day date part of the specified date 1 7 DayOfYear DAYOFYEAR Returns an integer representing the day date part of Rev 7 14 Rapid Insiahte Veera User Manual the specified date 1 366 DaysBetween DAYSBETWEEN date Returns an integer representing the of days b
131. y Folder pub upload Pe download a specified file from the File Data On the FTP csv D el Use regular expression FTP site In this way any Data Connections pointing to an existing copy of that file could be assured to provide the latest copy of the dataset to the Job in which the FTP Runable appears FTP Upload Similarly selecting the Upload radio button directs the Runable to copy the specified data file to the FTP site Rev 7 14 Rapid Insiahte Veera User Manual COMMAND EXECUTE EXTERNAL ENTITY The Command Runable is another unique Job ES CommandNodeWindow tool When placed in a job this node opens runs the file or program selected in the File Name field If a file is selected it opens File the file in the program associated with it If the File Name program or file uses conditional arguments as part of its execution these can be entered in ee the Arguments field As with all Runables the Set Run Order Job Workspace Toolbar control is used to determine when the Command Node is run E Wait For Exit If Wait for Exit is checked the job will pause indefinitely until the external program that was opened is closed or until the number of seconds entered in the Wait Timeout field have passed In the latter case the external program will remain open unless the Kill Process on timeout box is checked Unlike all other nodes except FTP Call Job and Compres
132. y relevant View Relationships Chart Selecting a variable from the list will graphically display its relationship to the Y Variable R PROJECT E R Project The R Project node provides a Zeen means of incorporating scripts Parameter Name Type Set Selecting Variable X Variable Categorical from the popular open source Y Variable Numeric Variable Variables Selected Varablets statistical language R into Veera Pe esas Vee coe Ee Loan_Balance jobs The node initially offers Leen Max several pre programmed scripts to pick from though this list may be supplemented by the user R Script Template Run Sen input lt read table InFile header TRUE sep check names FALSE The R Project screen IS result lt aov input Loan_Balance input null data input e output lt capture output summarylresulf comprised of several sections cat outputfile OutFile sep r n append FALSE The R Scripts dropdown lists the available scripts to pick from By editing the RScripts config file located in the program folder users may add new R scripts modify existing ones or delete some altogether Once an R script is selected the input parameters required by the script along with their data types are listed in the Parameter Name field Users then select each listed parameter in turn and designate which of the available data columns will be used to satisfy its requirements The output of the R

Veera User Manual - Rapid Insight Inc.

Contents

Download Pdf Manuals

Related Search

Related Contents