OBIEE - Connecting to SQL Server DB issue

Vamsi Rampalli

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

[Deleted User]

Just curious will you also not close this thread once you have the answer?

You never respond or close anything. This is a "community". Not a one-stop-shop where other people do your homework.

Joel Acha

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?

Vamsi Rampalli

Hi Berg,

My apologies for that.

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

Thanks

Vamsi Rampalli

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