CUBEMEMBER not returns #N/A for something that doesn't exists in the model

Alice Costa 1

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!!! Is there some cache that have impact in CUBE-FUNCTIONS? ![89889-tela-excel.png][1] [1]: /api/attachments/89889-tela-excel.png?platform=QnA

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-04-21T21:17:58.217+00:00

Updating the right tag .
Alice Costa 1 Reputation point

2021-04-29T10:02:14.867+00:00

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?