Hello all, I have a snowflake di

[Rodiggy]

Hello all,

I have a snowflake dimension, 4 levels
1. Region (table1)
2. Building (table2)
3. Group (table2)
4. Name (table2)

Most records are unique but sometimes there are duplicates. What's happening is when there are dups the data is getting double counted in my cube. Basically I just want my dimension to ignore the duplicates in my tables. Is there something I can filter with to accomplish this.

(Unfortunately I cannot change the way the tables are set up)

Thanks,
Roland Whitmyre

 

[issahar]

You can use view as data source for your dimension and in this view you will care about distinct rows, e.g.

CREATE VIEW dbo.VIEW1
AS
SELECT distinct Units.SectionName, Units.UnitName
FROM Units, Sections
WHERE Units.SectionName = Sections.SectionName

and base your dimension on this view and not on the snowflaked tables...

please, notify me if it was helpful for you...
Issahar
senior software engineer

http://www.softwatch.com

Israel

 

[Guest_imported]

Thanks a lot. That worked perfectly.

Roland