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

Logical dimention has measures

Received Response
1
Views
1
Comments
user12863665
user12863665 Rank 6 - Analytics Lead
edited Aug 13, 2024 7:03PM in Oracle Analytics Cloud and Server

Hi,

we have logical domention time.

in that i have levels year, qtr,month,day.

i See couple of measures under year level in the hierarchy.

anyone tell me how dows that measure work for year and lower levels?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    these are level based measures, like for example "Yearly total sales".

    Because they are fixed at the year level means the value will be always be the yearly total even at the quarter, month and day level.

    It will replicate the value of the year level at all the lower levels.