Missing data from dimensions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Missing data from dimensions

Missing data from dimensions

Rate Topic

Display Mode

Topic Options

Author

Message

sriramkrishnan

Posted Friday, August 10, 2012 8:31 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 09, 2013 7:18 AM
Points: 11, Visits: 77

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

herladygeekedness

Posted Monday, August 13, 2012 10:42 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:46 AM
Points: 240, Visits: 653

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

sriramkrishnan

Posted Wednesday, September 05, 2012 11:29 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 09, 2013 7:18 AM
Points: 11, Visits: 77

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 »

Permissions