Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get Time from date Object.


Hello everyone

I have a date stamp objects on which , I am getting value like :

01/05/2015 22:15

06/04/2015 16:24

My requirement is to filter the webi Report on the basis of two parameter like :

Enter the date  & Enter the Time

For Example : if i enter date 12/10/2015 and time is : 09 then only thouse records will come which are existing on this selection criteria.

But i have only onedate stamp objects which haveing both date & Time value .

So Please suggest me how i can filter my records based on two parameter , from universe or from webi and solution will work for me.

I am using BO 3.1.

Thanks in advance.

Tags:
Former Member
replied

I see two possibilities.

1. You put everything except "SELECT" in the SELECT field of a new dimension like this...

You would replace "GETDATE()" with your column from your table.

2. You could also create a derived table in the data foundation of your universe with the conversion applied to the column you are interested in.

Noel

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question