0

Hi I was wondering if there was a way to apply two conditions to an Excel 365 CubeMember function.

I currently have an old query that was poorly written and fails when when there are two sub account names that are the same. I would like to add the parent account ID to the condition as well as the sub account name and return the sub account ID.

The parent accent lives in the ACCOUNT table with ACCOUNT HCC ID being the parent account ID. B9 holds the sub account name

Current Code:

=IFERROR(CubeMember("CubeName","exists([Sub Account].[SUB ACCOUNT HCC ID].Children,[SUB ACCOUNT].SUB ACCOUNT NAME].["&$B9&"])","")

Eagle1
  • 13
  • 4
  • Would something like this help? CUBEMEMBER("CorrelationCube",{"[Curve].[Curve Name].[Brent]","[Terms].[Term Name].[M+1]"}) – JB-007 Jun 10 '21 at 23:20
  • https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_winother-mso_2010/cubemember-multiple-filters-set-dynamically/2f9ad8be-1d18-4c76-89a5-32348eea7ef3 – JB-007 Jun 10 '21 at 23:21
  • helloooo? _______ – JB-007 Jun 13 '21 at 17:30

0 Answers0