calculated member Excel!Correl syntax -
05-12-2005
, 03:13 PM
I was trying to create a calculated member using the correlation
function Excel!CORREL, but I am getting the syntax wrong. Has anyone
done this before or any other excel function that requires an arraylist
for parameters?
I need to be able to put a list of members in the arraylist parameters,
but I was testing it while using integers, but I am doing something
wrong syntatically.
-This does not work-
with member [Measures].[mbrCorrel]
as 'Excel!CORREL({3,2,4},{9,7,12})'
select
{[Jan],[Feb],[Mar],[Apr],[May],[Jun],[Jul],[Aug],[Sep],[Oct],[Nov],[Dec]}
on columns,
{[Sales],[mbrCorrel]} on rows
from Basic
WHERE ([Scenario].[Actual],[Market].[New York],[Product].[100-10])
Thanks |