Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Multiple Calculated Measures
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?
Answers
-
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).
0 -
HOW are you calculating those measures and WHERE? In an analysis? In the RPD? Physical calc? Derived calc?
You need to provide more information
0 -
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.
0 -
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 ...)
0 -
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.
0 -
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.
0 -
Sorry for being vague. Thank you Gianni your answers were very helpful and have put me down the right path.
0 -
@Gianni Ceresa are you bored today? X-D
0 -
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
0
