Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2011-03-13 : 05:54:01
|
| Hi, everybody! I have Time hierarchy that looks like Year-> Period Type-> Period Id. I have a dataset of dates (excluding future dates) and want current year to be displayed as a default. I have MDX ready - < strtomember("[Dim Time Period View].[Time Hierarchy].[Year].&["+ str(year(now()))+"]") >But when I add it as a property to Year attribute, I receive an error <The specified default member '[Dim Time Period View].[Time Hierarchy].[Year].&[2011]' must be from the '[Dim Time Period View].[Year]' hierarchy.>What am I doing wrong?The other question - I have WeekCount measure that must not be aggregated for Year level only (value can be taken from the first child) - how can this be done? |
|
|
|
|
|
SSAS - building time hierarchy