|
Home > Archive > MS SQL Server OLAP > September 2005 > Analysis Services Time Dimension , Week Level Calculation ? Please reply ASAP
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Analysis Services Time Dimension , Week Level Calculation ? Please reply ASAP
|
|
|
| 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@gmail.com> schrieb im Newsbeitrag
news:1127243829.286056.58490@g43g2000cwa.googlegroups.com...
> 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
>
| |
| Darren Gosbell 2005-09-21, 7:23 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1127243829.286056.58490@g43g2000cwa.googlegroups.com>,
sharan24@gmail.com says...
> 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 D 2005-09-21, 1:26 pm |
|
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.droptable.com ***
| |
| Sharan D 2005-09-21, 1:26 pm |
|
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.droptable.com ***
|
|
|
|
|