Happy New Year all ! xxx
I am certain this has been answered numerous times, but I don't know where to find it.
If I have a single time dimension with dates in it , but I want BI authors to be able to select either dates, week numbers or month number how would I best do this?
Ideally the week number and month number would be an attribute, but I can only pull through one attribute per FM package ( I suppose I could have multiple FM packages but this would be uglier than Piers Morgan).
Should I have a date dimension, a month dimension and a week dimension with lots of overlap, intuitively this feels far from efficient?
Any better suggestions?
Paris
xxxx
Periods in BI
-
ParisHilton
- Posts: 73
- Joined: Fri Apr 23, 2010 11:35 am
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2007 2010
Periods in BI
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
-
Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Periods in BI
I'm having similar sorts of problems. The advice in this post might help: http://forums.olapforums.com/viewtopic.php?f=3&t=3806
Martin
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer