Apr 20 2021 10:58 AM - edited Apr 20 2021 01:31 PM
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!!
Apr 20 2021 12:30 PM
Do you mean it returns "CESE" in second case after refresh?
Apr 20 2021 01:27 PM - edited Apr 20 2021 01:40 PM
Hello @Sergei Baklan !
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".
Apr 29 2021 02:59 AM