Data doesn't appear in Pivot tables

  • I have created a new analysis services cube using visual studio on 2005. I can process and browse the cube without any issues in analysis services but when I try and browse the cube using an excel pivot table I just get #N/A as the values in all of the cells. Has anyone come across this before please? Not sure if you need further info, but please ask if I'm missing out on giving you enough before you can help. Thanks.

  • This is now fixed. It was simply a permissions issue. Once the role was modified to allow the correct permissions on the cube the data was visible in the pivot table and the N/A# entries disappeared. Oops 😛

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply