Skip to Content

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

DateTime issue in WEBI Query

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.

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