Category Archives: Business Intelligence

SSRS, SSAS, SSIS and their reporting tools

Creating a C# User Defined Function in Excel that Communicates with a WCF Service

Here is the business case: Your accounting staff wishes to query some figures from the financial system in Excel. To prevent a litany of copying and pasting, creating custom analysis services cubes, or taking the rather drastic measure of granting … Continue reading

Posted in Business Intelligence, Windows Apps | Leave a comment

SSAS Calculated Member Based on Dimension Attribute

Creating a calculated member is a great way to add functionality to your cube. Most times calculated members are based entirely off values in your fact table, but every so often you need to pull a figure from a dimension. … Continue reading

Posted in Business Intelligence | 3 Comments

Excel 2007 vs 2010 SSAS Cube Functions

Sometimes a function that works perfectly fine in one environment totally fails in another. I was recently building a complex set of cube reports in Excel that caused me no end of grief. By complex I mean using a formula … Continue reading

Posted in Business Intelligence | Leave a comment

SSRS Permissions

So you have just done a fresh install of SSRS 2008 R2. When you try to browse to http://yourServerName/reports you recieve this following message: “YourUserName does not have the required permissions. Verify that sufficient permissions have been granted and Windows … Continue reading

Posted in Business Intelligence | Leave a comment

AX, Enums, and Reporting

The official Microsoft line on accessing the AX database directly via SQL is: don’t do it. To reporting into SSRS you are supposed to use the AX addin with VS 2010, use AOT objects and publish from there. If however … Continue reading

Posted in Business Intelligence, Dynamics AX | 1 Comment

Sum the Last 30, 60, or 90 Days

A common theme with reporting is to consolidate figures over period ranges. Quite often this is done for year to date, but it is common enough to want to see the last 30, 60, or 90 days from a particular … Continue reading

Posted in Business Intelligence | Leave a comment

Finding SQL Schema Objects

Schemas are an excellent way to group customised objects together in a SQL database. To find schema objects in a database either for documentation or backup, a SQL query can be run to extract this information.

Posted in Business Intelligence | Leave a comment