Skip to Content
-1
May 15, 2018 at 02:48 PM

Calling an ms sql server function from database in universe idt for BO 4.2 trows an error

320 Views Last edit May 15, 2018 at 03:00 PM 3 rev

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