Post reply

Build ssas OLAP(Molap or Rolap) without aggregations

  • April 29, 2009 at 7:08 am

    #384468

    Is it possible to build OLAP with no pre-aggregation, no pre-calculating, no dimension, no hierchy?

  • April 29, 2009 at 11:24 am

    #986149

    Right click Cubes, go to New Cube and, in the Wizard, choose "Build the cube without using a data source". Then you can generate a schema and do something else that will load the schema with data.

    I think that's the answer to your question, anyway. I'm just learning this stuff right now myself. @=)

    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:50 am

    #986160

    okay, thanks Brandie. I give it a try. good lucks on your learning of this.

  • April 29, 2009 at 12:04 pm

    #986171

    You're welcome. And thanks for the luck.

    Let me know whether or not this does what you're wanting.

    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 4 posts - 1 through 3 (of 3 total)

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