Skip to Content
avatar image
-1
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 15 at 04:38 PM

    This is happening when you validate it in the IDT because you're just calling the function and it's not attached to a table. So the IDT sends something like this to the server:

    Select dbo.fxnAvgDepLcy (2017,1,'9205502') from

    which fails because there is no table. When you add the dimension/measure to a webi report, it's part of a larger query, so it works.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • Are both universes using the same connection with the same credentials?

      I can't see all of the "Select" from either of the images. Are you sure you have the correct commas and did you close the parentheses on the one that isn't working? You might try copying the one that is working and paste it to replace the one that isn't working.

      -Dell

  • May 15 at 03:20 PM

    Give us more information on the function.

    What type of function do you have?

    Is this a table-valued function?

    How are you calling the function from IDT?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sonet,

      Could you suggest a solution if you have faced a similar issue or how i can work around the issue .

      Kind Regards,

      Pince