| 3839 |
vikas |
1 |
<Schema name="CRMResponseSchema">
|
|
|
2 |
<Cube name="CRMResponseCube" cache="true" enabled="true">
|
|
|
3 |
<Table name="crm">
|
|
|
4 |
</Table>
|
|
|
5 |
<Dimension type="TimeDimension" foreignKey="date_id" name="Date">
|
|
|
6 |
<Hierarchy name="Date" hasAll="true" allMemberName="All" primaryKey="date_id">
|
|
|
7 |
<Table name="datedim">
|
|
|
8 |
</Table>
|
|
|
9 |
<Level approxRowCount="2" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
|
|
|
10 |
</Level>
|
|
|
11 |
<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
|
|
|
12 |
</Level>
|
|
|
13 |
<Level approxRowCount="8" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
|
|
|
14 |
</Level>
|
|
|
15 |
<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
|
|
|
16 |
</Level>
|
|
|
17 |
</Hierarchy>
|
|
|
18 |
</Dimension>
|
|
|
19 |
<Dimension type="StandardDimension" name="Agent">
|
|
|
20 |
<Hierarchy name="Agent" hasAll="true" allMemberName="All">
|
|
|
21 |
<Level name="Year" column="name" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
22 |
</Level>
|
|
|
23 |
</Hierarchy>
|
|
|
24 |
</Dimension>
|
|
|
25 |
<Dimension type="StandardDimension" name="Status">
|
|
|
26 |
<Hierarchy name="Status" hasAll="true" allMemberName="All">
|
|
|
27 |
<Level name="State" column="status" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
28 |
</Level>
|
|
|
29 |
</Hierarchy>
|
|
|
30 |
</Dimension>
|
|
|
31 |
<Dimension type="StandardDimension" name="Category">
|
|
|
32 |
<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
|
|
|
33 |
<Level name="ParentCategory" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
34 |
</Level>
|
|
|
35 |
</Hierarchy>
|
|
|
36 |
</Dimension>
|
|
|
37 |
<Dimension type="StandardDimension" name="Priorirty">
|
|
|
38 |
<Hierarchy name="Priority" hasAll="true" allMemberName="All">
|
|
|
39 |
<Level name="Priority" column="priority" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
40 |
</Level>
|
|
|
41 |
</Hierarchy>
|
|
|
42 |
</Dimension>
|
|
|
43 |
<Dimension type="StandardDimension" name="Ticket">
|
|
|
44 |
<Hierarchy name="Ticket" hasAll="true" allMemberName="All">
|
|
|
45 |
<Level name="Ticket" column="ticketId" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
46 |
</Level>
|
|
|
47 |
</Hierarchy>
|
|
|
48 |
</Dimension>
|
|
|
49 |
<Measure name="Response Hours" column="response_hours" datatype="Integer" aggregator="avg" visible="true">
|
|
|
50 |
</Measure>
|
| 4030 |
vikas |
51 |
<Measure name="Days to Close" column="ticket_close_days" datatype="Integer" aggregator="avg" visible="true">
|
|
|
52 |
</Measure>
|
|
|
53 |
<Measure name="Reopen Count" column="reopen_count" datatype="Numeric" aggregator="sum" visible="true">
|
|
|
54 |
</Measure>
|
| 3839 |
vikas |
55 |
</Cube>
|
|
|
56 |
</Schema>
|