Archives
-
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 -
Excel Services: Data Refresh Failed
After deploying an Excel file to Excel Services on a new MOSS Server I got the following error: Data Refresh Failed: Unable to retrieve external data for the following connections: <<connection>> The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the [...]
-
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 [...]
-
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 [...]