Confusion with the "Value" display under Distribution while profiling in SAP BOIS?

[former_member188628]

Hi All

      I am a newbie in the world of Data Governance(Profiling). I was trying out the profiling option  with some sample data in the SAP Information Steward tool. But I do have a doubt in the value displayed under the "Value" (in Distribution tab/Option) in the Profiling results as shown below in the following image(highlighted in the right):-

My "Adrs" field contains three digits numeric code values(no text field) and there are no data having 999Then why '999' is displayed there?

Please help me in understanding the concept

[Former Member · Accepted solution]

Hi Maity,

999 is the match pattern for 3 digit code in your data.

Generally when we do match pattern for any digits in profiling we use '9'

Ex: 10 digit mobile number should contain only 1 to 9 numeric data then pattern would be '9999999999'

Hope you got it.

Regards

Eliza

[former_member188628 · Accepted solution]

Hi Elizabeth

       Thanks for the response,but why only those records were displayed under the pattern 999

Regards

Moumita

[former_member187605 · Accepted solution]

You have a total of 46 + 206 = 252 records in your table. There are 19 different values in the ADDRS column, 81.75% of the records (206) have a blank ADDRS. The 46 other records all have a 3-digit (cf. the pattern 999) value.

[former_member198401 · Accepted solution]

I think Elizabeth is correct.

Moumita,

Can you check if there are 46 records with the 3 digit code data and 206 records with Blanks.

Regards

Arun Sasi

[former_member188628 · Accepted solution]

Hi All

     All your responses and solutions are now very clear to me.I understood the fact.

Thank you All Again

Regards

Moumita

[former_member198401]

Can you check with other characters such as '' or other special characters in the ADDRS column.

You can also do data profiling in the View data option under the Column Profile Tab in BODS.

[former_member188628]

Hi Arun

Thanks a lot for the quicker response.

The Adrs column is stuffed with lots of blanks and three digits codes alone,no special chars,as

shown below:-

[former_member198401]

Can you do a quick Data profiling for this table in BODS. How does the 999 looks in BODS

Regards

Arun Sasi

[former_member188628]

Hi Arun

Could you please help me out with the steps to do Data profiling in BODSI am unaware.I googled it ,but it showing info related to SAP Information Steward alone.I Guess Profiler server is required to be created for this option.But i have not implemented this in sap bods yet, just created a connection using the CMC,and sql server and using that.Please help out or do i need to create the profiler repo now( i might not have permissions to do that)

Thank you

[former_member198401]

Very Simple Moumita.

Import dbo.AC_COUNTRIES in any of the created datastores which is pointing to SQL Server DB i guess

Once imported click on View Data. Go to Column Profile Tab and select the ADDRS column for viewing Top n rows and click on Update. It will give you Data profiling statistics on the ADDRS column.

For more details refer to below document

Regards

Arun Sasi

[former_member188628]

Hi Arun

Thanks a lot for the steps.It needs some time.let me try this a get back on this.

Regards

Moumita