Welcome to Salvo(z)

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).

I created a PowerShell script that runs as the first step in a SQL Server Agent Job.  The script checks for the existence of some files and sends an email and throws an exception to terminate the job if any of the files do not exist.  An example of the code is included below.

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.

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 alternative to measure expressions, the currency conversion may be implemented in the cube’s MDX script. 

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 ETL is only feasible when the source currency will be converted to one or two target/destination currencies.  If your business requirements dictate that users need the ability to select from a large set of target currencies, then you will likely need to implement currency conversion in the cube.