| Line 183... |
Line 183... |
| 183 |
<Dimension type="TimeDimension" foreignKey="customer_id" name="First Source TIme">
|
183 |
<Dimension type="TimeDimension" foreignKey="customer_id" name="First Source TIme">
|
| 184 |
<Hierarchy name="First Source TIme" hasAll="true" allMemberName="All" primaryKey="id" primaryKeyTable="user">
|
184 |
<Hierarchy name="First Source TIme" hasAll="true" allMemberName="All" primaryKey="id" primaryKeyTable="user">
|
| 185 |
<Join leftKey="source_start_date_id" rightKey="date_id">
|
185 |
<Join leftKey="source_start_date_id" rightKey="date_id">
|
| 186 |
<Table name="user">
|
186 |
<Table name="user">
|
| 187 |
</Table>
|
187 |
</Table>
|
| 188 |
<Table name="datedim">
|
188 |
<Table name="datedim" alias="datedim2">
|
| 189 |
</Table>
|
189 |
</Table>
|
| 190 |
</Join>
|
190 |
</Join>
|
| 191 |
<Level name="Year" table="datedim" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
|
191 |
<Level name="Year" table="datedim2" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
|
| 192 |
</Level>
|
192 |
</Level>
|
| 193 |
<Level name="Quarter" table="datedim" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
|
193 |
<Level name="Quarter" table="datedim2" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
|
| 194 |
</Level>
|
194 |
</Level>
|
| 195 |
<Level name="Month" table="datedim" column="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
|
195 |
<Level name="Month" table="datedim2" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
|
| 196 |
</Level>
|
196 |
</Level>
|
| 197 |
<Level name="Date" table="datedim" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
|
197 |
<Level name="Date" table="datedim2" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
|
| 198 |
</Level>
|
198 |
</Level>
|
| 199 |
</Hierarchy>
|
199 |
</Hierarchy>
|
| 200 |
</Dimension>
|
200 |
</Dimension>
|
| 201 |
<Dimension type="TimeDimension" foreignKey="session_start_date_id" name="Session Time">
|
201 |
<Dimension type="TimeDimension" foreignKey="session_start_date_id" name="Session Time">
|
| 202 |
<Hierarchy name="Session Time" hasAll="true" allMemberName="All" primaryKey="date_id">
|
202 |
<Hierarchy name="Session Time" hasAll="true" allMemberName="All" primaryKey="date_id">
|
| 203 |
<Table name="datedim" schema="" alias="">
|
203 |
<Table name="datedim" alias="datedim3">
|
| 204 |
</Table>
|
204 |
</Table>
|
| 205 |
<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
|
205 |
<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
|
| 206 |
</Level>
|
206 |
</Level>
|
| 207 |
<Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
|
207 |
<Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
|
| 208 |
</Level>
|
208 |
</Level>
|
| 209 |
<Level name="Month" column="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
|
209 |
<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
|
| 210 |
</Level>
|
210 |
</Level>
|
| 211 |
<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
|
211 |
<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
|
| 212 |
</Level>
|
212 |
</Level>
|
| 213 |
</Hierarchy>
|
213 |
</Hierarchy>
|
| 214 |
</Dimension>
|
214 |
</Dimension>
|