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.
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.
