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
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4
So I have an action passing a value to another workbook. On the other workbook, I have an expression filter and a parameter I created and it does not seem to work. Any ideas. See the images
We know you can directly export workbooks and folders from within OAC, and we know you can migrate OAC content using the FDI Content bundle. However, it's unclear what settings or steps are required in order to ensure any calculations in "Shared Objects" still carry over. When making a .dva artifact export from OAC for…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
