Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

Alter legend

Received Response
121
Views
13
Comments
2»

Answers

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

    I thought that WAS a customized graph already.

    So @CRX you "just" want to have a new dimensional attribute which bins fact rows into these groupings?

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

    4 columns != 4 members in a dimensional attribute which to split the data by.

    Thimas gave a good hint but depending on your model you need a different approach alltogether.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    You'll need to create a physical/logical dimension ...

    Dim_AgeBins

    Key               Description

    1                    24h

    2                    48h

    3                    72h

    4                    Em atraso

    Create a logical hierarchy for this dimension and set the LTS levels to the detail level

    then in your fact table, create a logical column that evaluates the hours between (CurrentDatetime - DeliveryDatetime) and assigns the correct AgeBin key.  Join the tables in your model on the key and set the LTS for the fact at AgeBin detail.