Profiler Object:Order of Operations - Revision history

Admin at 21:16, 19 December 2016

2016-12-19T21:16:43Z

← Older revision		Revision as of 21:16, 19 December 2016
Line 19:		Line 19:
	</pre>		</pre>

	'''4. Call the SetLicenseString function to set the ~~license string~~. This was supplied by your Melissa Data Representative.'''		'''4. Call the SetLicenseString function to set the License Key. This was supplied by your Melissa Data Representative.'''
	<pre>		<pre>
	CALL SetLicenseString WITH LicenseString		CALL SetLicenseString WITH LicenseString

Admin at 00:12, 3 March 2015

2015-03-03T00:12:18Z

← Older revision		Revision as of 00:12, 3 March 2015
Line 1:		Line 1:
	~~[[Profiler Object:Reference\|← Profiler Object Reference]]~~		{{ProfilerIntroductionNav}}

	{~~\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"~~
	~~! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''Profiler Object Navigation'''~~
	\|-
	~~\| style="padding-right:220px;"\|~~
	\|-
	~~\|[[Profiler Object:Introduction\|Introduction]]~~
	\|-
	~~\|[[Profiler Object:System Requirements\|System Requirements]]~~
	\|-
	~~\|[[Profiler Object:Licensing\|Licensing]]~~
	\|-
	~~\|[[Profiler Object:Order of Operations\|Order of Operations]]~~
	\|}

Admin at 00:00, 3 March 2015

2015-03-03T00:00:22Z

@@ Line 46: / Line 46: @@
 </pre>
-'''6. Call the InitilializeDataFiles function to connect the Profiler Object to its supporting data file.'''
+'''6. These setting are optional.'''
 <pre>
 CALL InitializeDataFiles RETURNING Result
@@ Line 57: / Line 65: @@
      Print ErrorString
    END IF
 </pre>

Admin at 18:47, 30 January 2015

2015-01-30T18:47:46Z

← Older revision		Revision as of 18:47, 30 January 2015
Line 44:		Line 44:
	CALL SetRightFielderAnalysis WITH RightfielderAnalysisValue		CALL SetRightFielderAnalysis WITH RightfielderAnalysisValue
	CALL SetDataAggregation WITH DataAggregationValue		CALL SetDataAggregation WITH DataAggregationValue
	~~CALL SetCountGeneration WITH CountGenerationValue~~
	</pre>		</pre>

Admin at 01:40, 16 January 2015

2015-01-16T01:40:07Z

← Older revision		Revision as of 01:40, 16 January 2015
Line 7:		Line 7:
	\|-		\|-
	\|[[Profiler Object:Introduction\|Introduction]]		\|[[Profiler Object:Introduction\|Introduction]]
			\|-
			\|[[Profiler Object:System Requirements\|System Requirements]]
	\|-		\|-
	\|[[Profiler Object:Licensing\|Licensing]]		\|[[Profiler Object:Licensing\|Licensing]]

Admin: Created page with "← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:..."

2014-12-30T21:42:12Z

Created page with "← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:..."

New page

[[Profiler Object:Reference|← Profiler Object Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Profiler Object:Introduction|Introduction]]
|-
|[[Profiler Object:Licensing|Licensing]]
|-
|[[Profiler Object:Order of Operations|Order of Operations]]
|}

{{CustomTOC}}

'''1. Create an instance of the Profiler object.'''
<pre>
Create profiler as New Instance of mdProfiler
</pre>

'''2. Set path to the profiler data files.'''
<pre>
CALL SetPathToProfilerDataFiles WITH DataPath
</pre>

'''3. Call the SetFilename function to set the ouput file.'''
<pre>
CALL SetFileName WITH OutputFile
</pre>

'''4. Call the SetLicenseString function to set the license string. This was supplied by your Melissa Data Representative.'''
<pre>
CALL SetLicenseString WITH LicenseString
</pre>

'''5. Configure the profiler object by setting these functions. These are not mandatory.'''
<pre>
CALL SetSortAnalysis WITH SortAnalysisValue
CALL SetMatchUpAnalysis WITH MatchUpAnalysisValue
CALL SetRightFielderAnalysis WITH RightfielderAnalysisValue
CALL SetDataAggregation WITH DataAggregationValue
CALL SetCountGeneration WITH CountGenerationValue
</pre>

'''6. Call the InitilializeDataFiles function to connect the Profiler Object to its supporting data file.'''
<pre>
CALL InitializeDataFiles RETURNING Result
IF Result IS 0 THEN
CALL GetBuildNumber Returning BuildNumber
CALL GetDatabaseDate Returning DBExpireDate
CALL GetLicenseExpirationDate Returning LicenseExpireDate
ELSE
CALL GetInitializeErrorString Returing ErrorString
Print ErrorString
END IF
</pre>

'''7. These setting are optional.'''
<pre>
CALL SetUserName WITH UserNameString
CALL SetTableName WITH TableNameString
CALL SetJobName WITH JobNameString
CALL SetJobDescription WITH JobDescriptionString
</pre>

'''8. Add the columns to the table mentioned above.'''
<pre>
CALL AddColumn WITH ColumnNameString, ColumnType, DataType
</pre>

'''9. Configure the Column by setting the following functions. These are not mandatory.'''
<pre>
CALL SetCustomPattern WITH ColumnName, RegularExpression RETURNING Int
CALL SetValueRange WITH ColumnName, FromString, ToString RETURNING Int
CALL SetDefaultValue WITH ColumnName, ValueString RETURNING Int
CALL SetColumnSize WITH ColumnName, SizeValue
CALL SetColumnPrecision WITH ColumnName, PrecisionValue
CALL SetColumnScale WITH ColumnName, ScaleValue
</pre>

'''10. Initiate profiling by calling StartProfiling function.'''
<pre>
CALL StartProfiling
</pre>

'''11. Loop through the input data file lines and set the column values.'''
<pre>
WHILE ReadingInputLines
FOREACH Column column in InputLine
CALL SetColumn WITH column.Name, column.Value
CALL AddRecord RETURNING ResultCodesString
CALL GetResults WITH column.Name RETURNING ResultCodes
END LOOP
</pre>

'''12. CALL ProfileData function to do profiling for data aggregations.'''
<pre>
CALL ProfileData
</pre>

'''13. CALL the list of required functions to get the profiled values. These functions have been categorized into three different sections: table, column, and iterator get funtions.'''

For example:
<pre>
CALL GetColumnMostPopularCount WITH ColumnName RETURNING Int
CALL GetTableRecordCount RETURNING Int
</pre>

[[Category:Profiler Object]]