Skip to Content
0
Former Member
Jun 02, 2011 at 11:58 AM

DateTime issue in WEBI Query

65 Views

Dear All.

i have created a simple universe and in which there is one column of type DATETIME i created one Dimension object of Type DATE for that column.

I want to get all the data from the table by giving datetime criteria i.e. for one day its start form 10:00 PM to morning 10:00 AM.

for example if i want to get the data of 1st June i have to give the criteria in the filter.

01/06/2011 10:00:00 PM to 02/06/2011 10:00:00 AM OR

01/06/2011 22:00:00 to 02/06/2011 10:00:00

I try to pass these both format in the filter but it get no data and when i pass only the dates i get the data.

Can any body please let me know that how to pass the datetime so i can get the data base on datetime.