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.
Right now, OAC offers pre-built pages and watchlists related to NSAW. At our University, we do not need these pages, and we want to delete them entirely. We've been told in response to our SR that all we can do is keep "Access" limited to only the default admin and sysAdmin roles. This prevents regular users from seeing…
It would be nice to have a way to right click on an object (subject Area, Column, Calculation, etc.) in the Data Panel and show where that object is referenced in a workbook = canvas, visualization, filter, calculation, data action, etc.) In Workbooks with multiple canvases and multiple subject areas, we are left to hover…
We want to automate the workbook export to .dva file and import this into another OAC instance using REST API, The goal is an OCI DevOps pipeline that can promote (a) a whole folder, (b) a single workbook, or (c) several workbooks in one run to another OAC instance, and print a status result at the end. Blocker: Export and…
When Oracle Analytics AI features find an anomaly, trend or key driver, let authors save those results as a dataset or subject area. Each run would add rows with the metric, the date found, the expected versus actual value, the severity, the main drivers and the filters applied. Authors could then build workbooks, schedule…
We use the snapshot to update AppRoles members. But we would like to disable catalog content to have smaller snapshots and create snapshots faster.
