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