obieepipelined-function

table function as physical table in Oracle BI EE

how do I import oracle table function as physical table in Oracle BI EE ? Let's say it is

select * from scheme.table_function1(adate)

What is correct syntaxis for setting it as BI physical table? How do I specify input parameter (adate)?

Solution

  • Create a new physical table manually in the repository, set the table type to "Select" and include your sql query.

    Are you using a repository variable as input parameter? Assuming ADATE is a repository string variable, the syntax would be

    select * from scheme.table_function1(  'valueof(ADATE)'  )

    You will have to manually add the columns to the new physical table and make sure they match with the sql results.

    Links:
    Opaque views
    Variable Syntax