Windows 8 Hot-Keys

One of the best things you can do to get comfortable with a new OS is take some time to learn the keyboard shortcuts. Here are the Windows 8 Hot-Keys Windows logo key+ C Opens Charms bar Windows logo key+, Temporarily peeks at the desktop Windows logo key+. Moves the gutter to the right (snaps an […]

Read More Windows 8 Hot-Keys

Backing up SSAS – Yes or No?

A question came up recently about how to back up SSAS. The vast majority of my clients do not back up SSAS. This isn’t appropropriate for all deployments, though. Here’s the thread: This runs contrary to customary SQL server practice, but : You may want to evaluate whether you back up the SSAS servers at […]

Read More Backing up SSAS – Yes or No?

Strange results from MDX Query

I am currently working on adding forecasting capabilities to an existing customer cube. The MDX to do this is based on calculations in an existing spreadsheet model. The spreadsheet works very well in terms of modeling the business accurately, but it’s a manually intensive process and does not recalculate automatically as needed. Perfect candidate for […]

Read More Strange results from MDX Query