User defined datatypes fields are not showing in Desinger

building semantic layer
1

The user defined datatype fields are not showing in Designer.

BO Designer – 12.1.0.882
BO XI 3.1
SQL Server 2008

For example, in SQL Server, the Address table contains following fields:

Address_1 (char(20) , null)
Address_2 (char(20) , null)
City (char(20) , null)
State_Abbreviation (not null)
Postal_Code (not null)
Country_Code (not null)

Last three fields are “user defined datatype” and these three fields are not available to Designer. Means these three fields do not show in the “Table Browser”.

Is this due to the “user defined datatype” are not explicitly defined to the database?

Any help or hints would be appreciated. Thanks

dondon (BOB member since 2008-04-18)

2

Not heard of any such issues. Are these new fields added to the table and have you refreshed the table structure in Designer?

dessa :madagascar: (BOB member since 2004-01-29)

3

Designer is not going to recognize them because it has no idea what type (alpha, numeric, or date) they fall under.

Dave Rathbun :us: (BOB member since 2002-06-06)

4

You’re best off creating an index view of the table with recognized datatypes.

If you’re unsure how to do so, please have a look at the the SQL Server BOL chapter covering indexed views.