Date and Time values in BI APPS reports

1976478 · Jul 11, 2016 12:07AM

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.

Thomas Dodds · Jul 11, 2016 11:02AM

"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 · Jul 11, 2016 9:20PM

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 · Jul 12, 2016 7:54AM

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

Oracle Business Intelligence Applications

Categories

Date and Time values in BI APPS reports

Answers