Search

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

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)
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 (expand)

Product Language

English

Category

Reporting Services

Proposed Solution

Two suggestions:

1. Allow me to filter by key or name when I use &rf. If I filter by key, then don't add a second filter if the attribute is already in the filters. Make sure I can filter by composite keys.

2. Allow me to filter by UniqueName such as &rf=[Date].[Calendar Year.UniqueName] eq '[Date].[Calendar Year].&[2004]'.

The second suggestion would need to have &[2004] properly URL encoded, obviously. And the second suggestion is dependent on every attribute having a UniqueName (which is a separate DCR I filed: https://connect.microsoft.com/SQLServer/feedback/details/775973/daxmd-dcr-every-attribute-should-have-uniquename-property )

Primary Benefit

Improved Reliability

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
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.