Monthly Archives: June 2014

FOREX Conversion in OLAP Cube

By | June 23, 2014

I was conducting training recently where the participants asked for a solution on how to convert data from many different currencies into a target currency using an exchange rate table. For those building enterprise cubes this might be a familiar problem since consolidations of amounts across reports is usually a challenge. I remember seeing an… Read More »

5 Mary series, SSIS using TSQL in MSBI

By | June 20, 2014

An All new video on using TSQL task in SSIS to run a query and fetch data from the database and assign it to a table. All part of the Mary series of videos. We are following a new pattern with these videos, trying to keep the short and more focused around a single task.… Read More »

Unable to establish server mode SSAS tabular mode

By | June 15, 2014

Ever encountered the above error when starting SQL server management studio and connecting to SSAS ? The error has a few different root causes one of which is detailed in the link below. https://connect.microsoft.com/SQLServer/feedback/details/686801/ssms-raises-unable-to-establish-server-mode-error-if-ssas-encounters-errors-during-startup However this is not the only cause, the error can even occur if the databases are not operational. E.g. in this… Read More »

Not getting options when right clicking the report in report manager

By | June 14, 2014

I came across this issues today while doing a training today reporting services report manager doesn’t display the options when you right click the report . See the screenshot below. I was getting no response when I should have been getting The reason for this is due to the Report manager not being rendered properly… Read More »

The world needs to watch this

By | June 5, 2014

  We are not promoting this video as an ad but simply a social awareness program. It hits home on the fact that Simple is Better doesn’t apply to just Business but even Lifestyles. A few simple things we do every day could mean the difference. https://www.youtube.com/channel/UCpfAIVLEdyTp-HoALoz-gRw

How would you get the most out of 10 Rs?

By | June 5, 2014

  Today, we were chatting about efficiency and how it is different from utilization and we thought we would conduct a poll about it. So here is the background. Utilization simply means consumption e.g. you can burn up 40 ltr of petrol every week but how efficient are you i.e. How much distance did you… Read More »

Part 3 of 4: Video on Difference between partitioning and just multiple FGs

By | June 3, 2014

  Sorry it took so long but here is the third video in our 4 part series on MS SQL Server partitioning. http://www.youtube.com/watch?v=GSNYGpNbidc I cover the difference between simple Files and Filegroups, show a real time example of proportional filling and the advantages good design has on DR.