CODEWITHSUNDEEP
ssasmdxbusiness-intelligencedashboarddatazen-server
kparkin
kparkin

Reputation: 345

Data view with parameters in Datazen

I am designing a dashboard with Datazen. I need to define data view with parameters. Where statement of mdx query as follows

where (
 STRTOMEMBER("[X].[X NAME].[" + {{ @XParam }} + "]"), 
 STRTOMEMBER("[Y].[Y NAME].[" + {{ @YParam}} + "]")
)

and I defined @XParam and @YParam. My query works when I go next step and get result as expected. But problem occurs when data view added from Datazen Designer to build charts. How can I solve this problem?

Exception: System.ArgumentException: Value does not fall within the expected range. at Windows.UI.Xaml.Data.Binding.put_Path(PropertyPath value) at ComponentArt.WinRT.DataVisualization.DataGrids.GridView.GenerateColumn(String name, String bindingPath, Type type)

Upvotes: 0

Views: 1402

Answers (1)

lachicazul
lachicazul

Reputation: 103

Try this:

where (
 STRTOMEMBER("[X].[X NAME].[" + '{{ @XParam }}' + "]"), 
 STRTOMEMBER("[Y].[Y NAME].[" + '{{ @YParam }}' + "]")
)

You missed single quotes and the last space in the second param.

Upvotes: 1

Related Questions