Žiga Vaupot's Blog

In Oracle Analytics, calculations are a powerful way to create reusable business logic, KPIs, and metrics. These calculations live in the logical layer ( Business Model and Mapping ), where they can be defined once and reused across multiple dashboards and reports. So far, when we created a new Business Model in Logical Layer we defined measures in two ways: Fact table contains columns that are natural measures, such as REVENUE or UNITS . We can also use foreing key columns in a Fact Table to create count measures , such as # of Orders or # of Distinct Customers . But of course, these are not the only measures we could create in our Business Model . Calculations or Calculated Measures are of course something that are a must have . They are usually included in Facts , but we can have calculated columns also in Dimensions . So let's take a look at Facts and Calculated columns . Open semantic model we created and navigate to Logical Layer . Expand business model ...

In Oracle Analytics Semantic Modeler, the Presentation Layer is the final layer in the data modeling flow — it's what end users interact with when building analyses and dashboards. The Presentation Layer provides a business-friendly view of your data model. It organizes and simplifies logical objects (tables, columns, hierarchies), and allows you to control the visibility, naming, and grouping of elements within subject areas. Components of the Presentation Layer Subject Areas A subject area is a collection of related tables and measures — such as “Sales,” “Finance,” or “Inventory.” Each subject area typically maps to a single Business Model from the logical layer. Presentation Tables Represent business entities like “Customer,” “Product,” or “Revenue Metrics.” These can be renamed to more user-friendly labels compared to their logical counterparts. Presentation Columns Derived from logical columns in the Business Model and Mapping (BMM) layer. You can ren...