I have a datetime field in the database, that I need to extract just the month from. I can do this in Oracle sql but I cannot figure out how to achieve this in MSTR.
At the report front end, I can alter the format of the datetime which will give the Month, but I need to create an attribute to extract the month so that I can use it as a filter in various reports.
This will be hitting a very large table & will return a lot of rows, so an efficient method is preferable if there are options.
Any suggestions?
At the report front end, I can alter the format of the datetime which will give the Month, but I need to create an attribute to extract the month so that I can use it as a filter in various reports.
This will be hitting a very large table & will return a lot of rows, so an efficient method is preferable if there are options.
Any suggestions?