Table defintion for SSAS

  • Hey all,

    I have been looking at SSAS - and i think i understand the basic concept. However one element confuses me.

    I work in the insurance industry. So i imagine i would have a fact table called Policy_Sales

    Policy_Sales would contain details on the team, datetime, the product sold, and the total premium for the sale (for instance).

    Now i would have dimensions on team, product, and presumably datetime.

    Now what i dont understand is the datetime element. Should i have one record per policy sold in the Fact table - or should it be agregated up to the date level (removing time) and having policies sold as a column.

    I am not sure how this should look. Somethings seem to suggest a datetime in the fact table, others seem to suggest a date and count.

    Many thanks for design tips.

    Dan

  • The usual design is to have a Date dimension that only has Date hierarchies and attributes.

    A seperate Time dimension is optionally created if the business reports require you to do so, and only at the grain the business requires (i.e. don't go down to seconds if your organisation only reports at minutes)

Viewing 2 posts - 1 through 1 (of 1 total)

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