For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
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
We recently asked our Customer Success rep a similar question, and he was able to provide some documentation for us:
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.)