Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Working with Direct Database Reports - calculated measures

Received Response
1
Views
3
Comments
692027
692027 Rank 1 - Community Starter
edited Aug 13, 2024 5:49PM in Oracle Analytics Forum

Has anyone found a way to be able to create calculated measure in pivot tables using direct database queries? I'm trying to divide to show the % change between two columns and then summarize it with a grand total. No aggregation rule works for this (it just sums the percent changes in each row) so a calculated measure would be best. Problem is, since a Direct DB report does not come from a subject area it appears to not allow me to create one.

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    Have you tried pushing this down to the database as part of you DDR SQL?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Keep in mind DDR (direct DB requests) bypass the core of the tool, so you don't get most of the feature the tool has.

    If you want a calculation you need to do as Joel said: do it in your query (as you are writing a query instead of using the models of your RPD, you can't really expect to not have to model things but then have the tool automating things and letting you add calculated items etc.).

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    You could create an opaque view on the physical layer and then use this to model in your business model layer very rapidly, but DDR should be temporary measures, not permanent solutions - and opaque views are not much improvement before anyone else says it...