How to create one measure in logic layer - 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

How to create one measure in logic layer

Received Response
92
Views
17
Comments
2»

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi,

    No, I was seeking to refine 'our' thinking into discrete 'packages', partly to ascertain that I had understood your requirement coŕectly, partly to break it down into discrete elements.

    I can envisage a number of ways this is achievable in an analysis, using one analysis as the filter for another immediately comes to mind, or sql in the filter, or using the filter functionaly to get it KPI style...

    But the 'having' clause and the time frame would seem to preclude getting it in a single step for a measure without resorting to an opaque view, materialzed view or similar ETL precomputation to replicate your sql logic, but then it would have to be for a consistent timeframe.

  • User472204-OC
    User472204-OC Rank 5 - Community Champion

    Hi Robert,

    The data is not calculated in summary table as before, since when uses select multiple date, the result for counts=1 did not be summarized(It will be calculated repeatly).

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    That is why I commented - 'it would have to be for a consistent timeframe' - i.e. you can only do this for a day / week / month as a pre-computed measure because of your 'having' clause and the fact that you want the sum of 1.

    I had a similar requirement once with share of market / share of measure for a dynamic population and the bottom line is that with BI you can not do it wholly with the measure between of the non-fixed population that you are running the underlying logic on.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    So if you can redefine the requirement to a finite set of fixed measures then it is achievable.

    Or you can construct it in an analysis it is achievable.

    The only other way I can think you could do this is by refreshing a table content at the back end database when they invoke the report - which seems excessive to say the least for one measure.

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

    Just plane hopping, but.....measure content levels....

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Sure, BUT, remember the having 1 clause for a dynamically determined period, this is not down to measure levels - though I get where you are coming from, but I am equally certain it would not work this time....

    So; - Of this population of 1 in Time from X to Y, how many?

    NOT - pinned to a day / month / year, unfortunately!!!

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

    Well for the rest you do need the forced dimensionality and granularity