Date and Time values in BI APPS reports

Question

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 · Answer

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

1976478 · Answer

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 · Answer

"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