Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010

    Unanswered: Calculated Column not display correctly in SSAS Dimension

    Hi all

    In a Time dimension I want to display the Quarters like this

    'Q1 2007' instead of the 1,2,3,4 that are the data values.

    I created a calculated column called CLDR_Quarter_Name in the DSV that looks like this


    When I browse the data in the DSV it looks fine.

    But when I try to use it as a 'NamedColumn' for the Quarters attribute it does not work.

    When I browse the dimension the list of years appear but when I drill down
    the Quarters all have the same names. So I get:

    Q1 2010
    Q2 2004
    Q3 2009
    Q4 2007

    For every year. Just for info if I drill down the dates all make sense.

    It just seems to be the naming of the Quarters that is screwy.

    I am at a loss.

    Anyone any ideas ?


  2. #2
    Join Date
    Jul 2010
    sorted - needed a composite key

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts