Comments

  • 1-3 of 3
  • Katrina Boyajian

    Hi, Chris -

    No good answer, but I do have a few questions to offer, in hopes they might spark some ideas:

    Do you ever terminate/retire dimension members?  If so, when you reload your historical data, are you reloading the associated historical metadata (dimensions) as well?  Just wondering if some data is being lost/orphaned due to changes on the metadata end. 

    Are all of your data and metadata updates manual, or have you built automated refreshes?  If the latter, are you keeping copies of the files used for the refreshes?

    If this is happening regularly, it might be worthwhile to run a set of whatever standard reports you've built for PBCS, just for your historical data, at a medium-high level of your hierarchy, on a regular basis (say, once a week).  Being able to trace whether it's the same type of data, segment of your chart, and/or section of your organizational structure, that's involved each time, might help narrow down the issue.  If you are able to isolate a particular subsection of the data this way, you could then run reports at a lower and lower level each time, and potentially figure out the actual record(s) involved (or at least what they have in common).

    Will be interested to hear if you're able to identify the root cause of what you're experiencing, as obviously data integrity is a critical concern for us all.

     

    Best,

    Katrina Boyajian

    University System of NH

  • Katrina Boyajian

    We recently asked our Customer Success rep a similar question, and he was able to provide some documentation for us:

    • Oracle Cloud Services Backup Practices (dated August 2017)
    • EPM Cloud: Service Continuity and Disaster Recovery (dated October 2017)
  • Katrina Boyajian

    We have held off setting up Power Users for now, to mitigate risk; the role seems a little *too* powerful for our institution's needs.  (We would like to be able to give select colleagues greater access than they currently have as plain Users, but don't want them over-tasking the system with open access to data pushes, etc.)