April 25, 2005 at 7:32 am
Hello!
I have pivot tables in Excel witch uses cubes in Analysis Services as data source. In some cells I don't get any figures for the measures. What I get is "#Saknas!" (Swedish so I guess if one have an English version it would be "#Missing!". But when I look in the cube there are values in those cells.
Has anyone had this problem and knows how to solve it?
I have:
Windows 2000 professional
Excel 2000
SP-3
Microsoft OLE DB provider for OLAP services 8.0
SQL-server 2000
Thanks in advance
//Boson
April 26, 2005 at 8:43 am
I tried pivot tables in Excel which uses cubes in Analysis Services as data source,but i was able to see the values of each measure in excel cell.
My configuration is
Windows XP professional
Excel 2003
Microsoft OLE DB provider for OLAP services 8.0.760
SQL-server 2000
I have installed SP-3 for sql server 2000.
According to me you should
1. Change/check the format of measure in analysis services.
If you still have proble then
2. install SP-3 for sql server 2000,this really helps.
and last option is install excel 2003.
HTH
April 26, 2005 at 2:48 pm
Instead of #Missing, could the word translate as #Value. If so, then check the data type of values such as trying to sum Strings and numbers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply