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
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.
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
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.
maybe - but we want to be able to store this centrally on the database - I was thinking to use write back with this.
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.
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!
No Problem, Haven't used smartview myself but it should enable you to get the best of both worlds
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
I tried the following expression and it blows up when I select more that one value in the list see image
We are using Oracle Analytics Server 2026 with WebLogic Server 14.1.2. Our Account Statement report is accessed through '/xmlpserver'. We need to capture the following details in the OAS/Publisher log files whenever a user runs the report: Username Report name and path Report execution timestamp Account Number From Date To…
