OBIEE Calculated Items - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE Calculated Items

Received Response
366
Views
13
Comments
2»

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

  • Temoryian
    Temoryian Rank 4 - Community Specialist

    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? 

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    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.