DCSIMG
Filtering on a lookup attribute in Report Model - Ella Maschiach's BI Blog

Ella Maschiach's BI Blog

BI, Olap Technologies, Tools, System Analysis and Design

News

About Ella Maschiach

Business Inteligence

Filtering on a lookup attribute in Report Model

I've recently created a Report Model with a Lookup Entity in it. I saw to it that I had only one default detail attribute for it, and I gave that attribute a ValueSelection of list.
When I used the Report Model, I saw the attribute fine (as if it was inside the main Entity) but when I tried to filter on it I saw the Lookup Entity I was trying to hide and a filtered list. I couldn't understand why that was. I went back to check the attribute. Its ValueSelection was of type list. I went to the role that was created in the main Entity and set it's ValueSelection to list as well. That also didn't help. Finally, I went to look at the Lookup Entity that the attribute originated from. It had an InstanceSelection property of filtered list. Changing that to type of list did the trick.

Comments

Alexander Kleinwaechter said:

Hi Ella,

I like your Blog, because I stumble over exact the same issues within Reporting Services.

Now I have a problem with the Lookup Entity when the ID field in the main table is nullable. I can't filter the records of the main table with NULL values in the ID field when using a parameter in the filter. Do you know an easy solution?

Best regards

Alexander Kleinwaechter

Doctors without Borders

# April 14, 2009 4:18 PM

Ella Maschiach said:

Hi Alexander,

I admit I haven't tried to re-create your problem. Instead, I'd like to offer another approach. In my tables, if I need a fictitious ID for an entity, I usually use '-1' as that would never be an Identity Number for a worker (for instance). Perhaps it'd be possible to update the table accordingly? I'm sure Report Builder wouldn't have a problem with that sort of value.

Hope that helps,

Ella

# April 15, 2009 7:17 PM

Alexander Kleinwaechter said:

That does the trick! Thanks a lot!

Alex

# April 29, 2009 2:54 PM

Ella Maschiach said:

Glad I could help :)

# April 29, 2009 6:57 PM

Filtering on a lookup attribute in Report Model « A Blog for SQL Server Reporting Services (SSRS) Programmers said:

Pingback from  Filtering on a lookup attribute in Report Model « A Blog for SQL Server Reporting Services (SSRS) Programmers

# June 17, 2010 6:59 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 


Enter the numbers above: