Skip to Content
Former Member
Jun 25, 2007 at 03:40 PM

Obtaining month from 0fiscper - is it possible at query design time?


Hello Guru's,

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

selected year

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 .... 😔