Is it possible in Microsoft Excel 2016, by just using excel formulas, build a formula using the Cube formulas to lookup a value in a cube based on an input provided by the user.
For Example: Table in the Cube looks like this: enter image description here
I would like to be able to input the customer ID in Cell E1 and in F1 return the name of the customer who is related to that id, in this instance it would be Link.
I know I could use VBA, and VLookup's by bring in the pivot table, but I am trying to do this using CUBE formulas only. Is this possible?
=CUBEMEMBERPROPERTY("Cube Connection",CUBEMEMBER("Cube Connection","[Customer Table].[Customer ID].["&G8&"]"),"Customer Name")
The answer is the above excel function. Just be aware, that IT has to setup the cube properly. They need to setup the field as a property on the cube itself.
Here is also a working video of the CubeMemberProperty Function: https://www.youtube.com/watch?v=x9pcMa2GwJ8
