Another try, MDX LinRegxxx in Foodsmart -
08-06-2003
, 04:55 PM
I must be missing something here... I'm trying to imitate
BOL examples and failing. Can anybody help me with why the
following produces errors?
with
member measures.myintercept
as 'linregintercept( lastperiods(9), measures.[store
sales] )'
member measures.myslope
as 'LinRegslope( LastPeriods(9), [Measures].[Store
Sales] )'
member measures.mytrend
as 'LinRegPoint( [Measures].[Store Sales], LastPeriods(9),
[Measures].[Store Sales] )'
select
{ [Measures].[Store Sales], measures.myintercept,
measures.mytrend, measures.myslope } on columns,
{ [Time].[1997].[Q1].[1] :[Time].[1998].[Q4].[12]} on
rows
from sales
Thanks in Advance!! |