Represent Data in DD:HH:MM:SS Format in OBIEE

I used the below formula to represent the data in DD:HH:MM:SS.


TIMESTAMPADD(SQL_TSI_SECOND, CAST(("Fact - Sales Rep Call Statistics"."Total Time User Available")AS INTEGER),
TIMESTAMPADD(SQL_TSI_YEAR, CAST(("Fact - Sales Rep Call Statistics"."Total Time User Available")/86400 AS INTEGER),TIMESTAMP '2000-01-01 00:00:00')
)


we can use this either in RPD or presentation layer.
After applying above formula to the column it changes to Datetime type.


In the report go to :-

Criteria ->Column Properties ->Data Format

Select Override Default Data Format.
Date Format = Custom
Custom Date Format  = YY:HH:mm:ss
Display Time Zone    = Default
Data Time Zone Offset  = Unknown   


Oracle Business Intelligence 11.1.1.5.0

Thanks
Nawneet

Running Batch file at Remote System

Step1 :- Map the Drive.

Step2 :- Open Command prompt here x is the mapped Drive.

C:\Documents and Settings\odughatp.GEOMETRIC>net use x:
Local name X:
Remote name \\pun-ebs1211\INVENTORY_DUMPS
Resource type Disk
Status OK
# Opens 0
# Connections 1
The command completed successfully.

C:\Documents and Settings\odughatp.GEOMETRIC>x:

X:\>cd test

X:\test>test.bat

This will execute the command on server.

Which table my Report takes data.

Some time we got the repository and answers already created.
so we are stuck with the question like;

what tables the perticular report is going to hit.?
What is i add the new column to existing repots ?
Why my query is taking tables X as join condition ?

We Answer these question , what we can do kind of quick validation is

Select the all columns you have selected in report in presentation catalog and then you select
either Logical table source and physical tables.
as below
















Cheers
Nawneet