Clarity

  • Private Community

  • 1.  CA PPM On Demand Change Domain Lose Ad Hoc data

    Posted May 18, 2017 02:28 PM

    V. 15.1

     

    I have a homebrew domain. 13 tables are linked. 20 or so fields are exposed.

     

    We have an ad hoc report that uses that domain.

     

    Ad hoc was fine, showing all data until the other day. We changed the join between DWH_RES_RESOURCE and DWH_RES_OBS_MAPPING to be left outer from an inner join. Since making this change, we can no longer see OVH time in the ad hoc report. If we make a new ad hoc, all investments show as expected.

     

    If we try to change the data source, then all the fields, filters and formatting go away.

     

    Is there a way to "reset" the ad hoc's interaction with the domain without having to recreate the ad hoc?

     

    Thanks, Joanne



  • 2.  Re: CA PPM On Demand Change Domain Lose Ad Hoc data

    Broadcom Employee
    Posted May 19, 2017 02:22 AM

    Hi Joanne,

     

    Interesting, this shouldn't happen. Can you log a support ticket and we need to work with you to look into the details.


    Regards

    Suman Pramanik 



  • 3.  Re: CA PPM On Demand Change Domain Lose Ad Hoc data
    Best Answer

    Posted May 22, 2017 02:22 PM

    I found out this morning that one of our customers noticed this problem back in March but forgot to mention it to us. 

    We hadn't been seeing OVH data since then. Fixing a different join issue repaired the problem. 

     

    THanks everyone. I appreciate your assistance.