Is there a version control feature in Oracle BI Answers for a single Analysis? -
i built analysis displayed results, error free. well.
then, added filters existing criteria sets. copied existing criteria set, pasted it, , modified it's filters. when try display results, see view display error.
i’d revert earlier functional version of analyses, without manually undoing of filter & criteria changes made since then.
if you’ve seen feature this, i’d hear it!
micah-
great question. there many times in past when wished had simple scm on oracle bi web catalog. there no "out of box" source control web catalog, simple work-arounds exist.
if have access server side web catalog lives can start following approach.
oracle bi web catalog version control using git server side cron job:
- make backup of web catalog!
- create git repository in web cat base directory root dir , root.atr file exist.
- initial commit eveything. ( git add -a; git commit -a -m "initial commit"; git push )
- setup cron job run script hourly, minutely, etc tell git auto commit adds/deletes/modifications git repository. ( git add -a; git commit -a -m "auto_commit_$(date +"%y-%m-%d_%t")"; git push )
here issues approach:
- if cron runs hourly, , analysis changes 3 times in hour you'll missing versions in there.
- no actual user submitted commit messages.
- object details such objects pretty "name" (caption), description (user populated on save dialog), acls, , object custom properties stored in binary file format. these files have .atr extension. news though actual object definition stored in plain text file in xml (without .atr).
take baseline, , build upon it. here how step up!
- use incron or other inotify based file monitoring such ruby based guard. using approach commit instantly anytime user saves object , bi server updates file system.
- along inotify, leverage bi soap api retrieve actual object details such description. allow create meaningfull commit messages. or, parse binary .atr file , pull info out. here links learn more web cat atr files: link (keep in mind links discussing obi 10g. binary format 11g has changed slightly.)
Comments
Post a Comment