Fact Granualarity — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Fact Granualarity

Received Response
1
Views
3
Comments
2698823
2698823 Rank 2 - Community Beginner
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

Hi all,

I have a data in fact table at day level,but my requirement is to populate a report from that fact table at hour level.

I mean at 12:00 AM , 1:00 AM, 2:00 AM etc..

So can anyone advise how to solve it..

Answers

  • AkanshAgarwal
    AkanshAgarwal Rank 4 - Community Specialist

    HI,

    You will not be able to display if your fact doesn't stores information at hour level.

    Regards,

    Akansh Agarwal

  • Gianni Ceresa
    Gianni Ceresa Mod 
    2698823 wrote:

So can anyone advise how to solve it..

    How ?

    Well ... add a time column or save the time with the date (so date time).

    Of course you can always take the daily amount and randomly split it around in 3-4 pieces to just generate random values by hour (PS: this is a joke, don't do that !)

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    First, if you want a day level, you have differents way,

    1. first as a best practice you have to create a new time dimension with hour level, and generate the surrugate key, its the best practice, because the data is process and you dont have to put more work to oracle bi server.

    2. second maybe you have to use a concatenated key, with day a create the dimension hierarchy to define a new lowest level

    Sin título.png

    define the new lowest level

    Dimension.png