How to unit test OBIEE repository — Oracle Analytics

Oracle Analytics Cloud and Server

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

How to unit test OBIEE repository

Received Response
21
Views
6
Comments
3310714
3310714 Rank 6 - Analytics Lead

Hi,

Is there an easy way to unit test changes made to an offline OBIEE repository?  The only way I know is to upload the updated repository to the BI Server and run an Analysis.  However, I have many changes to make and its troublesome to always ask the Server admin to do the upload.  Please advise!

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Question out of curiosity: How would you want to test RPD changes without actually running it on a server?

    And by the way if you want to test changes even between your internal releases (rather than between 11 and 12 as it was designed for initially) you can use the BVT - Baseline Validation Tool - to do a lot of the verification for you:

    https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-7E0C3534-3283-418F-912D-F4F39880543D.htm#BIMIG-GUID-7E0C3534-3283-418F-912D-F4F39880543D

  • That's what a sandbox is done for ...

    You can't really develop offline and after 2 months of changes deploy your RPD and hope it works ....

    As a developer you would be more productive with a sandbox where you can develop and test your changed as often as you need, and then you would ideally have a set of regression tests (as Christian said BVT cant be a really good way to do it) and you run that set of tests on your new RPD and analyze the result.

    Ideally this step can be done automatically, when you push your changes to the versioning tool where you keep your RPD etc. there is a trigger which checkout your new changes, deploy it on a test instance of OBIEE and run the regression tests and return you the result of the test.

    For this kind of needs something like Docker can make your life much easier, an instance is create on the fly, test executed and OBIEE instance deleted right after... Have a look at https://github.com/gianniceresa/docker-images if interested ...

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    + Giannni's response of getting your own sandbox - then 'development' becomes the integration box

  • 3310714
    3310714 Rank 6 - Analytics Lead

    OK, thanks all for the knowledge!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Can you please actually close your threads by marking the appropriate answer or answers as correct / helpful?

    Saying thanks is polite but not very helpful for other forum users who actually utilize the search functionality and find this thread still marked as "Not Answered".

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok I actually took the time and went into your profile. 6 questions and for ZERO of them you bothered actually closing it!

    pastedImage_0.png

    Come on seriously. Have some decency here and follow a minimum of netiquette. Not marking things as helpful or correct is quite frankly very egoistic because while we're here trying to help you...you yourself do not help other forum users one single bit because without actually reading every thread and every response one by one and guessing whether it helped or solved your issue THEY WILL NEVER KNOW WHAT SOLVED THE ISSUE.