Forum Discussion

anandgovindaraj's avatar
anandgovindaraj
Frequent Visitor
8 years ago

Dynamic MDX query

Hi!    I've got an SSAS Multidimensional Cube and I use the following MDX query to get data for a specific study portoflio - 18563.     SELECT NON EMPTY { [Measures].[Mean] } ON COLUMNS { ([Item ...
Need Help
anandgovindaraj's avatar
anandgovindaraj
Frequent Visitor
8 years ago

Thank you for your comments. 

 

The link to page where using R is a proposed solution is not working. Could you please repost the link ? 

 

Ideally, if Live Connection to Multi-dimensional Cube functionality is not limited (can't create measures etc)  I would be using that. Hopefully, live connections becomes more flexible.  

 

I think i might follow the tutorials by Guy in a Cube that you shared. Seems to be the closest solution to what I'm trying to do.  Although I'm running into 'string to numeric' conversion issues in the MDX query.  I created a new parameter 'StudyID' as shown below in the image. 

 

However, Im getting the following error when i replace the value 18563 in my original query to '&StudyID'. What will be the correct way to reference studyid parameter in the M query. 

 

 

 

 

Seward12533's avatar
Seward12533
Solution Sage
8 years ago
Try searching for this
“Passing-parameter-to-sql-from-dropdown-list-in-powerBI”

Use # before the parameter name.