Viewing 7 posts - 1 through 7 (of 7 total)
I already can print out my MDX queries made by dundas. I already see the formatting and can possibly replicate it by code in a crude way.
I am looking for...
April 18, 2016 at 10:55 am
ok so i figured out ...[All] or .Siblings is a grouping and stdev needs a {set}
so i used stdev({Descendants([Dim Provider].[Dim Provider].Siblings) },...
and Descendants gives me all the child items as...
September 16, 2011 at 11:46 am
min([Dim Measure Groups].[All],111) gives "111.0"
stdev([Dim Measure Groups].[All],111) gives "-1.#IND"
so i am not sure where my error can be.
i run an MDX of it with just 1 guys data with...
September 16, 2011 at 10:12 am
ok moving back to the Calculations area i think i see what is needed
stddev({set}, {expression})
my {set} needs to be a dimension that I am grouping by.
so in my case I...
September 16, 2011 at 9:16 am
by calculated you mean the Calculations tab then that entry takes a {set} as the parameter for stdev.
stdev({set}, expression) and typically you put in a date field here and it...
September 16, 2011 at 7:55 am
I found in the fact properties AggregateFunction and MeasureExpression
can i put STDDEV into either of these fields
my AggregateFunction only has about 12 items like min,max,count, sum, firstNonEmpty etc etc -...
September 14, 2011 at 8:28 am
since i am wanting the min value of a calculated formula in that column i tried a dif approach for min and max.
i added my calculation to my named query...
September 14, 2011 at 7:08 am
Viewing 7 posts - 1 through 7 (of 7 total)