CubeValue function not working in excel

[rilimonv]

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

[v-yuta-msft]

@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