|How to define an Excel compliant format strings for a cube|
|Written by Hilmar Buchta|
|Monday, 16 November 2009 12:05|
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: