Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
81
Views
10
Comments
FelixB
FelixB Rank 2 - Community Beginner

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

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Hi Felix,

    Probably the advanced usage tracking mentioned here can help

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    "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]
    [Deleted User] Rank 2 - Community Beginner

    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]
    [Deleted User] Rank 2 - Community Beginner

    Oh yeah that too. I firgot about that one.

  • Joel
    Joel Rank 8 - Analytics Strategist

    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
    FelixB Rank 2 - Community Beginner

    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
    Thomas Dodds Rank 8 - Analytics Strategist

    "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
    FelixB Rank 2 - Community Beginner

    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
    Thomas Dodds Rank 8 - Analytics Strategist

    " 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
    FelixB Rank 2 - Community Beginner

    Agree.