The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually a hard drive connected to the underlying physical hardware, so it should offer better performance then the persisted data and OS disks. The persisted disks are located on Azure Blob… Read more
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming year. I hope to generate momentum in fall and winter and get a good start on this list:
- Write three blog posts per month
- Participate in TSQLTuesday and Meme15…
Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended to write a book review for quite awhile and thought I’d start off with this book for several reasons:
It can easily be read from cover-to-cover. This book is organized…
This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started working as a Business Intelligence developer at Trek Bikes. Working at Trek has been a great experience and I feel very fortunate to have the opportunity, so I thought I’d… Read more
Today is T-SQL Tuesday #33 hosted by Mike Fal. The topic is SQL Server – Trick Shots. This assignment involves blogging about a cool process or trick you implemented that is related to SQL Server and the lessons or insight gained from the experience. As a BI developer, I… Read more
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for a little over a year and work with the Microsoft BI tools: SSIS, SSAS and SSRS. The BI team at Trek consists of 4 analysts (2 in US, 1… Read more
I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write a blog post! I’ve been working with MDX quite a bit recently and thought I’d share a few more bits of knowledge I’ve acquired….
I recently received a request to… Read more
I recently encountered a business scenario involving calculated members in a cube that I thought is worth sharing.
We have a cube with the following measures: Shipped Quantity, Forecast Quantity, and ABS Variance to Forecast.
ABS Variance to Forecast is a calculated member in the cube, the MDX is pretty… Read more
One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error. The error message is similar to the following:
<Warning WarningCode=”1092550658″ Description=”Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: ‘dbo_DimClaim’, Column: ‘ClaimCanceledReasonCode’, Value: ”. The attribute… Read more
My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the GUI interface in SQL Server Management Studio (SSMS).
To process all dimensions:
1. Connect to an SSAS instance in SSMS.
2. Expand the appropriate node / cube.
3. Select ‘Dimensions’… Read more
The SSIS script component can be configured to use synchronous or asynchronous outputs. If the script component is configured for synchronous outputs, then each input row is processed as it passes through the component. Asynchronous outputs can be configured to wait until multiple input rows have been received before processing. Read more
In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS. I recently attempted to implement currency conversion for some inventory measures and discovered a limitation with measure expressions – they do not work for measures with a ‘Last non-empty value’ aggregation. As an… Read more
Currency conversions can be implemented several ways as part of a business intelligence solution. In some scenarios it may be preferable to implement the conversion in the ETL, while in other scenarios it might make more sense to implement the conversion in the cube itself. Implementing currency conversion in the… Read more