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

Posted on 2009-04-28
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

    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

    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

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now