May 7, 2008 at 3:39 am
i have in a matrix a measures desviation (stdev)
aggregate(desviation.value)
but if have the matrix by rowgroups(program - subprogram - pn ) and column groups(year-quarter-month), without extending, the cells are empty :
year
2007 2008
programa desviationdesviation
1
2
3
if i extending the matrix to level last , the aggregate are ok :
year
- 2007
- QUARTER
JANUARY
programa desviation
- 1 - A PN1 2,1
PN2 1,3
- B PN65 3,4
PN66 5,9
+ C
+2
+3
my measures in ssas is :
stdev( [view].[elementID].children, [measures].[days] )
my view has the columns:
elementID, program, subprogram, pn, date (yyyy/dd/dd),days
my dimension time is internal of ssas.
help!!
May 9, 2008 at 12:11 pm
A couple of points:
First, you must make sure you've entered the values in the matrix on the group lines. Look for the cells with a green triangle on the top left and click on the triangle.
Second, you need to make sure you have RS pull / use the value from the data source (MSAS). Natively, MSAS tries to aggregate (sum) the values, which in many cases isn't correct. For the field, use the value =Aggregate(desviation).
When pulling data for a matrix, make sure all of the "dimension fields" are referenced on your matrix.
MSRS treats the data in a "flat data source", so you have to go to some extra steps to make it properly reference MSAS data.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply