Greetings from sunny Adelaide, Australia!
Is it possible to have multiple alternate drill-downs in a time dimension?
We presently use a time dimension with a primary drill path of YEAR/QUARTER/MONTH/DATE, with an alternate path of WEEK/DATE with the WEEK set to Week Starting Friday.
We would like to create another alternate drill path of WEEK/DATE, but for a Week Starting Sunday to satisfy some other users' reporting needs.
Transformer seems to let me create a second alternate path, but as I fill in the Source-General-Time-OrderBy-Description tabs to define it, the whole application just ups and leaves, closing down completely. I have attempted to do the tabs in a different order, OK'ing and saving in between, but I can't seem to populate the whole set of tabs without it crashing. Once it even had all important tabs populated, but crashed as I OK'd the Description entry. On that occasion it locked the model up completely and it couldn't be re-opened (showed a TR3110 error I think it was).
I guess I need to know whether Transformer can support this type of multiple drill path (where two of the paths are very similar) and if so whether I'm just going the wrong way about it.
We're using Transformer 7.0.705.0-0
Regards,
Doddy