Stack Overflow
Stack Overflow

Questions tagged [dmx-ssas]

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.

26 questions
3
votes
1 answer

How to deal with max string length of 255 in SSAS DMV metadata

I'm trying to import SSAS DMV metadata into SQL Server using a data flow in SSIS. In this example, I'm attempting to import data from the $SYSTEM.TMSCHEMA_PARTITIONS DMV. My select statement (which looks like SQL but is not SQL),…
Jonathan Garvey
  • 115
  • 2
  • 9
3
votes
0 answers

how to join two columns side by side in MDX in SSAS

I have a query where it will give Schema Columns of the table. Select level_caption from $system.MDSchema_levels Where [Cube_name] = 'Quote' AND [Dimension_Unique_name]= [QUOTE TABLE NAME] AND NOT[LEVEL_IS_VISIBLE] Select level_caption from…
mohan111
  • 8,633
  • 4
  • 28
  • 55
3
votes
1 answer

How to use DMX query by ADOMD.NET

I have built a Analysis Services and apply Data Mining by Bussness Intelligent Development Studio. Now i have a prediction query as the follows: SELECT PredictAssociation([Association].[v User Subscribe Product], INCLUDE_STATISTICS, 3) From …
Jonny Vu
  • 1,420
  • 2
  • 13
  • 32
2
votes
1 answer

Get Data Mining models name from server by DMX

Does somebody know if there is a way to get the models names from the server by executing script (DMX)
msidne
  • 21
  • 3
2
votes
0 answers

Error when adding Analysis Services Data Source View from c# code

I want to create an Analysis Services database, datasource and datasource view from c# code. Everything seems to be working fine until I add a mining structure and models and try to process the structure, then i get the following error: Errors in…
cmperezg
  • 145
  • 11
1
vote
0 answers

PredictSequence DMX query cannot be used in context

I am new to SQL Server and Data Mining strategies, so I use the AdventureWorks learning dataset provided by Microsoft in order to experiment mining models and queries. I try to write a DMX Query on a Clustering Mining Model. However I keep getting…
student0495
  • 171
  • 3
  • 15
1
vote
0 answers

query SSAS to find if table is used in cubes

I have an SSAS instance with a number of databases containing cubes. I need to check if given tables/dimensions are used in the cubes.Maybe this could do the job SELECT [CATALOG_NAME] as [DATABASE], CUBE_NAME AS [CUBE],DIMENSION_CAPTION AS…
Bonzay
  • 740
  • 2
  • 10
  • 29
1
vote
0 answers

TimeSeries prediction gets it wrong on standard Sinus-curve

I'm trying out SSAS DAX Time Prediction-modeling in MSSQL 2012, but the forecasts do not match my expectation. The input data is a perfect Sinus curve, about 300 datapoints with five repetitions . The data is loaded in the mining structure and…
Gerrit
  • 1,579
  • 5
  • 16
  • 23
1
vote
0 answers

Selecting from a specific SSAS Database

I'm trying to set up a prediction service for my database, I'm using OPENQUERY to ask the SSAS for predictions on my datasets. So far everything has worked fine but when I tried to scale the service I ran into some problems. My MSSQL database server…
MSB
  • 854
  • 7
  • 24
1
vote
0 answers

Programmatically training SSAS data models

I am a T-SQL programmer and would like to create and train a model in my SQL Server SSAS data mining structure in a T-SQL stored procedure. I know that I can pass in SELECT DMX queries through linked server (OPENQUERY) but how can I use the DMX…
Dusan
  • 104
  • 1
  • 6
0
votes
1 answer

Prediction with a Nested Table and DMX

I'm having some trouble generating the proper SQL/DMX in order to do prediction in SQL Server 2008 Business Intelligence Development Studio. I've got the following table setup with training data. Transactions ID (int)(primary key) Code…
mj_
  • 6,297
  • 7
  • 40
  • 80
0
votes
1 answer

Microsoft Decision Trees: support cases for a specific node

I'm using Microsoft Decision Trees in Microsoft Analysis Services Data Mining, and need to show the historical data (the support cases from the training data used to train the decision tree) for a given leaf node in my mining model. Is there a way…
Joel C
  • 5,547
  • 1
  • 21
  • 31
0
votes
1 answer

How to get a list of partition inside a MeasuresGroup

Is there any way to get a list of partitions inside a MeasuresGroup ? And how can I process them with specific conditions on there name ? Thanks for your help.
Hamza Lahbabi
  • 29
  • 1
  • 9
0
votes
1 answer

How to filter SSAS catalog list?

I use DMX query like this SELECT * FROM $SYSTEM.DBSCHEMA_CATALOGS which retrieves list of OLAP DBs. I would like to add a where clause to select catalogs where name contains some sequence of chars, e.g., SELECT * FROM…
Janis S.
  • 2,526
  • 22
  • 32
0
votes
2 answers

MDX example in VB.NET

I have a chunk of MDX that I'd like to throw into an ASP.NET form. Hopefully just binding the results to a gridview. Are there any good links or snippets? I'm using VB.NET, but I am able to port from C# if no Visual Basic code is available.
madcolor
  • 8,105
  • 11
  • 51
  • 74
1
2