Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Modelling Data in OBIEE

Received Response
22
Views
7
Comments
RosyCross
RosyCross Rank 3 - Community Apprentice
edited Aug 13, 2024 5:46PM in Oracle Analytics Cloud and Server

Is it possible in OBIEE to use real data in tables - in conjunction with views using model - http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/prod/bidw/sqlmodel/sqlmodel_otn.htm  - with parameters passed in from OBIEE dashboard prompts - to create  - excel type functionality?

OBIEE 12.2.1

Oracle Database 12c

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Possible, maybe...

    Advisable, definitely not. OBIEE is a BI tool, not an interactive planning and modelling tool.

    You might get it to work but it will not have the rich functionality you need and will probably not be so great for the users to interactive with.

    If your need is small then better to look into Apex; https://apex.oracle.com/en/

    If your need is greater then better to look into PBCS; https://www.oracle.com/uk/applications/performance-management/products/planning-budgeting-cloud.html ; or one of the other Hyperion / EPM products; https://www.oracle.com/uk/applications/performance-management/products.html  ;where users will also be able to use excel with the Smart View add-in and model data in conjunction with business rules, standard excel functionality and purpose built web forms to achieve specific business ends.

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    There's a great tool that has excel-like functionality. It's called Excel.

    If you want excel, use excel, you may want to look into smartview: Oracle Smart View for Office | Business Intelligence | Oracle

  • RosyCross
    RosyCross Rank 3 - Community Apprentice

    The users just want to be able run a report on Budget data and then put some simple "what if" type assumptions on top of that.

    Can't I do this in OBIEE?

    Like inflation goes up by 5% - sales fall by 2% - you get the idea.

  • RosyCross
    RosyCross Rank 3 - Community Apprentice

    maybe - but we want to be able to store this centrally on the database - I was thinking to use write back with this.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Okay, on "simple" - it starts that way and then invariably another requirement comes your way, and another, and ... before you know where you are you are buried in user expectation with a tool which will not satisfy their requirements.

    At best you will build a limited functionality Frankenstein monster which will be flakey and the users will hate.

    Seriously, 'this is not the tool you want' - will be the best advice you hear today.

  • RosyCross
    RosyCross Rank 3 - Community Apprentice

    Okay I get it and thanks for the links -  I will study - and advise the business.

    thanks all for advice.

    Martin - I guess for now download to excel and model is not bad advice - thank you too!

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    No Problem, Haven't used smartview myself but it should enable you to get the best of both worlds