Forum Discussion
aliceaguiaraac
Apr 20, 2021Copper Contributor
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"; "...
aliceaguiaraac2365
Apr 29, 2021Copper Contributor
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?
=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?