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