Oracle Enterprise Data Quality – About Profilers

Oracle Enterprise Data Quality – About Profiler:

·          The profilers are intended purely to analyze data

·          They are used to quickly understand the data

·          They are used to help find the issues in provided data

·          Profilers  do not 'check' data for business rules

·          Profilers  do not have output filters like ‘valid’ or ‘invalid’ records

The following are some of the different Profilers:

1.     Quickstats Profiler: It is used to analyze overall data i.e. analyze high-level completeness, duplication, and value frequency across many attributes, and highlights possible issues.  Input as ‘any’ data type

2.     Character Profiler: it is used to analyze a number of attributes and counts of the instances of each character. Input as ‘strings’ data type only

3.     Contained Attributes Profiler: it is used to analyze records to find pairs of attributes where one attribute value commonly contains another. Input as ‘any’ data type

4.     Data Types Profiler: it is used to analyze attribute values for their data type e.g String, Number or Date - and assesses data type consistency.  Input as ‘any’ data type

5.     Date Profiler: it is used to analyze a Date attribute for date distribution by day of week, day of month, day of year, month and year.  Input as ‘Date’ data type only

6.  Equal Attributes Profiler:  it is used to analyze records to find pairs of attributes that commonly have the same values.  Input as ‘any’ data type

7.     Frequency Profiler: it is used to analyze value frequency across many attributes.  Input as ‘any’ data type

8.     Length Profiler:  it is used to analyze a number of attributes and measures the length of values by number of characters.  Input as ‘any’ data type

9.     Max/Min Profiler: it is used to find minimum and maximum values e.g:  longest, shortest, lowest and highest.  Input as ‘any’ data type

10.  Number Profiler:  it is used to analyze a Number attribute for number distribution across user-defined bands.  Input as ‘Number data type only

11.  Patterns Profiler: it is used to analyze character patterns, and pattern frequency, across many attributes.  Input as ‘any’ data type

12.  Record Completeness Profiler:  it is used to analyze records for their completeness across many attributes.  Input as ‘any’ data type

13.  Record Duplication Profiler:  it is used to analyze records for duplicates across many attributes.  Input as ‘any’ data type

                 14. RegEx Patterns Profiler:  it is used to analyze a number of attributes for values 
                      that match a list of regular expressions.

Siebel dedicated Client – Host Name

The following post will explain to resolve the following error and normally this will come when we try to open dedicated client:

Error message:   “Requested Server could not be found” or  “Your requested host ‘server name’ could not be resolved by DNS Server”

Solution: Modify the parameter in CFG file:

Under [Siebel] section

a). EnableFQDN = FLASE (by default its set to TRUE, so it will pick the computer name and display in     browser as target address.  If set to FALSE, it will display localhost in browser as target address)

b). Internet explorer > Tools > Internet options > connections tab > LAN settings > Bypass proxy server for local addresses set to TRUE.

FQDN: Fully Qualified Domain Name

Siebel Tips

Siebel Tips of Data Visibilities:

Tip 1:

"Generate Reporting Relationships" button on click:

1. Records will be created in S_PARTY_RPT_REL table when new record is inserted in S_POSTN.

2. Records will be created in S_PARTY_RPT_REL table when click on "Generate Reporting Relationships" button in Position administration view.

Tip 2:

Pick Applet- display all records for a user who does not have -All- visibility?

Visibility will be applied to Pick and Association Applets when the Popup Visibility is set.

When the Popup Visibility is set to FALSE, no visibility is applied to Pick and Association Applets.

For example:

a). The ‘Popup Visibility’ for ‘Contact’ Business Component is set to FALSE. Hence, any Pick Applet or Association Applet based on the ‘Contact’ Business Component will display all the Contact records irrespective of whether the user has visibility to ‘All’ contacts or not.

when the Popup Visibility of a Business Component set to TRUE, should limit the records displayed in Pick Applets and Association Applets to only those records that are displayed in a ‘My’ view of that Business Component.

For example:

b). The ‘Popup Visibility’ property on the ‘Opportunity’ Business Component is set to TRUE. Hence, all Pick Applets and Association Applets based on the ‘Opportunity’ Business Component will always display only those Opportunity records that are visible to a user in the ‘My Opportunities’ view.

Oracle Enterprise Data Quality (OEDQ) - Siebel Configuration (high Level)

This post will explain about the Oracle Enterprise Data Quality (OEDQ)  with Siebel configuration:

Click the link below for more details:

Oracle Enterprise Data Quality (OEDQ) - Siebel Configuration (high Level)


will provide the more details soon.....