I have a date dimension I have created in a DMR Framework.
It consists of Year, Quarter and Month.
When I open the package in Analysis Studio, the year is sorted but the Quarter and Month are not.
There doesn't appear to be a way to sort in Framework Manager like there is in Transformer.
Are there any solutions to this problem?
This dimension is based on a Calendar table which consists of a Calendar Key and a Calendar Date.
Try dimensional modelling of your time query.
Can you give me a little more information?
Terry