OBIEE - Connecting to SQL Server DB issue

Question

Hi All,

I have a requirement to create report using SQL server DB.

have created ODBC connection and imported required views in the physical layer of the RPD.

I am able to see row count but when I click on view data I could n't see the data and observed that column names are coming as values. please see below screenshot

What could be the issue and Please help to fix the issue.

Thanks,

Bharath

Vamsi Rampalli · Answer

Hi Joel ,

Thanks for your reply.

Please find below details.

OBIEE : 12.2.1.2.0

OS : linux

I didn't fine any error in log files.

Have created ODBC for SQL server and able to import tables in RPD. when I am trying to see view data I could n't see the data and observed that column names are coming as values

Have not uploaded RPD to server yet.

Thanks

Vamsi Rampalli · Answer

Hi Berg,

My apologies for that.

Next time I will make sure to close the tickets once I have the answer.

Thanks

Joel Acha · Answer

You'll need to provide some basic information to your post. What version of OBIEE, which OS, what errors (if any) have you seen in your log files?

Having said that, do you have an ODBC connection to the SQL Server DB on the machine that you're running the OBIEE Admin Tool? When you run an analysis against this data source, does it return any data?