Need Help with time hierarchy and YTD ,MTD , QTD functions

• rabbu456

  SSC-Addicted

  Points: 414

  More actions

  February 22, 2010 at 2:14 pm

  #138947

  hi all, i had created a table called calendar in my database which has only 1 column in it that is date and it contains dates from 2007 to 2019 and i had added this table to my cube as time dimension and i had created Year,Quarter,Month,Week from my date in datasource view by using following formulas

  year - datepart(YYYY,Date)

  Month - Datepart(Month,Date)

  Quarter - Datepart(Quarter,Date)

  Week- DatePart(Wk,Date)

  the cube had created a hierachy automatically when i had added this table to my cube............the hierachy is Calendar(Year-Quarter-Month-Date)

  and Year- Weak- Date

  the attributes are not related in Calendar Hierarchary............when i m trying to create new attribute relations the hierarchy is not working properly..............

  i had created a time intelligence to get YTD ,MTD ,QTD on Calendar hierarchary ...........

  i m not getting proper values in YTD and MTD ,Qtd in my cube when i had used first hierachy

  I m getting values for current member and YTD but i m getting NA for QTD , MTD............

  i need to create a report for QTD ,MTD .......

  i need to create a proper hierachy with all attribute connections .....

  Thanks For ur Help.................