Let's say I have a simple data warehouse with the following fact tables: FactPurchase: one row per property purchased, with purchase amount, value, etc. FactMonthlyStatus: one row per property, per ...
how declaring hierarchies and level in SSAS help to improve MDX Query performance? I use SQL Server 2008 R2 and I use SSAS and I reading book Professional Microsoft SQL Server Analysis Services 2008 ...
I Use SQL Server 2008 R2 And SSAS. I write/edit MDX Query and in some case complex i need format my MDX Query like Key (Ctrl+K)(Ctrl+Y) in SQL Tools Belt. after very search i find this site ...
I have been tasked with architecting a solution for a large retail chain. They want to allow each of its 1.2 million customers to log on to a web site to see the distribution of recent purchases ...
I have four identical servers 2 are used in production and the other two are demo machines/emergency fail over boxes. The more powerful machine a 16 core 127 gigs of Ram hosts both our Datawarehouse ...
So this may be the wrong place, and may seem pretty basic, but I'm new to building up cubes, so please forgive me. Imagine a setup described by the following: CREATE TABLE [dbo].[Orders] ( ...