question

AliceCosta-2596 avatar image
0 Votes"
AliceCosta-2596 asked azure-cxp-api action

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

not-supported
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Updating the right tag .

0 Votes 0 ·

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?

0 Votes 0 ·

0 Answers