I have created an AS 2005 cube for my tester to access thru Excel 2007. He can connect to the cube fine, but can't read any measurement data elements from Excel. What Excel return is #N/A in the cell. I've checked many times the role that was setup to grant him permission to the cube. He should have all the rights to read data. In fact, the role setup was fine before I installed service pack 2. I wonder what's been changed in sp2. Any help would be great!
Mitch
It might be worth revisiting the "Cell Data" tab for the role, to ensure that none of the 3 "Enable .." options is checked.|||I wonder what the 3 "Enable..." options do in the "Cell Data" tab. I did unchecked the options and it works now.
No comments:
Post a Comment