Audit - determine who(user) and what was change on the analysis/criteria

FelixB

Hi All,

Trying to pose this Q to the group.

Does the OBIEE  front end offers a functionality to determine who(user) changed it and what was changed on the criteria/Report Tab without asking the back end OBIEE developer to provide this info? 

Does OBIEE offers a versioning functionality on the front-end ?

The only information I can get is a high level information on using the Analysis's properties.

Thanks,

-Felix

FTisiot

Hi Felix,

Probably the advanced usage tracking mentioned here can help

Thomas Dodds

"Does the OBIEE  front end offers a functionality to determine who(user) changed it and what was changed on the criteria/Report Tab without asking the back end OBIEE developer to provide this info?"

Sounds like a lack of development management.   How are development tasks being assigned and completed if no one bu the developer knows -- and you don't want to ask them?

[Deleted User]

SampleApp comes with scripts for certain webcat reports which are then pushed to the db and analyzed through obi.

Yan can take those as a starting point and push the info of who changed which analysis to the the db. If possible on column level not sure, i dont have it in front of me right now

[Deleted User]

Oh yeah that too. I firgot about that one.

Joel

I believe this is what @Christian Berg is referring to: SampleApp v607. You'll need the SampleApp VM to get hold of the actual scripts to see if they extend to your particular requirement.

FelixB

Thank you all for the immediate response. We do have the usage tracking but may need to verify if this is the same Enhanced Usage tracking mentioned by FTisiot.   There is a development management set in place, However, my role just as  a front-end developer with (no access to the back-end) sometimes have to think out of the box on how to service the users without involving the back-end developers. This question hinges to the fact that we are providing clients to have the option to make modifications to fit their own business needs.  However, if there were changes that was made and results is not what their expecting, then it falls back to us to figure out what happened.

" I feel like we are letting our clients use a high tech robust car with lots of functionality, instead of us driving this car to get them from point A to point B.  But we should be able to plug in a devices to find out what exactly happened and why it is no longer working as expected." - Felix

Thomas Dodds

"This question hinges to the fact that we are providing clients to have the option to make modifications to fit their own business needs. "

It is ok and good to let business users make their own changes ... however without management of those changes you end up in the situation you are in.  Why aren't business users making changes in a 'sandbox' folder for which they request of the admin/bi team to migrate to the 'generally available'/certified folders?  This process then can be used to not only archive the outgoing/working version but also track the history of changes to the object itself.  It doesn't have to be cumbersome either... it also ensures that what ever is to be promoted has the chance to be certified and there is no 'not getting expected results'.  If they are getting that then you know it is in their sandbox folder and you can lend technical assistance - certified production objects aren't being modified on a whim.

FelixB

Hi Thomas,

I 100% agree to what you said. However, the platform is designed for (user(s)s) to have the ability to modify based on their needs.

Thomas Dodds

" However, if there were changes that was made and results is not what their expecting, then it falls back to us to figure out what happened."

You've pointed out the flaw in the design ... sometimes a tool cannot 'fix' a flawed process - the process needs redesigned.

FelixB

Agree.