Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Missing data from dimensions Expand / Collapse
Author
Message
Posted Friday, August 10, 2012 8:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 11:08 AM
Points: 11, Visits: 83
I have a DSV with a filter. when I process that particular dimension, not all the rows are read from the underlying table. The underlying database has 300,000 odd rows and only 200,000 rows are read into the dimension. Can somebody tell me what the problem is? What should I do to avoid this?
Post #1343444
Posted Monday, August 13, 2012 10:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
Check the filter. If you are filtering out records from the underlying database, then you would not see all records in the dsv. I must be missing something because it sounds like it is working as it should?
Post #1344294
Posted Wednesday, September 5, 2012 11:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 11:08 AM
Points: 11, Visits: 83
The problem was not with the filter but a problem with the network tokens. Thank you for your suggestion SSC Veteran.
Post #1354779
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse