Home Dashboard Directory Help
Search

DAXMD Power View DCR: allow &rf filtering by Key and UniqueName better by GregGalloway


Status: 

Active


3
0
Sign in
to vote
Type: Suggestion
ID: 776347
Opened: 1/11/2013 9:49:47 AM
Access Restriction: Public
0
Workaround(s)
view

Description

Create a filter on the Calendar Year attribute in the Date dimension and filter it to CY 2003. Note the DAX query Power View generates filters by the key:

'Date'[Calendar Year.Key0] = 2003

Now if I want to change the filter value via the URL I must use the following syntax:
&rf=[Date].[Calendar Year] eq 'CY 2004'

Note that I have to filter by the attribute name, not the key. This makes it a bit challenging for other reports or dashboards or SSAS Report Actions to link to a Power View report and set the filter appropriately.

With the above &rf filter, the DAX query generated by Power View filters by name. That may be a problem if name isn't unique:

'Date'[Calendar Year] = "CY 2004"

If I decide to have &rf filter by key using this syntax:
&rf=[Date].[Calendar Year.Key0] eq 2004

Then Power View shows a new Calendar_Year_Key0 filter (additional to the existing Calendar Year filter). But because the existing Calendar Year filter is set to 2003 and I set Calendar_Year_Key0 to 2004, I get no data in the report.
Details
Sign in to post a comment.
Posted by Jon Capezzuto on 1/29/2013 at 5:42 AM
Can you provide more information on the ability to pass report filter values to Power View via URL? Is this feature available in SQL 2012 SP1? Any doc or tips would be appreciated. I agree with your comments on allowing key values to be passed in addition to (or instead of) attribute names.
Sign in to post a workaround.