Forum Discussion
CUBEMEMBER not returns #N/A for something that doesn't exists in the model
I created a Pivot Table by getting data from Azure Analysis Services. When I write a CUBEMEMBER with anything that doesn't exist in the tabular model, like "anything": =CUBEMEMBER("PRD-EDPModel"; "...
Do you mean it returns "CESE" in second case after refresh?
Hello SergeiBaklan !
No, I mean that I make the 3 queries on the same sheet after getting data from Azure Analysis Services, so the data are refreshed, without the "Personnel Costs Adjustments" value:
=CUBEMEMBER("PRD-EDPModel"; "[FCT_FIN_CONSOLIDATED].[NM_REPORTED_RECURRENT].&[Personnel Costs Adjustments]") that doesn't exist on the tabular model, it returns "CESE", not "#N/A".