Hi all,
Please reply ASAP. I have a time sensitive project. Thank you all for
your efforts.
I currently have several time dimensions along with several other
dimensions and measures.
All my time dimensions Have only: Year, Quarter, Month and Day levels
of aggregation. This is derived from the time stamp and hence
staightforward.
I need to include a Week level aggregation to all the current time
dimensions: Do you know how i can do it? If it requires MDX could you
please give me an example. I am new to Microsoft Analysis Services
Thank you,
Sharan

Sharan,

You will need a new level in your time dimension.

Member key column is : DatePart(week,"dbo"."Time"."Date") -----Time means
the table name of your source table for dimension time. Date means the field
in your source table for dimension time.

Member name column is : 'Week ' + convert(CHAR, DateName(week,
"dbo"."Time"."Date"))

Hope this helps

Mike

"HELP" <sharan24 (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1127243829.286056.58490 (AT) g43g2000cwa (DOT) googlegroups.com...

If you created a member property for each day called something like
"week number" you could use this to create a virtual dimension.

I can't think of a way to get weeks into the existing hierarchy as it is
incompatible with the quarter/month hierarchy. Strictly speaking it is
either an alternate hierarchy. A virtual dimension will get you around
this, but be warned that virtual dimensions do not get aggregated so
performance will not be as good as on a "real" dimension.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1127243829.286056.58490 (AT) g43g2000cwa (DOT) googlegroups.com>,
sharan24 (AT) gmail (DOT) com says...

Thank you Mike and Darren. Appreciate your quick response. I have
decided to go with Year, Week and Day Time Dimension. So now it is quite
straightforward.
-sharan


*** Sent via Developersdex http://www.developersdex.com ***

Thank you Mike and Darren. Appreciate your quick response. I have
decided to go with Year, Week and Day Time Dimension. So now it is quite
straightforward.
-sharan


*** Sent via Developersdex http://www.developersdex.com ***