2 Replies Latest reply on Jun 25, 2019 2:34 AM by Maria Riccelli

    Converting Custom view from Presentation Server to BIRT report

    Oscar Garcia
      Share This:

      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:



      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.




      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.