Environment is Cognos 8.4.1 report studio against MSAS cube. I have some reports that need to automatically pick certain months (3,6,9 & 12) only from Month level within Date dimension. Right now I have them hardcoded that I manually add/change every year end. Report has a parent filter for years. How can I automate/create a calculation that automatically calculates only the quarter ending months within a year. For now, I can only think of using item or lag function and create a set. Is there any easier/better way to do this?
This topic has been locked.