Mdx parameter which is not declared

Next, create a Dataset and for this example you can call it CategorySales this Dataset should use the Adventure Works cube data source. Select Query Designer and click the Design Mode button to begin writing your query. Use the following query to return back results without a parameter:. All this query did was returned back the total sales, but this is useless for a report by itself.

If we were to do this normally in MDX it would look something like this:. They not only want to see the list of product category sales, but they also want it made into a parameter so they can select from a dropdown box the category or categories they wish to view. To do this, first create the parameter by selecting the Query Parameters button. After you hit OK to confirm the Query Parameter screen you will need to modify your MDX to take advantage of the parameter you have created.

Here we use StrToSet to convert whatever is brought in from the parameter values selected by the end users to something MDX can understand. The Constrained flag here just ensures that parameter provides a member name in the set. Hit OK twice to confirm the query so far and make a simple tabular report to view your results so far.

You will notice that a dropdown box parameter was automatically created for the ProductCategory parameter we defined.

You may already be familiar with this if you have ever used the drag and drop interface for making parameters. Viewed 7k times. Improve this question. Add a comment. Active Oldest Votes.

Improve this answer. Manoj Attal 2, 3 3 gold badges 26 26 silver badges 31 31 bronze badges. Christopher Scott Christopher Scott 1, 1 1 gold badge 17 17 silver badges 21 21 bronze badges. I've declared the parameter in the Dataset Properties window, but I still having the same issue.

This fixed it for me and not only that, after I managed to refresh the fields I noted a field name was changed which solved another issue I was having.

This should be the answer. Is the parameter defined at the report level? That might be what's missing. Sign up or log in Sign up using Google. Sign up using Facebook. Two extra points I needed to resolve were:. I have a list of employee names in my parameter dropdown populated using a query.

I want to pass the parameter value selected by user to the main MDX query that pulls all the data points. Would you be able to plaease share step by step process with screenshots and syntex. Power BI. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Search instead for. Did you mean:. All forum topics Previous Topic Next Topic. Passing parameters to MDX source queries.

Something like I'm most interested in required settings on the parameter and any syntax requirements for the Query Refresh to detect and apply a defined Power BI parameter Thanks Solved!

Labels: Labels: Need Help. Message 1 of 5. Message 2 of 5. In response to v-shex-msft. Message 3 of 5. I'm not sure that the next workaround will be fine for your requirements.

We create an excel file in order to insert the filters values. For instance if you want to filter some years and we create a table into excel that contains that values.