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
OBIEE Calculated Items
Answers
-
0
-
Hi Guys,
Thank goodness it is Friday afternoon. I have two separate issues here:
1. CONCAT strings by ID
2. SUM displayed values from CASE statement and place that value in new column so I can reference that number in another formula. In the first of two examples above (sorry if I wasn't clear enough about this) I need the column on the right to sum to 25 instead of 100 like it currently is doing. Somewhere there is some aggregation happening that I don't want to happen causing 25 to aggregate to 100. To make this even more complicated is that I need to do about five calculations each of which is dependent on the calculation that occurs before it.
Ignoring the two issues above - if I have to do something like this is it always better to do this in the RPD?
0 -
Temoryian wrote:Ignoring the two issues above - if I have to do something like this is it always better to do this in the RPD?
"Always" - well the answer is as always: it depends.
Normally it's better to do things in the RPD for a number of reasons but I will only name one:
Easy control over pre-aggregate and post-aggregate calculation logic. Will the formula get executed row-by-row in the data set before any aggregation happens? Or will the formula get executed AFTER the data set has come back and has been aggregated.
0