It all depends on the objects you have to work with, ideally your it dept would set up YTD, QTD and MTD measures for you so the report creator could just drag and drop. if this is not the case then you will have to create variable to compare the month name/numbers if its in the quarter then count the measure else count 0.
In reporter, you can define new variables from the menu Data >> Variables and then use the functions available in BO to do what you want like:
Mth=Month(<Date>)
QTY=Quarter(<Date>) or ="Q"+FormatNumber(Quarter(<Date>),"0"
YRS=Year(<Date>) or ="Y"+FormatNumber(Quarter(<Date>),"0000"
If you want to create objects in the universe, then you have to find first what is the SQL syntax you can use from your database guide or/and your IT deptartment to insert them in the universe (See BobWard's post).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.