TM1 Forum

Posted: **Wed Nov 16, 2011 6:12 am**

Hi

I have a Excel Worksheet and wants a value splash.
In documentation on ibm i found the macro DBProportionalSpread.

But when i run the macro, comes an error: function not found.
Such as the function E_Pick ist can use.

Code: Select all

DBProportionalSpread( value, server:cube, e1, e2, e3..., e16 )

Can you help me?

Posted: **Wed Nov 16, 2011 9:38 pm**

It does not work in Excel 2007 (2010?) and is a know bug in 9.5.0, 9.5.1 and 9.5.2. It works fine with Excel 2003. I submitted a bug ticket to IBM over a year and a half ago now and they still have not fixed this. It was supposed to be fixed with the "next" service pack. Very aggravating.

TM1 Forum

Excel Macro Funtion DBProportionalSpread not found

Excel Macro Funtion DBProportionalSpread not found

Re: Excel Macro Funtion DBProportionalSpread not found