Post reply

unable to link DimTime with TimeField in My table, SSAS project

  • March 16, 2011 at 7:46 am

    #150057

    Hi ,

    I have Added time dimension in one of Analysis service project and in this project there is another dimension with following data.

    ------------------------------------

    Id value timeAdded

    9 2 2011-01-19 15:15:00.000

    45 8 2010-11-02 10:05:00.000

    65 12 2009-05-19 09:25:00.000

    our objective is to browse above data in cube based on day wise,weekly , monthly,quarterly and yearly basis.

    since time dimension has Key value associated in time dimension table which is not referenced to My above table (timeadded field) with above format of data. How can i browse my data based on periodical basis??

    Please guide me how i can relate this timefield column of my table with DimTime.

    Thanks in Advance 🙂

  • March 17, 2011 at 3:48 am

    #1299838

    In SSAS DSV, create named View on this table and add one more column which has no time associated with timeadded column. Now you can use the new column to join date dimension.

    Thanks,
    Amit G
    http://www.msbiconcepts.com

  • March 18, 2011 at 6:57 am

    #1300469

    There's not enough here for me to be sure this will help, but:

    The date time entries you have should arrive in two columns, one column which points to the date table, and another which points to the time table. That will give you the flexibility to look at the data in a lot of ways.

  • March 22, 2011 at 2:52 pm

    #1302188

    I would agree with RonKyle on this. I would add 2 columns to the source table that contains your timeadded value, one for the date of the timeadded value and one for the time of the timeadded value. This way you can join your timeadded date value to the date dimension and the timeadded time value to the time dimension. Then you can browse your cube by date or time and you can join other date values to these date and time dimensions later as needed.

  • March 22, 2011 at 11:20 pm

    #1302272

    Thank you All, your valuable response worked for me. 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply