cancel
Showing results for 
Search instead for 
Did you mean: 

CubeValue function not working in excel

Hi!

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 😃

 

Thanks!

Ricardo

Status: New
Comments
v-yuta-msft
Community Support

@rilimonv ,

 

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

https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlanalysisservices

 

Regards,

Jimmy Tao