DCSIMG
Report Model,Lookup - Ella Maschiach's BI Blog

Ella Maschiach's BI Blog

BI, Olap Technologies, Tools, System Analysis and Design

News

About Ella Maschiach

Business Inteligence

Browse by Tags

All Tags » Report Model » Lookup (RSS)
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 Lookup Entity and the Friendly Name in the Report Builder
Did you, just like me, define a Lookup Entity in your Report Model? And did you, just like me, define friendly names in your Report Model's DSV? If you have, then you may have come across a problem similar to mine… So how did we get there? First and foremost, when you click the relevant tables and columns in your Report Model's DSV, you defined a FriendlyName property for them. That way, when you generate a Report Model based on the DSV with the friendly names, you get the Model with the...