SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » ssas » Dimension (RSS)

Browse by Tags

  • Time hierarchy - desc order

    Yesterday I received the task to change the order of our time dimension from ASC to DESC. As easy it is in SQL that difficult it is in AS. Or so it seemed. First I tried looking for a solution among the properties. After finding nothing I began thinking for sg in the DW or in the DSW. I don't write...
    Posted to MartinIsti MS BI blog (Weblog) by MartinIsti on Tue, Feb 24 2009
  • Star or Snowflake i.e., 1 or 2 Dim tables?

    Last week I had to design and sketch a more or less simple OLAP solution during which I had to face a certain dilemma. But before going into details I'd like to share some background. The OLTP source system is in Oracle: The first fact table row points to the "company size" question which...
    Posted to MartinIsti MS BI blog (Weblog) by MartinIsti on Mon, Feb 9 2009
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems