Pivot Table error retreiving data from Cube

  • We have a dimension in a cube with 7 levels and levels are visible.

    In both Analysis Manager and MS Office Excel Add-in for SQL Server Analysis Services, were are able to see the last level. However, using Pivot Tables we are not and in the measures the Pivot Table will return N/A.

  • This was removed by the editor as SPAM

  • Apparently the problem is that Excel can only retrieve data for members names which the total length does not exceeds 256 characters .

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

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