Time Characteristic in a query
I have an InfoObject called Time (0Time) which I want to include in a query. The object is part of my InfoProvider. The time is given in hours what I want to do is group the time so that I have three values represent morning afternoon and evening. How can I do this? Thanks
Bhanu Gupta replied
In the rows part of the query designer, right click on the word Rows and select New Structure. In the Structure you see right click and select new Selection. Here make the selection by including 0TIME(drag and drop from left hand box). Right click 0TIME in the right hand side and Restrict. Restrict with values, like 00:00:01 to 12:00:00 (for Morning). Clcik OK. Change the description of the Selection to Say "Morning" and click OK. You can repeat by creating new selections for Afternoon and Evening.
You can save the structure and use it across multiple queries if reqd.
Hope this helps...