We have CABI 4.1 installed in our environment with views and functions created in SQL 2014. We are now building a derived universe wherein we need to add the views/functions created in database.
We are only able to see the tables via the CA SDM ODBC connnection.
Kindly suggest a method to add views, function and stored procedure in the universe in order to pull the report using the same.
Database views are not available in the Service Desk universe as it does not interact directly with the database.
You may need to create a Derived table in the Universe, with similar SQL logic that you have in your views.
Thanks for the reply Raghu.
Can you also suggest, how we can handle the functions that are created in database.
Do we have any way to map functions to universe.
Following instructions from CA Technologies, like said by Raghu.Rudraraju and you can see documents (Install CA Business Intelligence - CA Service Management - 14.1 - CA Wiki)
Follow these best practices when maintaining and using CA Business Intelligence:
We can do it this work customizing for this task use CA BI Universe Designer. (You may need to create a Derived table in the (NEW) Universe, with similar SQL logic that you have in your view)