Multiple Calculated Measures

Temoryian

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?

Gianni Ceresa

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]

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

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

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

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

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

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

[Deleted User]

@Gianni Ceresa are you bored today? X-D

Gianni Ceresa

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