Hello All,
I seek to create a Cubeset of a department dimension. The Cubeset need be filtered by Company and a specified range of Departments.
Is the following MDX moving in the right direction? Regrettably I cannot post the workbook as it work-related (data sensitivity).
= Cubeset("Connection", "{Filter([Company].[Company].&CompanyA,
[Department].[Department Code].Members,
[Department Code].Membervalue >= "200" AND [Department Code].Membervalue <= "250")},
"Dept")
Am using Office 365.
Many thanks for your consideration.
Kind regards,
David
Hi David,
Have you seen this article about CUBE functions?
https://www.myonlinetraininghub.com/excel-cube-functions
You can find a few examples here:
http://paulrobertson14.blogspot.com/2013/04/cubevalue-and-cubemember-and-cubeset-oh.html
