Browse by Tags

All Tags » Dimension (RSS)

Time hierarchy - desc order by MartinIsti

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...
Filed under: , ,

Star or Snowflake i.e., 1 or 2 Dim tables? by MartinIsti

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...
Filed under: , , , ,
Powered by Community Server (Commercial Edition), by Telligent Systems