Excel Cube formulas – use of wildcards

[sheldonperryParticipant Started: 1Replies: 0Total: 1]

Hi there,

I am hoping someone can assist me with the syntax on how to use wildcards in the Cubemember formula. In the following formula (in conjunction with Cubevalue) it retrieves the value of my accounting rollup code UN-SCH. I want to modify it to include all codes starting with “UN-” since that could give me a total value for our Unrestricted Fund for my P&L summary report. I have tried *UN-* since I read asterisks acted as wildcards, but that does not work. Here is my current formula (where TB15-16 is my table, Aud_FS_Cde is my field, UN-SCH is a rollup code in my Aud_FS_Cde field):

=CUBEMEMBER(“ThisWorkbookDataModel”,”[TB15-16].[Aud_FS_Cde].&[UN-SCH]”)
I’m thinking the wildcards need to be instead in the Cubevalue formula and perhaps a Cubeset needs to be part of the approach, and so syntax assistance in that regards would be helpful also .

Thanks for assistance with this,

Sheldon

[tomallanKeymaster Started: 0Replies: 417Total: 417]

Sheldon,

Here are some links of other that explored wildcards and cube formulas:

https://social.technet.microsoft.com/Forums/office/en-US/883daa92-000b-4db8-a9e4-ddb5c7bb1460/excel-cubeformulas-cubevalue-and-wildcard-strings-maybe-using-instr?forum=excel

http://www.excelguru.ca/forums/archive/index.php/t-1024.html

http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/cubemembercubevalue-parameter-values-eg-wildcard/9540b8b3-3182-e011-9b4b-68b599b31bf5

[Author]

Posts