If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DMX - Relative Dates

Started by S2000, 28 Feb 2011 10:01:21 AM

Previous topic - Next topic

S2000

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.



S2000

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.