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"; "[FCT_FIN_CONSOLIDATED].[NM_REPORTED_RECURRENT].&[anything]") it returns #N/A
when I write something that exist in the tabular model it returns the value:
=CUBEMEMBER("PRD-EDPModel"; "[FCT_FIN_CONSOLIDATED].[NM_REPORTED_RECURRENT].&[CESE]") it returns "CESE"
But when I write something that already existed in the past, but now doesn't exist anymore in the tabular model, it returns the "CESE"!!
=CUBEMEMBER("PRD-EDPModel"; "[FCT_FIN_CONSOLIDATED].[NM_REPORTED_RECURRENT].&[Personnel Costs Adjustments]")
It must returns "#N/A" as well!!
3 Replies
- I notice that if I change & to ALL it works, but I didn't understand the logic
=CUBEMEMBER("EDPModel"; "[FCT_FIN_CONSOLIDATED].[NM_REPORTED_RECURRENT].[ALL].[Personnel Costs Adjustments]")
I would like to understand cause I need to justify this change that my customer must to do.
Anyone? 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".
