In the FDI (or FAIDP) OAC, you have the ability to create Key Metrics that stay with the subject areas. I'd like to have that same ability in the standalone OAC. See screenshot below in the comments.
Hi @Branden Pavol - no plans to add KeyMetrics to OAC. Are you using KM as a shared calc object?
We have started work on Shared Calculations feature in OAC.
@Branden Pavol I do like this idea and believe it's useful, so you've got my vote. Until we can convince Oracle to add it, would creating a separate fact table in the BMM and adding all commonly used metrics and calculated metrics in there work for you? I have done this for clients to try to simply finding the most important calcs. Now I know this is has it's limitations and is not as robust and as easy to use as the Key Metrics in FDI, but if you don't need to create calc on the fly or they don't have to be at the report granularity, it is "sharable". Maybe it will work for you.
@Avinash Krishnaram-Oracle I'm not actively using the FDI OAC. I'm using the standalone OAC. I did see that the products are different if you have FDI (or FAIDP) vs the standalone. I'm looking to minimize the amount of work the Web Semantic Model developer has for some basic, repeatable calculations. If a common calculation for a given subject area is Good Quantity / Total Quantity = Good Quantity Percent, I don't always need to have that deployed through the WSM. It can be added quickly in the workbook and saved for future use if anyone else uses the same subject area.
@Carter Beaton Thanks for the support. The goal I'm trying to achieve is convenience for repeatable calculations to be created. Ultimately, the best place for them to live is in the fact folders in the subject area. This would bridge that gap and allow the business users to control that without going into the WSM.
Does Oracle have any plans to introduce LLM-based AI features in a future release of Oracle Analytics Server (OAS) on-Premises? In particular, is there a roadmap for bringing capabilities such as the Oracle Analytics AI Assistant or an LLM-powered conversational chatbot, currently available in Oracle Analytics Cloud, to…
Summary of the Enhancement We request two key enhancements to the native Waterfall visualization in OAC Workbooks to support standard financial bridge reporting: Attribute-Driven Category Axis: Allow standard categorical attributes (with custom sorting) directly on the X-axis, removing the current dependency on Date/Time…
Currently in OAC, although we can create application roles in the OCI application (e.g Service Administrator), there is no way to programmatically create and configure custom application roles in OAC itself. This has to be done via the console system settings manually in OAC. We are running a large scale OAS > OAC…
Currently, in Oracle Analytics Cloud (OAC), there is a 250GB storage limit for datasets, but there are no practical management features to operate within this limit. This makes day‑to‑day operations very inconvenient.I would like to request the following enhancements for dataset storage management: Configurable storage…
I'm not very technical so if this is a non-starter or there's a solid workaround that already exists, please advise. We have users that query SQL data sources directly in other tools, but then would like to bring that query as a dataset to OAS. Ideally they could create the view in the database and reference that object…
