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