How to get Time from date Object.
I have a date stamp objects on which , I am getting value like :
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.
Noel Scheaffer 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.