SOLVED

Trouble refreshing SQL analysis services cube

%3CLINGO-SUB%20id%3D%22lingo-sub-1976628%22%20slang%3D%22en-US%22%3ETrouble%20refreshing%20SQL%20analysis%20services%20cube%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1976628%22%20slang%3D%22en-US%22%3E%3CP%3EI%C2%B4m%20having%20trouble%20with%20a%20file%20with%20a%20pivot%20connected%20to%20an%20analysis%20service%20cube.%20Before%20I%20installed%20the%20cube%20on%20my%20computer%20I%20could%20read%20the%20file%20and%20all%20it%C2%B4s%20contents%20just%20fine.%20But%20I%20got%20the%20cube%20installed%20in%20order%20to%20be%20able%20to%20refresh%20the%20file%20as%20well.%20However%20after%20installment%20all%20data%20is%20there%20when%20I%20open%20the%20file%20(as%20my%20colleagues%20have%20saved%20it)%20but%20then%20the%20data%20starts%20to%20refresh%20(automatically)%20and%20when%20it%20is%20finished%20all%20the%20data%20is%20gone%2C%20the%20cells%20are%20blank%20(although%20showing%20the%20formula%20if%20i%20mark%20one).%26nbsp%3B%3C%2FP%3E%3CP%3EI%C2%B4ve%20tried%20to%20reinstall%20the%20cube%2C%20thinking%20I%20did%20something%20wrong%20when%20installing%20it%20but%20that%20only%20resulted%20in%20me%20having%20two%20cubes%20installed%20(could%20not%20find%20them%20to%20remove%20one%20either).%20I%C2%B4m%20thinking%20that%20I%20have%20some%20faulty%20setting%20in%20Excel%20as%20the%20file%20reads%20fine%20for%20my%20colleagues%20who%20also%20installed%20the%20cube%20the%20same%20way%20as%20I.%20Does%20anyone%20have%20a%20suggestion%20or%20know%20what%20might%20be%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1976628%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2056272%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20refreshing%20SQL%20analysis%20services%20cube%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2056272%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20issue%20was%20resolved%20by%20my%20collegues%20at%20last.%20If%20anyone%20else%20have%20the%20same%2Fsimilar%20problems%20in%20the%20future%20I%20suggest%20trying%20to%20adjusting%20the%20language.%20In%20this%20case%20the%20pivot%20was%20created%20by%20someone%20who%20had%20English%20set%20as%20standard%20language%20for%20their%20Office%20package%20while%20I%20had%20it%20set%20for%20Swedish.%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20I%20think%20this%20is%20bug%20for%20programmers%20at%20Microsoft%20to%20look%20into%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I´m having trouble with a file with a pivot connected to an analysis service cube. Before I installed the cube on my computer I could read the file and all it´s contents just fine. But I got the cube installed in order to be able to refresh the file as well. However after installment all data is there when I open the file (as my colleagues have saved it) but then the data starts to refresh (automatically) and when it is finished all the data is gone, the cells are blank (although showing the formula if i mark one). 

I´ve tried to reinstall the cube, thinking I did something wrong when installing it but that only resulted in me having two cubes installed (could not find them to remove one either). I´m thinking that I have some faulty setting in Excel as the file reads fine for my colleagues who also installed the cube the same way as I. Does anyone have a suggestion or know what might be wrong?

1 Reply
best response confirmed by Pernilla123 (New Contributor)
Solution

This issue was resolved by my collegues at last. If anyone else have the same/similar problems in the future I suggest trying to adjusting the language. In this case the pivot was created by someone who had English set as standard language for their Office package while I had it set for Swedish. 

Also, I think this is bug for programmers at Microsoft to look into