DMX is the language used in Microsoft Analysis Services to implement data mining.
DMX is the language used by Microsoft Analysis Services to implement data mining. A tutorial can be found at https://msdn.microsoft.com/en-us/library/bb895168.aspx.
Questions tagged [dmx-ssas]
26 questions
0
votes
1 answer
Get currency format from Analysis Services cube
How can I get the format string for a currency value in analysis services?
When I run an MDX query to retrieve a measure with a type of Currency, the value is returned in the expected format e.g. €1.000,00. This is correct as my Cube's locale is set…
Ed Spencer
- 462
- 1
- 8
- 21
0
votes
1 answer
How to move a trained SSAS mining structure model to a different database?
I have many candidate models in my mining model development SSAS database which I would like to move to my production SSAS database, but there doesn't seem to be a way to do that for trained models without having to re-train the model once it is in…
Dusan
- 104
- 1
- 6
0
votes
1 answer
How to omit empty values from PredictTimeSeries DMX query
I'm using the PredictTimeSeries function within the DMX query in order to get some values predictions, as follows:
select flattened
PredictTimeSeries([MiningModel_8].[Values], 100)
from
[MiningModel_8]
It works well, the only problem is that at…
Ivan Sivak
- 7,178
- 3
- 36
- 42
0
votes
0 answers
DMX Sub Query Issue
I am trying to query the Mining Model I have created in SSAS. And my query is like this:
SELECT FLATTENED MODEL_NAME, NODE_UNIQUE_NAME,
[PARENT_UNIQUE_NAME], NODE_TYPE, NODE_DESCRIPTION, NODE_SUPPORT,
(SELECT ATTRIBUTE_VALUE, [SUPPORT]
…
Jana
- 137
- 2
- 11
0
votes
1 answer
SQL Server Time Series - a basic transformation
I'm using SQL Server 2008
I have a table MainTable with 3 columns Date, Parameter, Value.
Sample data:
Date Parameter Value
-------------+--------------+-------
01-Jan-2010 | Temperature | 30
01-Jan-2010 | SnowLevel | …
user2668470
- 301
- 1
- 10
0
votes
1 answer
Selecting external data source in DMX
Using Microsoft SSAS and SQLServer 2012 I am currently trying to update my timeseries model by using new values from my original source database table.
The Microsoft tutorials present for DMX suggesting using EXTEND_MODEL_CASES to update the model…
MSB
- 854
- 7
- 24
0
votes
1 answer
DMX processing Mining Structure Error
I have a problem while processing mining structure...
This is my Mining Structure
CREATE MINING
STRUCTURE [QUESTION1] (
[ownerReviewID] LONG KEY,
[makeName] TEXT DISCRETE,
[modelName] TEXT DISCRETE,
[price] LONG CONTINUOUS,
…
Tuzki
- 493
- 2
- 11
- 20
0
votes
0 answers
How to avoid NaN in a time series model
I build a time series model in microsoft analysis service 2008 r2. There is no problem to create the model and process. But when I make a pridiction query, there is NaN in the result. How can I avoid this? If there is no way to avoid the NaN, how…
0
votes
1 answer
Creating mining structures with DMX
I´m using Analysis Service to make some data mining work.
I already made the predictions with Sql Server Data Tools.
Now i wanted to make the same prediction with dmx.
I´m using the next dmx code:
CREATE MINING MODEL [Cassandra]
(
[CompanyNK]…
Helder
- 3
- 3
0
votes
2 answers
Given logistic regression coefficients computed in SSAS, create a formula to calculate a continuous output value
I've trained a simple logistic regression model in SSAS, using Gender and NIC as discrete input nodes (NIC is 0 for non-smoker, 1 for smoker) with Score (0-100) as a continuous output node.
I want to predict the score based on a new participant's…
hbeam
- 187
- 3
- 9
-1
votes
1 answer
Basket Analysis Error
INSERT INTO MINING STRUCTURE [Market Basket]
(
[OrderNumber],[Product] (SKIP, [Model])
)
SHAPE {
OPENQUERY([ContosoRetailDW],'SELECT OrderNumber
FROM V Online Sales Order ORDER BY OrderNumber')}
APPEND
(
…
arslan
- 45
- 2
- 2
- 6