Excel Macro Funtion DBProportionalSpread not found

Post Reply
burrito
Posts: 1
Joined: Wed Nov 16, 2011 6:07 am
OLAP Product: TM1 Cognos Express
Version: 9.5
Excel Version: 2007

Excel Macro Funtion DBProportionalSpread not found

Post by burrito »

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?
DHiggins
Posts: 3
Joined: Fri May 23, 2008 9:59 pm

Re: Excel Macro Funtion DBProportionalSpread not found

Post by DHiggins »

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.
Post Reply