Post reply

Tables & Cubes

  • April 29, 2009 at 4:27 am

    #130505

    I have an interesting question for you all. This is my first foray into SSAS. I need to take two aggregated tables in our database and make them into cubes.

    Yes, the data is pre-aggregated. The tables are created as part of our month end process. So my question to you is, does SSAS lend itself to cubing pre-aggregated tables or do I have to build a process into the cube which takes the original data and aggregates it via SSAS?

    Does the question even make sense?

    Thanks in advance.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • April 29, 2009 at 11:21 am

    #986147

    Aha. Just found out there are still columns in my pre-aggregated tables that can be grouped and measured on.

    Nevermind. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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