DAXMD queries not working if the multidimensional models contains Data Mining Models by Gerhard Brueckl

Closed

as By Design Help for as By Design

Type:	Bug
ID:	775589
Opened:	1/2/2013 7:25:39 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

When a multidimensional model contains Data Mining Structures we get an error when we try to query this model using DAXMD saying that "The 'Customer Clusters ~MC-Cube' does not exist or has not been processed"

a similar MDX query returns the desired result on the same cube/model

if I remove all Mining Structures and related DSVs and Dimensions the query works as expected

Details (expand)

English

private build - 11.0.9000.5

Analysis Services

Windows 7 Enterprise (SP1)

German

Deploy AdventureWorks 2008R2 multidimensional model from Product Samples to "Power View for Multidimensional Models"
run any DAX query against the model

Error: The 'Customer Clusters ~MC-Cube' does not exist or has not been processed

If a MDX query works on a model/cube, also a DAXMD query should work

X64

0 attachments

Posted by Microsoft on 1/3/2013 at 2:22 PM

When there are multiple cubes in the database, the cube name needs to be specified in the connection string before sending DAX queries.
If using SSMS to send DAX queries, go to Menu item Query->Connection->Change Connection->Options->Additional Connection Parameters
and add Cube="Adventure Works" and re-connect. The DAX query should now work properly.
If you are using some Client API to connect, you need to specify the cube in the connection string.

Microsoft