Creating Forecast Using DMX
- From: "Achim" <google@xxxxxxxxxxxxxxxxxxxxx>
- Date: 12 Feb 2007 08:09:09 -0800
Hi,
i've started to deal with dmx some days ago, now I have a problem a
can't solve, maybe someone can help:
I want to create a forecast using a model. The model is based on
warehouse data and it works pretty good. Because of an connection to
Reporting i have to use DMX, to get the wanted data out of the model.
The model contains data of several years, the key is the timeID used
in my relational model. In the Report I don't want to print out the
timeID, but the corresponding month-Number. For that reason I've
extended my dmx-select Query to get the month, but the result shows
always the same month. I don't understand this result, because the
timeID is ascending as well for each row of the result set
TimeID predictValue Month
1 100 1
2 200 1
3 300 1
Query : SELECT
FLATTENED [VDM Org Dst 1].[Org Id],
(SELECT predictTimeSeries([Sum Bruttolohn],4), monat FROM [VDM Org
Dst 1].[VFC Sum Org])
From
[VDM Org Dst 1]
where [VDM Org Dst 1].[Org Id]=536
Can someone help ? Do I use the wrong query ?
Thanks in advance!
Achim
.
- Prev by Date: Question about decision tree algorithm in sqlserver2000
- Next by Date: Data Mining Specialist needed in Tampa, Florida
- Previous by thread: Question about decision tree algorithm in sqlserver2000
- Next by thread: Data Mining Specialist needed in Tampa, Florida
- Index(es):
Relevant Pages
|
