December 20, 2000 07:20 PM

What Time Is It?

Rating: (0)
SQL Server Magazine
InstantDoc ID #16041
Use the Time dimension and MDX functions to slice your data by time periods
Of the several misconceptions surrounding the Time dimension, one of the biggest is that an OLAP cube must have a Time dimension. The truth is that some OLAP applications, such as activity-based costing, don't have a Time dimension at all. Activity-based costing usually doesn't need a Time dimension because the costing is based on activity, not time. The second most common misconception is that ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Article very good.
I am looking for how can I design my time dimension or query my cube to get averages for the 6 or 12 last months.
The last six months includes months of the current and previous year or days of the current and previous months.

Roberto Barrantes 4/2/2004 8:48:23 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS