Showing results for 
Search instead for 
Did you mean: 

CubeValue function not working in excel


I've been using a connections using analysis services and built a model using cubemember and cubevalue formulas. This model has been working just fine for the last year and suddenly this morning I tried refreshing and the cubevalue formulas won't return any values but rather just #N/A. The weird thing is that the cubemember are all appearing properly so I woudln't really know where to look. I broke links to other files and deleted any other connections within the workbook but I'm stuck and not sure what to do next. Any help would be much appreciated 😃




Status: New
Community Support

@rilimonv ,


It seems that this issue is more related to SSAS, I would suggest you post your issue to forum below:



Jimmy Tao