Clarity

  • 1.  Easy way to migrate Include in Datawarehouse information from Environment to Environment?

    Posted Feb 21, 2018 11:38 AM

    So we have multiple environments and we're heavily customized, so as we build our reports in lower environments we're enabling large quantities of attributes to include in the datawarehouse. Is there an easy process to migrate these updates from our DEV to our TEST environment easily? Without manually going into each object to check off all the boxes again? Is there a job, or process we can write? Or is there a table where this data is stored that we could update between environments?



  • 2.  Re: Easy way to migrate Include in Datawarehouse information from Environment to Environment?
    Best Answer

    Posted Feb 22, 2018 12:17 AM

    Hi e_martin ,

     

    You can use content packages to deploy multiple versions of content between development and test environments. Just create a content package by selecting that object and import onto TEST environment using content-add in feature.

     

     

    Let me know if it works for you.

     

    Regards

    Shubham



  • 3.  Re: Easy way to migrate Include in Datawarehouse information from Environment to Environment?

    Broadcom Employee
    Posted Feb 22, 2018 01:29 AM

    Hi,

     

    One of easy way maybe Data Refresh(expdp and impdp for oracle database).

     

    You will get DEV Database dump(PPM and Dataware house) and import them to TEST environment.

    Of course, you need to remap scheme to import them. 

    After import dump to TEST, you will lose all existing data in TEST.  So you may need to take backup some objects in TEST before import. (To take backup data, you can use content package or XOG) 

     

    For jasper reports, you may be able to use export function for jasper report.

    You will export jasper report from DEV and import it to TEST.

     

    Regards,

    Shoichi