data-warehouse
Where to start multidimensional data warehousing (SQL Server 2008 & VS2010)
I am new to this concept... I have some theoretical knowledge on data warehousing, but I don\'t know where to start the multidimensional data warehousing...[详细]
2023-01-29 00:25 分类:问答Rendering STAR schema in Excel (a 2-Dimension table)
Please move to an appropriate forum if it doesn\'t belong here. I\'ve a data feed that represents some multidimensional data in star schema.[详细]
2023-01-27 16:55 分类:问答What is ODS role?
I think that here answer will come from experience. I开发者_C百科 am right know wondering what is the real goal of an Operational DataStore (ODS)[详细]
2023-01-23 21:04 分类:问答TFS 2010 warehouse job never leaves the running state
We have recently migrated to TFS 2010 using the MSF For Agile process template and we make use of such reports as the Burndown, User Stories progress etc. Up until 13/10/10, our warehousing worked per[详细]
2023-01-20 21:01 分类:问答Fact Table with Different Update Schedules
I have two sets of data with the same level of grainularity, for example invoice number.Most of the data required is updated daily as we recognize the revenue for previous invoices.However, some of th[详细]
2023-01-20 10:12 分类:问答How to decide which BI tool is suitable in a particular scenario, SSAS or OBIEE?
For a 开发者_高级运维large Data Base which one is better in performance. which one will give data very fast on MDX query execution.For a 200GB data set, SSAS on an ordinary wintel server will be fine.[详细]
2023-01-19 05:15 分类:问答Drill Up/Down example?
I need an example of what drill up/down is ( + if it\'s graphical ) for a better understanding of these operations. I\'m new to the whole Data Warehouse subject so high level explanations would be app[详细]
2023-01-17 16:14 分类:问答Python: interact with complex data warehouse
We\'ve worked hard to work up a full dimensional database model of 开发者_开发技巧our problem, and now it\'s time to start coding. Our previous projects have used hand-crafted queries constructed by s[详细]
2023-01-17 14:16 分类:问答Optimal Database Structure for MicroStrategy
I have spent most of my career developing data warehouses\\marts as Star Schemas because they were typically use开发者_运维知识库d in conjunction with Microsoft\'s Analysis Services.However, we are st[详细]
2023-01-17 08:59 分类:问答Weekly summary table; how to reference the time dimension
We\'re thinking about adding a weekly summary tabl开发者_C百科e to our little data warehouse. We have a classic time dimension down to the daily level (Year/Month/Day) with the appropriate Week/Quarte[详细]
2023-01-16 23:55 分类:问答