T-SQL Tuesday: A Day in the Life of a BI Developer

• by Jennifer-Salvo

• Salvo(z) SQL

My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles.  I’ve been a BI developer for...

2012-07-17

620 reads

MDX ClosingPeriod and PeriodsToDate

• by Jennifer-Salvo

• Salvo(z) SQL

I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write...

2012-07-07

1,157 reads

MDX ‘Is’ Operator

• by Jennifer-Salvo

• Salvo(z) SQL

I recently encountered a business scenario involving calculated members in a cube that I thought is worth sharing.
We have a...

2012-07-04

813 reads

SSAS: Duplicate Attribute Key Error

• by Jennifer-Salvo

• Salvo(z) SQL

One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error.  The error message...

2012-05-07

1,319 reads

SSAS: Processing Cube Dimensions and Measures in SSMS

• by Jennifer-Salvo

• Salvo(z) SQL

My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the...

2012-04-02

3,094 reads

SSIS: Script Component Asynchronous Transformation

• by Jennifer-Salvo

• Salvo(z) SQL

The SSIS script component can be configured to use synchronous or asynchronous outputs.  If the script component is configured for...

2012-03-20

6,679 reads

SSAS: Currency Conversion in MDX Script

• by Jennifer-Salvo

• Salvo(z) SQL

In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS.    I recently attempted...

2012-02-09

909 reads

SSAS: Currency Conversion Using Measure Expressions

• by Jennifer-Salvo

• Salvo(z) SQL

Currency conversions can be implemented several ways as part of a business intelligence solution.  In some scenarios it may be...

2012-02-01

4,881 reads