Date and Time values in BI APPS reports

1976478

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

"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

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

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