Top Vendor by YTD Purchases Report throws Object reference not set to an instance of an object.

Hi Folks,

Users get Object reference not set to an instance of an object error message when runs below reports. All these reports based out of BI cubes. Please let me know if you can share your thoughts to resolve this . Thank you.

Top Vendor by YTD Purchases

Purchases in the past period

Cube is working fine but when run the report throws error message. Did full compilation after clearing files in XPPIL directory.

Thanks,

Maru

Are you sure the cubes is working fine? Can you list out how you tested it? I would say to try to go to “Tools → Business Intelligence(BI) Tools → SQL Server Analysis Services project wizard” and let it to process /deploy the cubes again.