How to define an Excel compliant format strings for a cube
User Rating: / 1
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:



Tags: article, excel

XL Cubed