I have two questions that I'm hoping someone can answer for me. I'm using Transformer 7.3.
- I have a cube which contains two time dimensions: manufactured and entry date. Is it possible to have manufactured date as the default, with entry date as an alternative drill-down below it?
- My time dimension is currently structured as follows: Year -> Period -> Week -> Day. My users are asking for the ability to analyze and graph data based on Year(s) vs. Period/Week. Is it possible to do this without breaking apart the Year, Period, Week relationship? I'm hoping this can be done using relative time.
Thanks!
For the first:
You'd need some source data transformations to create an alternative drill-down of such kind. The base level for drill-down (day in your case) should be unique, so you ought to combine entry dates and manufacturing dates into a single column somehow. Yet it seems very hard to me.
For the second question:
See relative time categories themes in help. They should be there by default, if you used Date\Time Wizard.
For #1 I would suggest creating a scenario dimension (Transformer 7.3 and above only) with the manufacturing date as the default and the entry date as the other choice. Scenario dimensions are so new many peope have not tried them, but I built exactly this type of cube and the users love it.
Good luck,
Opher
Is there information in the help about scenario dimensions as well. As you stated, I am one of the many that have not even heard of that concept.