Home Dashboard Directory Help
Search

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


Status: 

Closed
 as By Design Help for as By Design


1
1
Sign in
to vote
Type: Bug
ID: 775589
Opened: 1/2/2013 7:25:39 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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
Sign in to post a comment.
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.
Sign in to post a workaround.