Archives
-
Analysis Services Translations in Performance Point Services (SharePoint 2010)
Last week I had to build some PPS Dashboards in an existing SharePoint 2010 environment. One of the requirements for the dashboards was to support English, Dutch and French. Because the data was loaded from an Analysis Services Cube, I added the extra required translations to the Analysis Services Project: Dutch-Belgium and French-Belgium. The SharePoint [...]
-
XMLA script to deploy MDX Calculations
At a current project I needed to create a deploy script for the MDX calculations of a cube. SQL Server Management Studio makes it very easy for you to create XMLA-scripts to create or alter cubes, dimensions, etc… But it’s not possible to use Management Studio to create an alter-script that only contains the MDX [...]
-
Parent-Child hierarchies in Reporting Services
Reporting Services 2008 is a great reporting tool, but displaying Analysis Services data with Reporting Services doesn’t always display the data as you would expect. A Parent-child hierarchy is one example of this: When you browse Parent-child hierarchy from an Analysis Services cube with Excel, Excel automatically displays it with nice drill-down functionality. But when [...]
-
SSAS: Custom format string for “duration” using MDX
I recently struggled with the following challenge in Analysis Services: In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″. bing brought me to the following great article, where Mosha [...]
Dec 7th, 2009 | Filed under Analysis Services, BI, Excel, MDX, SQL 2008 R2, SQL Server, SQLServerPedia -
OLAP Reporting with Excel 2007: Use Member Properties!!
Excel 2007 is great tool for browsing OLAP cubes. But 1 thing a lot of people don’t know about or at least don’t use enough, is Member Properties. When they want to add a property of a specific attribute, they just check this item in the field list. By using it this way, you’re kind [...]
-
Configuring Reporting Service to use Host Headers for the Report Manager Website
Ever tried to change the URL of the Report Manager in IIS using host headers? I did, but got the following error message when I tried to open the Report Manager: “The request failed with HTTP status 400: Bad Request”
Tags: data, Reporting Services -
Import Excel files with SQL Server Integration Services on a 64-bit server
Today I deployed some SSIS packages to a test environment. These packages needed to import some excel files to a certain database. Testing the packages resulted in the following error: Error 0xc0202009: {F1B3B35C-FAE3-48F6-A169-4E4D8D99F9B6}: An OLE DB error has occurred. Error code: 0×80004005. An OLE DB record is available. Source: “Microsoft JET Database Engine” Hresult: 0×80004005 [...]
-
Embedded Code in SQL Server Reporting Services
Sometimes it might be necessary to use the same expression on different places throughout a report. You can of course just copy and paste the expression every time you need it, but if you’ll ever need to change this expression, you will have to change it for every field you’re using it for. Therefore it’s good [...]