I've built a date dim for an MDX cube in FM.
It's a simple thing with Year, Month & Day and it works fine.
But, I lack relative date options.
In my staging query subject I have relative categories for current month, current day, last month, rolling 6 months and so forth – but I'm not sure of the best way to get them into the cube and into Analysis Studio.
Obviously in transformer it's just a case of setting a dim as a date and all the relative date categories are magically added – is there is a similar feature in FM?
Or do I need to map all my relative date categories separately.
I know it's a bit of a vague question, if anyone can point me in the right direction or point me at a decent bit of documentation I'd be most grateful.
If you can help me there may be a cookie in it for you.
Check:
http://www.cognoise.com/community/index.php/topic,12936.0.html
IBM Proven Practices is a good place to check as below
https://www.ibm.com/developerworks/data/library/cognos/cognosprovenpractices.html#modeling
http://www.ibm.com/developerworks/data/library/cognos/page90.html
Cheers
Peter B
I've just has a look through that second document – it fills me with dread.
I've always treated facts and dims as very separate items.
Forcing the relative times to be used as measures seems quite restrictive.
Whenever I wanted to add a new relative date category I'd have to replicate it across every measure. I'm also not sure how it would work with multiple measures nested under a year and drilling into the year.
I think I'll still with true relative dates rather than try the relative-dates-as-measures idea.