Hello Experts,
I am trying to call a function defined in ms sql database to use in universe.
When I run the function in the ms sql database I get result but when I run in IDT using the SQL Assistant, I get an error " [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fxnavgOdFcy", or the name is ambiguous."
any help will be greatly appreciated.
I am using BO 4.2 SP 4 and IDT
MS SQL 2012
Regards,
Prince Britwum