cubeset and cubemember functions

[martingaleh]

This worked:
=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of newrev]","[public dates_d].[moy].["&M$22&"]","[model].[type].&[Technology]",
CUBESET(
"ThisWorkbookDataModel",(
D24,
D25)
)
)

where d24 and d25 are cubemember functions. Pasting them in didn't work:
=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of newrev]","[public dates_d].[moy].["&M$22&"]","[model].[type].&[Technology]",
CUBESET(
"ThisWorkbookDataModel",(
CUBEMEMBER("ThisWorkbookDataModel","[model].[opp_type].&[gte]"),
CUBEMEMBER("ThisWorkbookDataModel","[model].[opp_type].&[cr]"))
)
)

this didn't either...
CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of newrev]","[public dates_d].[moy].["&M$22&"]","[model].[type].&[Technology]",
"{([model].[opp_type].[Change Request]),([model].[opp_type].[GTE])}")


Is there some other syntax?

 

[JV0710]

Hello

Try

=CUBEVALUE("ThisWorkbookDataModel","[model].[opp_type].[Change Request]","[model].[opp_type].[GTE]","[model].[type].&[Technology]","[public dates_d].[moy].["&M$22&"]","[Measures].[Sum of newrev]")

or . . .
in Cell D26 make a cubeset that is : =CUBESET("ThisWorkbookDataModel","{[model].[opp_type].&[gte],[model].[opp_type].&[cr]}","model_opp_types")

and then your final formula could be: =CUBEVALUE("ThisWorkbookDataModel",D26,"[model].[type].&[Technology]","[public dates_d].[moy].["&M$22&"]","[Measures].[Sum of newrev]")

 

[martingaleh]

This worked. Fantastic

 

[JV0710]

Glad it worked for you

Joe