Provide calculated member values for Chart data in a SSRS report based on SSAS cube

We created the chart in a SSRS report based on SSAS cube.
When we clicked on one of the areas in the chart, we were invoking the same report but were unable to pass proper values – [Dim Abc].[Attribute Xyz].&[Value1].

The key is to create a “calculated member“.
In dataset Query Designer, right click on “Calculated Members” pane and select “New Calculated Member”.
The expression to use is:
MEMBERTOSTR([Dim Abc].[Attribute Xyz]).
Add this newly created Calculated Member in the result of the datasets by drag and dropping.

Use the above created field for Chart data (in our case Category Groups).

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s