Hi All,

I'm facing a strange issue with SSAS DSV. In my DSV i have a FACT Table which is a named query. I copies this query and executed in SSMS against the Source database and i can see the record. When i look up the same record in SSAS DSV its missing. I reprocessed the cube many times and still the record is missing. Any ideas? Please advice.

Thanks

Hi thinkingeye,

Since you have tested the query in SSMS, there should be no issue on metadata and records. In Analysis Services, when you modify the DSV, you need to refresh it. SSAS will detect the changes and make them work.

Re