DateTime issue in WEBI Query
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.