Take the 2-minute tour ×
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. It's 100% free, no registration required.

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="">
        </Table>
        <Level name="Year" column="year" parentColumn="date_entered" type="Numeric" uniqueMembers="true" levelType="TimeYears">
        </Level>
        <Level name="Quarter" column="quarter" type="Numeric" uniqueMembers="false" levelType="TimeQuarters" captionColumn="quarter_label">
        </Level>
        <Level name="Month" column="month" type="Numeric" uniqueMembers="false" levelType="TimeMonths" captionColumn="month_label">
        </Level>
      </Hierarchy>
    </Dimension>
    <Measure name="CountAutheticatedMedicine" column="DrugAuthCode" aggregator="count" visible="true">
    </Measure>

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.