Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This is my Dimesion and Measure:

<Dimension type="TimeDimension" foreignKey="ReqDateKey" name="Date">
      <Hierarchy name="YQMD" hasAll="true" allMemberName="All Dates" primaryKey="date_id">
        <Table name="dim_date" alias="">
        <Level name="Year" column="year" parentColumn="date_entered" type="Numeric" uniqueMembers="true" levelType="TimeYears">
        <Level name="Quarter" column="quarter" type="Numeric" uniqueMembers="false" levelType="TimeQuarters" captionColumn="quarter_label">
        <Level name="Month" column="month" type="Numeric" uniqueMembers="false" levelType="TimeMonths" captionColumn="month_label">
    <Measure name="CountAutheticatedMedicine" column="DrugAuthCode" aggregator="count" visible="true">

I have to find Measure in drill down fashion as per Year->Quarter->Month Hierarchy. I have only one year(2013) data. I have properly design my cube and it works for other dimensions but I stuck in time dimension. I refer from here but couldn't find the right MDX.

share|improve this question
Your question is not very clear; are you trying to understand how to use this dimension with your measures? – Collin Grady Feb 24 '15 at 2:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.