Having strange issue with SQL Server field that is "bit" data type

Jerry S.

OBIEE 11g

I am working on a project that references a SQL Server data base. In some of the tables, there is a field named "Active indicator" that is of type "bit".

The field contains either a 0 or 1.

I have been able to import the "Active indicator" field into the physical layer of the RPD without any problem.

The "Active indicator" field can be used in the business and presentation layers of the RPD without any problem.

After I upload the RPD, I can reference the "Active indicator" field in an analysis and see the values.

The part that I am having an issue with, is that in the Physical layer, I cannot "View Data" for this "Active indicator" field.

I can update the row count successfully, I just cant view the data. View Data doesn't even come up as an option.

This is not something that will stop the project, it's more of a nuisance than anything else, because I like to look at values

in the RPD for troubleshooting.

Has anyone encountered this before, and if so, is there a way around it so that I can see the data in the RPD?

[Deleted User]

That's basically just a BOOLEAN. 0, 1 or NULL.

Sherry George

Might be a limitation with OBIEE. Check this document https://docs.oracle.com/cd/E28280_01/bi.1111/e10540/data_types.htm#BIEMG4602

Try changing the datatype in physical layer to INT or CHAR and check if 'view data' works