I have created a DBConnect for MS SQL database. Everything looks good. I am able to connect to SQL database and able to create DataSource for the tables from which I want to get data. These tables have data in it when I checked in SAL database. But in BW, when I click on Display Table contents, System gives me a message u201CNo Data in this Tableu2019, Message no. RSDL001. The USerID, I am using is created in SQL database with all appropriate authorization and I created same user id in BW with SAP_ALL profile assigned to it.
I would like to know as why I am not able o see any data. Help will be appreciated.
We are on SAP_BW 700 Patch-level 0018.