Hello everybody,
I'm using a lot cube formulas to build my reports and now i try to insert mdx functions inside to improve powerfull.
These functions are always used against a PowerPivot model (tabular).
CUBESET with TOPCOUNT, FILTER... are working well.
I also use CUBESET with EXISTS and it works well with 2 sets but as soon as i try to insert a measure as third parameter i get a #N/A error.
For example this is working well.
=CUBESET("ThisWorkbookDataModel","EXISTS([Dates].[Mois].CHILDREN,[Dates].[Année].&[2014])","What is displayed in cell")
But if i try to add a measure from my model ( [Measures].[Total CA HT] ) i get #N/A error, here's the example. I want the same result but only for those who have amounts for [Total CA HT].
=CUBESET("ThisWorkbookDataModel","EXISTS([Dates].[Mois].CHILDREN,[Dates].[Année].&[2014],[Measures].[Total CA HT])","What is displayed in cell")
The measure [Total CA HT] =sum(Base[Montant HT])
The sets are not hierarchies.
I can't understand the problem.
Is it a syntax problem ? In MDX help about EXISTS Measures are between quotes "Internet Sales"
Should i use the name of a field instead of measure ? (i don't think so but...)
Maybe this parameter is not supported with tabular model like the excel cube function CUBEMEMBERPROPERTY ?
I thank you in advance for you're answer.
Just another thing, is somebody knows what are the MDX functions that we could use with excel cube formulas against a PowerPivot model ?
Thank you.
PS : Excuse me for my poor English.
I'm using a lot cube formulas to build my reports and now i try to insert mdx functions inside to improve powerfull.
These functions are always used against a PowerPivot model (tabular).
CUBESET with TOPCOUNT, FILTER... are working well.
I also use CUBESET with EXISTS and it works well with 2 sets but as soon as i try to insert a measure as third parameter i get a #N/A error.
For example this is working well.
=CUBESET("ThisWorkbookDataModel","EXISTS([Dates].[Mois].CHILDREN,[Dates].[Année].&[2014])","What is displayed in cell")
But if i try to add a measure from my model ( [Measures].[Total CA HT] ) i get #N/A error, here's the example. I want the same result but only for those who have amounts for [Total CA HT].
=CUBESET("ThisWorkbookDataModel","EXISTS([Dates].[Mois].CHILDREN,[Dates].[Année].&[2014],[Measures].[Total CA HT])","What is displayed in cell")
The measure [Total CA HT] =sum(Base[Montant HT])
The sets are not hierarchies.
I can't understand the problem.
Is it a syntax problem ? In MDX help about EXISTS Measures are between quotes "Internet Sales"
Should i use the name of a field instead of measure ? (i don't think so but...)
Maybe this parameter is not supported with tabular model like the excel cube function CUBEMEMBERPROPERTY ?
I thank you in advance for you're answer.
Just another thing, is somebody knows what are the MDX functions that we could use with excel cube formulas against a PowerPivot model ?
Thank you.
PS : Excuse me for my poor English.