SQL Server Analysis Services (SSAS) 2005 - QTD Calculated member or Time Dimension Hierachy

Posted on 2009-04-28
Medium Priority
Last Modified: 2016-02-12
Does anyone know the syntax to create a QTD sum of a measure in SSAS 2005, either by creating a calculated member or setting up a time dimension that dynamically defines QTD groups in a dimension?
Question by:reymadrid
LVL 22

Accepted Solution

PedroCGD earned 2000 total points
ID: 24251931
why you need to create a calculated measure?!

If you have a date dimension with QTD, you only need to set your measure to be sum and browse this measure with QTD field from date dimension


Author Closing Comment

ID: 31575520
Thanks Pedro!  Almost as soon as I wrote out my question, I realized that what I really needed was a dimension that is dynamic (changes every month) grouping the last three months.  Your comment validates the direction I am now going in.  Thanks again

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Integration Management Part 2
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question