0 Replies Latest reply on Jun 7, 2019 12:48 PM by Oscar Garcia

    Converting Custom view from Presentation Server to BIRT report

    Oscar Garcia
      Share:|

      Hi Team

       

      I have been working with a customer for a while. In presentation server, I have created some custom views.

       

      We are interested in some information that you can obtain for the vmware view, for example the forecast information:

       

      forecast.png

      The problem is that customer is asking for the views to be exported as a report each friday. Even when tsps has the capacity of export some parts of the view, it has not schedule capabilities.

       

      For this situation, I have been exploring the BIRT interface in reporting studio.

       

      Thanks to Mike West from BMC, he shared some tips to use this info:

      "

      You can get the information you need by using the public view pv_rm_recomm and joining it with pv_system to get the system names.

       

      https://docs.bmc.com/docs/display/btco113/Accessing+data+using+public+views

       

      Depending on how large the environment it might be best to create a materialized data mart with the results from your query…

      "

       

      But the information has the xml tags inside, Mike alse shared a solution:

      "

      REGEXP_REPLACE(rr.recomm, '<.+?>', '')           AS recommendation

      "

       

      That doesn´t work for me, but I used this:

       

      select *, REGEXP_REPLACE(rr.recommendation, E'<[^>]+>', '','gi' )AS recommendation_jojo from pv_rm_recomm rr

       

      With this query, I created the datamart in Data Sets:

       

      Now I can see the information in Preview view:

       

      This has been the first step in creating this custom report.

       

      Hope this helps to someone else.