Subversion Repositories SmartDukaan

<Schema name="CRMResponseSchema">
        <Cube name="CRMResponseCube" cache="true" enabled="true">
                <Table name="crm">
                </Table>
                <Dimension type="TimeDimension" foreignKey="date_id" name="Date">
                        <Hierarchy name="Date" hasAll="true" allMemberName="All" primaryKey="date_id">
                                <Table name="datedim">
                                </Table>
                                <Level approxRowCount="2" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
                                </Level>
                                <Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
                                </Level>
                                <Level approxRowCount="8" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
                                </Level>
                                <Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Agent">
                        <Hierarchy name="Agent" hasAll="true" allMemberName="All">
                                <Level name="Agent" table="crm" column="name" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Status">
                        <Hierarchy name="Status" hasAll="true" allMemberName="All">
                                <Level name="State" table="crm" column="status" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Category">
                        <Hierarchy name="Category" hasAll="true" allMemberName="All">
                                <Level name="Category" table="crm" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Priorirty">
                        <Hierarchy name="Priority" hasAll="true" allMemberName="All">
                                <Level name="Priority" table="crm" column="priority" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Ticket">
                        <Hierarchy name="Ticket" hasAll="true" allMemberName="All">
                                <Level name="Ticket" table="crm" column="ticketId" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Measure name="Response Hours" column="response_hours" datatype="Integer" aggregator="avg" visible="true">
                </Measure>
                <Measure name="Days to Close" column="ticket_close_days" datatype="Integer" aggregator="avg" visible="true">
                </Measure>
                <Measure name="Reopen Count" column="reopen_count" datatype="Numeric" aggregator="sum" visible="true">
                </Measure>
        </Cube>
</Schema>