How to define an Excel compliant format strings for a cube
Cube defined formats are not necessarily displayed properly in Excel 2007. Sometimes the format seems to be ignored completely although it is working fine in the cube browser.
For a simple example I created a cube based in the following source table which acts as dimension and fact at the same time:
Tags: excel