hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source.
My ODBC was succesful and i can import from that database but i get following errors when i try to update row count.
There was an error while updating row count for "test"."AdventureWorks"."HumanResources"."Departme nt":
nQSError: 16001ODBC error state: S0002 code: 208 message :MicrosoftODBC SQL Server DriverSQL ServerInvalid object name 'Department'..
nQSError: 16015SQL statement execution failed.
July 24, 2009 9:35 AM
July 24, 2009 1:13 PM