In my COPA cube for time characteristics I only have 0FISCPER and 0FISCYEAR. I have a request for a report with the following layout:
_______________ Jan Feb Mar Apr ... Total
selected year - 2
selected year - 1
Is there a way I can filter all of my January results in the January column ... if I had calmonth2 that would work, but i don't ... is there a way to filter only a specific month from 0fiscper (here we use one fiscal period per month, so 001.2007 would be jan/2007) using formula, cell definitions or whatever other resource we have available at query design time.
A not possible answer is acceptable here, meaning I would prob need to include calmonth2 in my cube .... 😔