Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Multiple Calculated Measures

Received Response
84
Views
9
Comments
Temoryian
Temoryian Rank 4 - Community Specialist
edited Aug 13, 2024 5:31PM in Oracle Analytics Cloud and Server

Hello,

I have a need to display multiple calculated measures in order.  The logic behind them is simple - If condition met then display value.  However when the values are displayed they create an additional row in the report.  Is there something that I am missing to prevent this from happening?

imagepastedImage_0.png

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Temoryian wrote:Is there something that I am missing to prevent this from happening?

    Yes, you are missing to post enough information to know what you did

    As that's an analysis (it looks like OBIEE Answers, therefor it's called "analysis", a "report" would be a BI Publisher report) you built yourself it's impossible to know how it looks like to know why it gives you that result (sure we could guess a lot of things, but it's easier when you provide the info). In this case it would be interesting to know what columns are part of your analysis and how your formulas look like (I guess you have conditions bases on another dimension values and that's what generate that result).

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    HOW are you calculating those measures and WHERE? In an analysis? In the RPD? Physical calc? Derived calc?

    You need to provide more information

  • Temoryian
    Temoryian Rank 4 - Community Specialist

    My apologies - yes this is an analysis/obi answer.  Here is the logic one of the calculated measures.  The logic for all three are basic case statements:

    CASE WHEN Table.Column = 'WPT' AND Table.Column = 'MFND' THEN Table.Column END

    I get ripped when I say this but I only have access to the presentation layer and hence why I'm trying to attempt this at the presentation layer.

  • Gianni Ceresa
    Gianni Ceresa Mod

    So your formulas are conditions based on 2 dimensions, right? And you display the 2 dimensions in a pivot: one as rows and one as column. In this case the output you have is right (because your formulas only match one cross of both dimensions at a time).

    What do you expect as result? Did you try to get rid of the 2 dimensions on which your calculations are based over in the view? (and maybe a table view is already more than enough ...)

  • Temoryian
    Temoryian Rank 4 - Community Specialist

    Yes the formulas are conditions based on 2 dimensions.  I am not displaying the dimensions that are used to obtain this value in the pivot table.  What I'm trying to accomplish is to get all of this data into one record/line.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Other hypothesis (yes, I'm just guessing as still there isn't much provided ), your columns aren't aggregated. You can check that in the generated SQL and force an aggregation to "compact" lines together and merge everything to give you back only what you look for.

    As alternative you can explore FILTER( USING ) instead of your CASE WHEN.

  • Temoryian
    Temoryian Rank 4 - Community Specialist

    Sorry for being vague.  Thank you Gianni your answers were very helpful and have put me down the right path.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @Gianni Ceresa are you bored today? X-D

  • Gianni Ceresa
    Gianni Ceresa Mod

    Just a little bored, having a break in my project with graphs and kafka, so going back to some OBIEE is a way to spend the day