Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Date and Time values in BI APPS reports

Received Response
1
Views
3
Comments
1976478
1976478 Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

Hello,

I am using BIAPPS 11.1.1.8.1 and I have a requirement to show the timestamp along with the dates.

Now since most of the dates column in RPD subject area comes from Date dimension (lets say W_DAY_D), it will not fetch timestamp values.

Is there a easier way to achieve this?

As per my findings, either I will have to customize the columns to bring the date and time details to my fact, or populate the WID in Fact for W_TIME_OF_DAY dimension.

Kindly advise.

Thanks in advance.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    "populate the WID in Fact for W_TIME_OF_DAY dimension"

    That's your best course of action ... you are changing the grain of the fact table so use WIDs ... so you might want to take a fact table and 'copy' it then extend; 

    example:

    W_XACT_F  copied and named custom ->  WC_XACT_F 

  • 1976478
    1976478 Rank 2 - Community Beginner

    Thanks Thomas for you inputs.

    But I dont think the grain will change if we include the time stamp dimension, as the dates are already there and we just adding the timestamp for the day.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    if you are 100% positive you won't get multiple rows per day per (rest of grain) then you can add the timestamp WID as an extended column ...  example:  X_BILL_DTTM_WID