AnsweredAssumed Answered

Get bottom result

Question asked by Fernando Perez on Apr 30, 2018

Hi everyone!

Sorry if i post this question in the wrong section; I'm very new with Mondrian and i learn how it work in the past three weeks but now i got stuck with some final result.

 

I'm using Schema Workbench 8.0.0.0-28 and Knowage-CE, i made one simple schema with two dimension and ONE  measure, my dimension (Time [Default]) has one hierarchy and 6 levels (Year -> Semester -> Trimester -> Month -> Week -> Day) and the other dimension (Band) has one hierarchy and 1 level (Unique Members), the measure evaluate average, it work pretty well but i want to have some final results at the bottom of the "Table", the average of each column:

Dimension (TIME)

DIMENSION BAND (MAX)

DIMENSION BAND (AVG)

DIMENSION BAND (MIN)
JANUARY94.5032.559.10
FEBRUARY78.6026.474.31
MARCH88.1544.527.20
FINAL RESULT (AVG)87.0334.516.87

 

Im try MDX and Calculated Member but i fail, probably because i dont get how to use my dimension with all levels. Here some XML of my schema:

 

DIMENSION (TIME)

 

<Dimension type="TimeDimension" visible="true" foreignKey="DIM_DATE" highCardinality="false" name="DIM_TIME"> <Hierarchy name="TIME" visible="true" hasAll="true" primaryKey="DIM_KEY"> <Table name="VW_DIM_DATE" schema="DA" /> <Level name="YEAR" visible="true" column="YEAR" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" captionColumn="LABEL_YEAR" /> <Level name="SEMESTER" visible="true" column="SEMESTER" type="Integer" uniqueMembers="false" levelType="TimeHalfYear" hideMemberIf="Never" captionColumn="LABEL_SEMESTER" /> <Level name="TRIMESTER" visible="true" column="TRIMESTER" type="Integer" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never" captionColumn="LABEL_TRIMESTER" /> <Level name="MONTH" visible="true" column="MONTH" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" captionColumn="LABEL_MONTH" /> <Level name="WEEK" visible="true" column="WEEK" type="Numeric" uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never" captionColumn="LABEL_WEEK" /> <Level name="DAY" visible="true" column="DAY" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" /> </Hierarchy> </Dimension> 

DIMENSION (BAND)

<Dimension type="StandardDimension" visible="true" foreignKey="DIM_RANGE" highCardinality="false" name="DIM_BAND"> <Hierarchy name="BAND" visible="true" hasAll="true" primaryKey="DIMENSION_KEY"> <Table name="VW_DIM_RANGE" schema="DA" /> <Level name="BAND" visible="true" column="BAND" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" /> </Hierarchy> </Dimension> 

MEASURE

<Measure name="MSR_DATA" column="DATA" datatype="Numeric" formatString="#,##0.00" aggregator="avg" caption="DATA" description="DATA(AVG)" visible="true" /> 

Thanks in advance.

Outcomes