Add view, functions from Database in Universe Designer tool(CABI 4.1)

[Anon Anon]

Hi,

 

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.

 

 

Regards,

Priyanka

[Raghu Rudraraju]

Hi Priyanka,

 

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.

 

_R

[Anon Anon]

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.

 

Regards,

Priyanka

[TMACUL]

HI Priyanka.vijay,

 

      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:

 

• Install and maintain one universe per CA product.
• Do not modify the default universe. Instead, copy it and modify the copy. Otherwise, your changes can be erased when you apply service packs, patches, and other updates. Back up all your changes and then apply the patches to your customized universe.

 

• Reports:
  • Verify that the services in Central Configuration Manager (CCM) is running, when the reports stop running.
  • Do not overwrite predefined reports.
  • Always use a predefined report as a base to build a custom report and maintain consistent formatting in all reports.
  • Administrators can modify all the reports and can create new reports that are based on the existing universe. However, administrators must not add any reports to the existing folders.
  • Both administrators and end users must not change pre-defined reports. Any changes to those reports are applied to all other users using the same CA Business Intelligence instance. Instead, both administrators and end users must create their own custom folders, copy the reports there, rename them, and customize them.
  • Both administrators and end users must add new reports that they create to their custom folders.

 

BUT....

 

     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)

 

Regards