How to create Time dimension?
Please accept my apology in advance, if this was already answered. I tried to search the KB but could not comes across except this article http://community.yellowfin.bi/knowledge-base/article/how-do-you-create-a-time-based-distribution-using-time-dimensions
We are using BMC Smart Reporting ( Which is YellowFin BI ), it does not include Date and Time dimension OOTB. I am wondering if some one can help to provide guidance to add them for better reporting.
Current requirement is to generate report and add filter on resolve date (in db its stored unix date in view it displays the timestamp format) between 09:00 AND 17:00.