I have a strange problem. For Analysis services deployed in three environments. I have problem only with data in Production, one of the site is missing in Production, but the same site is present in Development and QA environment. I have already verified
1) Site is present in Physical Table
2) Verified SQL Statement thats generated while processing dimension: Data is retrieved from physical table using this query.
3) Have already done full processing of Dimension.
4) I have even check DSV table and see data.
5) Corresponding data is present in Fact
For Example if I am looking for Site Number: 123456, this site is present in Development and QA. But missing in Production. By the way, structure, and data of Development, QA and Production is same. It would have made sense for any issues or problem if this
site is missing in all the environments, but thats not the fact.
Any help or suggestion is deeply appreciated.
Thanks in advance,
View Complete Post