...
Close the MDX Console anc clik on the Download link to see the Mondrian's XML schema file:
And open the XML file with some text editor:
| Code Block | ||||
|---|---|---|---|---|
| ||||
<?xml version="1.0" encoding="UTF-8"?><Schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" metamodelVersion="4.0" name="Demo" xsi:noNamespaceSchemaLocation="mondrian4.xsd">
<PhysicalSchema>
<Table keyColumn="ID" name="PROJECTS"/>
<Table keyColumn="USERNAME" name="USERS"/>
<Table keyColumn="ID" name="ISSUETYPEDEFINITIONS"/>
<Query alias="ISSUESTATUSDEFINITIONS" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
select ID, NAME from ISSUESTATUSDEFINITIONS
union
select -1, 'No Status' from dual
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="ISSUEPRIORITYDEFINITIONS" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
select ID, NAME from ISSUEPRIORITYDEFINITIONS
union
select -1, 'No Priority' from dual
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="ISSUERESOLUTIONDEFINITIONS" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
select ID, NAME from ISSUERESOLUTIONDEFINITIONS
union
select -1, 'Unresolved' from dual
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="LABELS" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
SELECT i.ID, ilb.label
FROM ISSUES i
INNER JOIN ISSUELABELS ilb ON ilb.ISSUEID = i.ID
WHERE i.jql='project = "Sample Scrum Project"'
UNION SELECT -1, 'No label' as "LABEL" FROM dual
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="PROJECTVERSIONS" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
SELECT PROJECTID, ID, NAME, CASE ARCHIVED WHEN 0 THEN 'No Archived' WHEN 1 THEN 'Archived' END as "ARCHIVED", CASE RELEASED WHEN 0 THEN 'No Released' WHEN 1 THEN 'Released' END as "RELEASED"
FROM PROJECTVERSIONS
UNION
select -1, -1, 'No Version', 'No Archived', 'No Released'
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="PROJECTCOMPONENTS" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
SELECT pcs.PROJECTID, pcs.ID, pcs.NAME, IFNULL(pcs.LEAD, 'No Lead') as "LEAD"
FROM PROJECTS p
INNER JOIN PROJECTCOMPONENTS pcs ON pcs.PROJECTID = p.ID
UNION
SELECT -1, -1, 'No Component', 'No Lead' FROM dual
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="TIMEBYDAY">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
select * from aux.timebyday
where startdate='2017-11-16' and enddate='2017-12-14'
union
select -1, null, null, '', '-1', -1, -1, -1, -1, '-1' , null, null from dual
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="TIMEBYDAYVERSION">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
SELECT *, convert(THEYEAR, VARCHAR) as "YEAR", convert(DAYOFMONTH, VARCHAR) as "DAY"
FROM AUX.TIMEBYDAY
where startdate='2017-12-07' and enddate='2017-12-21'
union
select -1, null, null, '', 'No Month', 0, -1, -1, -1, 'No Quarter', null, null, 'No Year', 'No Day' from dual
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="ISSUES" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
SELECT i.id, i.key, i.summary, i.assignee, i.reporter, i.projectid, i.typeid, nvl(i.priorityid, -1) as "PRIORITYID", i.statusid,
date2long(cast(i.created as date)) as "CREATED", date2long(cast(i.updated as date)) as "UPDATED",
nvl2(i.due, date2long(cast(i.due as date)), -1) as "DUE", nvl2(i.resolved, date2long(cast(i.resolved as date)), -1) as "RESOLVED",
nvl(i.resolutionid, -1) as "RESOLUTIONID", nvl(i.originalestimate, 0) as "ESTIMATED", nvl(i.timespent, 0) as "TIMESPENT", nvl(i.remainingestimate, 0) AS "REMAINING"
,-1 as "VERSIONID", 'No Relation' as "RELATION", -1 as "START", -1 as "RELEASED"
, -1 as "PROJECTCOMPONENTID"
, 'No Label' as "LABEL"
, 'No User' as "AUTHOR", -1 as "CREATEDWORKLOG", -1 as "STARTWORKLOG"
, -1 as "FROMVALUE", -1 as "TOVALUE", -1 as "CREATEDCHANGED", 'No User' as "USERNAME"
FROM issues i
WHERE i.jql='project = "Sample Scrum Project"'
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="ISSUESTATUSCHANGES">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
select i.id, c.USERNAME, date2long(cast(c.created as date)) as "CREATEDCHANGED", c.FROMVALUE, c.TOVALUE, c.INTERVAL,
c.FROMSTRING, c.TOSTRING, i.projectid, i.typeid
, i.key, i.summary, i.assignee, i.reporter, nvl(i.priorityid, -1) as "PRIORITYID", i.statusid,
date2long(cast(i.created as date)) as "CREATED", date2long(cast(i.updated as date)) as "UPDATED",
nvl2(i.due, date2long(cast(i.due as date)), -1) as "DUE", nvl2(i.resolved, date2long(cast(i.resolved as date)), -1) as "RESOLVED",
nvl(i.resolutionid, -1) as "RESOLUTIONID"
,-1 as "VERSIONID", 'No Relation' as "RELATION", -1 as "START", -1 as "RELEASED"
, -1 as "PROJECTCOMPONENTID"
, 'No Label' as "LABEL"
, 'No User' as "AUTHOR", -1 as "CREATEDWORKLOG", -1 as "STARTWORKLOG"
from issues i inner join issuechanges c on c.issueid = i.id
where c.field='status' and i.jql='project = "Sample Scrum Project"'
UNION
select i.id, i.reporter as "USERNAME", date2long(cast(i.created as date)) as "CREATEDCHANGED", i.statusid as "FROMVALUE",
-1 as "TOVALUE", datediff('MILLISECOND', i.created, now()) as "INTERVAL",
s.name as "FROMSTRING", '<Current>' as "TOSTRING", i.projectid, i.typeid
, i.key, i.summary, i.assignee, i.reporter, nvl(i.priorityid, -1) as "PRIORITYID", i.statusid,
date2long(cast(i.created as date)) as "CREATED", date2long(cast(i.updated as date)) as "UPDATED",
nvl2(i.due, date2long(cast(i.due as date)), -1) as "DUE", nvl2(i.resolved, date2long(cast(i.resolved as date)), -1) as "RESOLVED",
nvl(i.resolutionid, -1) as "RESOLUTIONID"
,-1 as "VERSIONID", 'No Relation' as "RELATION", -1 as "START", -1 as "RELEASED"
, -1 as "PROJECTCOMPONENTID"
, 'No Label' as "LABEL"
, 'No User' as "AUTHOR", -1 as "CREATEDWORKLOG", -1 as "STARTWORKLOG"
from issues i inner join issuestatusdefinitions s on s.id = i.statusid
where i.jql='project = "Sample Scrum Project"'
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="ISSUEWORKLOGS">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
select i.id, i.key, i.projectid, i.typeid, w.author, date2long(cast(w.created as date)) as "CREATEDWORKLOG", w.timespent, date2long(cast(w.start as date)) as "STARTWORKLOG"
, i.summary, i.assignee, i.reporter, nvl(i.priorityid, -1) as "PRIORITYID", i.statusid,
date2long(cast(i.created as date)) as "CREATED", date2long(cast(i.updated as date)) as "UPDATED",
nvl2(i.due, date2long(cast(i.due as date)), -1) as "DUE", nvl2(i.resolved, date2long(cast(i.resolved as date)), -1) as "RESOLVED",
nvl(i.resolutionid, -1) as "RESOLUTIONID"
,-1 as "VERSIONID", 'No Relation' as "RELATION", -1 as "START", -1 as "RELEASED"
, -1 as "PROJECTCOMPONENTID"
, 'No Label' as "LABEL"
, -1 as "FROMVALUE", -1 as "TOVALUE", -1 as "CREATEDCHANGED", 'No User' as "USERNAME"
from issues i
inner join issueworklogs w on w.issueid = i.id
where i.jql='project = "Sample Scrum Project"'
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="ISSUEVERSION" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
SELECT i.ID, IFNULL(iv.VERSIONID, -1) as "VERSIONID", i.KEY, i.PROJECTID, IFNULL(iv.RELATION, 'No Relation') as "RELATION"
, nvl2(pv.START, date2long(cast(pv.START as date)), -1) as "START",
nvl2(pv.RELEASE, date2long(cast(pv.RELEASE as date)), -1) as "RELEASED"
, i.summary, i.assignee, i.reporter, i.typeid, nvl(i.priorityid, -1) as "PRIORITYID", i.statusid,
date2long(cast(i.created as date)) as "CREATED", date2long(cast(i.updated as date)) as "UPDATED",
nvl2(i.due, date2long(cast(i.due as date)), -1) as "DUE", nvl2(i.resolved, date2long(cast(i.resolved as date)), -1) as "RESOLVED",
nvl(i.resolutionid, -1) as "RESOLUTIONID"
, -1 as "PROJECTCOMPONENTID"
, 'No Label' as "LABEL"
, 'No User' as "AUTHOR", -1 as "CREATEDWORKLOG", -1 as "STARTWORKLOG"
, -1 as "FROMVALUE", -1 as "TOVALUE", -1 as "CREATEDCHANGED", 'No User' as "USERNAME"
FROM ISSUES i
LEFT JOIN ISSUEVERSIONS iv ON iv.ISSUEID = i.ID
LEFT JOIN PROJECTVERSIONS pv on pv.ID = iv.VERSIONID
WHERE i.jql='project = "Sample Scrum Project"'
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="ISSUECOMPONENTS" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
SELECT i.ID, i.KEY, i.PROJECTID, IFNULL(ic.PROJECTCOMPONENTID, -1) as "PROJECTCOMPONENTID"
, i.summary, i.assignee, i.reporter, i.typeid, nvl(i.priorityid, -1) as "PRIORITYID", i.statusid,
date2long(cast(i.created as date)) as "CREATED", date2long(cast(i.updated as date)) as "UPDATED",
nvl2(i.due, date2long(cast(i.due as date)), -1) as "DUE", nvl2(i.resolved, date2long(cast(i.resolved as date)), -1) as "RESOLVED",
nvl(i.resolutionid, -1) as "RESOLUTIONID"
,-1 as "VERSIONID", 'No Relation' as "RELATION", -1 as "START", -1 as "RELEASED"
, 'No Label' as "LABEL"
, 'No User' as "AUTHOR", -1 as "CREATEDWORKLOG", -1 as "STARTWORKLOG"
, -1 as "FROMVALUE", -1 as "TOVALUE", -1 as "CREATEDCHANGED", 'No User' as "USERNAME"
FROM ISSUES i
LEFT OUTER JOIN ISSUECOMPONENTS ic ON ic.ISSUEID = i.ID
WHERE i.jql='project = "Sample Scrum Project"'
]]>
</SQL>
</ExpressionView>
</Query>
<Query alias="ISSUELABELS" keyColumn="ID">
<ExpressionView>
<SQL dialect="generic">
<![CDATA[
SELECT i.ID, i.KEY, i.PROJECTID, IFNULL(ilb.LABEL, 'No Label') as "LABEL"
, i.summary, i.assignee, i.reporter, i.typeid, nvl(i.priorityid, -1) as "PRIORITYID", i.statusid,
date2long(cast(i.created as date)) as "CREATED", date2long(cast(i.updated as date)) as "UPDATED",
nvl2(i.due, date2long(cast(i.due as date)), -1) as "DUE", nvl2(i.resolved, date2long(cast(i.resolved as date)), -1) as "RESOLVED",
nvl(i.resolutionid, -1) as "RESOLUTIONID"
,-1 as "VERSIONID", 'No Relation' as "RELATION", -1 as "START", -1 as "RELEASED"
, -1 as "PROJECTCOMPONENTID"
, 'No User' as "AUTHOR", -1 as "CREATEDWORKLOG", -1 as "STARTWORKLOG"
, -1 as "FROMVALUE", -1 as "TOVALUE", -1 as "CREATEDCHANGED", 'No User' as "USERNAME"
FROM ISSUES i
LEFT OUTER JOIN ISSUELABELS ilb ON ilb.ISSUEID = i.ID
WHERE i.jql='project = "Sample Scrum Project"'
]]>
</SQL>
</ExpressionView>
</Query>
</PhysicalSchema>
<Dimension key="Day" name="Time" table="TIMEBYDAY" type="TIME">
<Attributes>
<Attribute hasHierarchy="false" keyColumn="THEYEAR" levelType="TimeYears" name="Year"/>
<Attribute hasHierarchy="false" levelType="TimeQuarters" name="Quarter" nameColumn="QUARTER">
<Key>
<Column name="THEYEAR"/>
<Column name="QUARTER"/>
</Key>
</Attribute>
<Attribute hasHierarchy="false" levelType="TimeMonths" name="Month" nameColumn="THEMONTH" orderByColumn="MONTHOFYEAR">
<Key>
<Column name="THEYEAR"/>
<Column name="MONTHOFYEAR"/>
</Key>
</Attribute>
<Attribute hasHierarchy="false" keyColumn="TIMEID" levelType="TimeDays" name="Day" nameColumn="DAYOFMONTH" orderByColumn="DAYOFMONTH"/>
</Attributes>
<Hierarchies>
<Hierarchy allLevelName="(All Dates)" name="Time">
<Level attribute="Year"/>
<Level attribute="Quarter"/>
<Level attribute="Month"/>
<Level attribute="Day"/>
</Hierarchy>
</Hierarchies>
</Dimension>
<Dimension key="User" name="User" table="USERS">
<Attributes>
<Attribute hierarchyAllLevelName="(All Users)" keyColumn="USERNAME" name="User"/>
</Attributes>
</Dimension>
<Dimension key="ID" name="Project" table="PROJECTS">
<Attributes>
<Attribute hasHierarchy="false" keyColumn="ID" name="ID"/>
<Attribute caption="NAME" hasHierarchy="false" keyColumn="NAME" name="Name"/>
<Attribute caption="Project" hierarchyAllLevelName="(All Projects)" keyColumn="KEY" name="Key">
<Property attribute="Name"/>
</Attribute>
</Attributes>
</Dimension>
<Dimension key="ID" name="Type" table="ISSUETYPEDEFINITIONS">
<Attributes>
<Attribute hasHierarchy="false" keyColumn="ID" name="ID" visible="false"/>
<Attribute hierarchyAllLevelName="(All Types)" keyColumn="NAME" name="Type"/>
</Attributes>
</Dimension>
<Dimension key="ID" name="Status" table="ISSUESTATUSDEFINITIONS">
<Attributes>
<Attribute hasHierarchy="false" keyColumn="ID" name="ID" visible="false"/>
<Attribute hierarchyAllLevelName="(All Statuses)" keyColumn="NAME" name="Status"/>
</Attributes>
</Dimension>
<Dimension key="ID" name="Priority" table="ISSUEPRIORITYDEFINITIONS">
<Attributes>
<Attribute hasHierarchy="false" keyColumn="ID" name="ID" visible="false"/>
<Attribute hierarchyAllLevelName="(All Priorities)" keyColumn="NAME" name="Priority"/>
</Attributes>
</Dimension>
<Dimension key="ID" name="Issue" table="ISSUES">
<Attributes>
<Attribute datatype="Integer" hasHierarchy="false" keyColumn="ID" name="ID"/>
<Attribute datatype="String" hasHierarchy="false" keyColumn="SUMMARY" name="Summary"/>
<Attribute datatype="String" hierarchyAllLevelName="(All Issues)" keyColumn="KEY" name="Key">
<Property attribute="Summary"/>
</Attribute>
<Attribute hierarchyAllLevelName="(All Affects/Fixes)" keyColumn="RELATION" name="Affect/Fix"/>
</Attributes>
</Dimension>
<Dimension key="ID" name="Resolution" table="ISSUERESOLUTIONDEFINITIONS">
<Attributes>
<Attribute caption="Resolution" hierarchyAllLevelName="(All Resolutions)" keyColumn="ID" name="ID" nameColumn="NAME"/>
</Attributes>
</Dimension>
<Dimension key="ID" name="Version" table="PROJECTVERSIONS">
<Attributes>
<Attribute hasHierarchy="false" keyColumn="ID" name="ID"/>
<Attribute hierarchyAllLevelName="(All Archived)" keyColumn="ARCHIVED" name="Archived"/>
<Attribute hierarchyAllLevelName="(All Released)" keyColumn="RELEASED" name="Released"/>
<Attribute hierarchyAllLevelName="(All Names)" keyColumn="NAME" name="Name"/>
</Attributes>
</Dimension>
<Dimension key="ID" name="Component" table="PROJECTCOMPONENTS">
<Attributes>
<Attribute hasHierarchy="false" keyColumn="ID" name="ID"/>
<Attribute hierarchyAllLevelName="(All Names)" keyColumn="NAME" name="Name"/>
<Attribute hierarchyAllLevelName="(All Leaders" keyColumn="LEAD" name="Lead"/>
</Attributes>
</Dimension>
<Dimension key="ID" name="Label" table="LABELS">
<Attributes>
<Attribute datatype="Integer" hasHierarchy="false" keyColumn="ID" name="ID"/>
<Attribute datatype="String" hierarchyAllLevelName="(All Labels)" keyColumn="LABEL" name="Label"/>
</Attributes>
</Dimension>
<Dimension key="Day" name="TimeVersion" table="TIMEBYDAYVERSION" type="TIME">
<Attributes>
<Attribute hasHierarchy="false" keyColumn="YEAR" levelType="TimeYears" name="Year"/>
<Attribute hasHierarchy="false" levelType="TimeQuarters" name="Quarter" nameColumn="QUARTER">
<Key>
<Column name="YEAR"/>
<Column name="QUARTER"/>
</Key>
</Attribute>
<Attribute hasHierarchy="false" levelType="TimeMonths" name="Month" nameColumn="THEMONTH" orderByColumn="MONTHOFYEAR">
<Key>
<Column name="YEAR"/>
<Column name="MONTHOFYEAR"/>
</Key>
</Attribute>
<Attribute hasHierarchy="false" keyColumn="TIMEID" levelType="TimeDays" name="Day" nameColumn="DAY" orderByColumn="DAY"/>
</Attributes>
<Hierarchies>
<Hierarchy allLevelName="(All Dates)" name="Time">
<Level attribute="Year"/>
<Level attribute="Quarter"/>
<Level attribute="Month"/>
<Level attribute="Day"/>
</Hierarchy>
</Hierarchies>
</Dimension>
<Cube name="JIRA Core">
<Dimensions>
<!-- ISSUES -->
<Dimension source="Issue"/>
<Dimension source="Project"/>
<Dimension source="Type"/>
<Dimension source="Status"/>
<Dimension source="Priority"/>
<Dimension source="Resolution"/>
<Dimension name="Updated" source="Time"/>
<Dimension name="Created" source="Time"/>
<Dimension name="Due" source="Time"/>
<Dimension name="Resolved" source="Time"/>
<Dimension name="Assignee" source="User"/>
<Dimension name="Reporter" source="User"/>
<!-- VERSIONS -->
<Dimension source="Version"/>
<Dimension name="Start Date Version" source="TimeVersion"/>
<Dimension name="Release Date Version" source="TimeVersion"/>
<!-- COMPONENTS -->
<Dimension source="Component"/>
<!-- LABELS -->
<Dimension source="Label"/>
<!-- WORKLOGS -->
<Dimension name="Worker" source="User"/>
<Dimension name="Start Worklog" source="Time"/>
<!-- TRANSITIONS -->
<Dimension name="From" source="Status"/>
<Dimension name="To" source="Status"/>
<Dimension name="Performed on" source="Time"/>
<Dimension name="Performed by" source="User"/>
</Dimensions>
<MeasureGroups>
<MeasureGroup table="ISSUES">
<Measures>
<Measure aggregator="distinct-count" column="ID" name="M01- Issue count"/>
<Measure aggregator="sum" column="ESTIMATED" name="M02- Estimated Time">
<CellFormatter className="expert.marketplace.jira.mondrian.formatter.JIRAWorkFormatter"/>
</Measure>
<Measure aggregator="sum" column="REMAINING" name="M03- Remainig Time">
<CellFormatter className="expert.marketplace.jira.mondrian.formatter.JIRAWorkFormatter"/>
</Measure>
<Measure aggregator="sum" column="TIMESPENT" name="M04- Logged Time">
<CellFormatter className="expert.marketplace.jira.mondrian.formatter.JIRAWorkFormatter"/>
</Measure>
</Measures>
<DimensionLinks>
<!-- ISSUES -->
<ForeignKeyLink dimension="Project" foreignKeyColumn="PROJECTID"/>
<ForeignKeyLink dimension="Type" foreignKeyColumn="TYPEID"/>
<ForeignKeyLink dimension="Status" foreignKeyColumn="STATUSID"/>
<ForeignKeyLink dimension="Priority" foreignKeyColumn="PRIORITYID"/>
<ForeignKeyLink dimension="Issue" foreignKeyColumn="ID"/>
<ForeignKeyLink dimension="Created" foreignKeyColumn="CREATED"/>
<ForeignKeyLink dimension="Updated" foreignKeyColumn="UPDATED"/>
<ForeignKeyLink dimension="Due" foreignKeyColumn="DUE"/>
<ForeignKeyLink dimension="Resolved" foreignKeyColumn="RESOLVED"/>
<ForeignKeyLink dimension="Assignee" foreignKeyColumn="ASSIGNEE"/>
<ForeignKeyLink dimension="Reporter" foreignKeyColumn="REPORTER"/>
<ForeignKeyLink dimension="Resolution" foreignKeyColumn="RESOLUTIONID"/>
<!-- VERSIONS -->
<ForeignKeyLink dimension="Version" foreignKeyColumn="VERSIONID"/>
<ForeignKeyLink dimension="Start Date Version" foreignKeyColumn="START"/>
<ForeignKeyLink dimension="Release Date Version" foreignKeyColumn="RELEASED"/>
<!-- COMPONENTS -->
<ForeignKeyLink dimension="Component" foreignKeyColumn="PROJECTCOMPONENTID"/>
<!-- LABELS -->
<ForeignKeyLink dimension="Label" foreignKeyColumn="ID"/>
<!-- WORKLOGS -->
<ForeignKeyLink dimension="Worker" foreignKeyColumn="AUTHOR"/>
<ForeignKeyLink dimension="Start Worklog" foreignKeyColumn="STARTWORKLOG"/>
<!-- TRANSITIONS -->
<ForeignKeyLink dimension="From" foreignKeyColumn="FROMVALUE"/>
<ForeignKeyLink dimension="To" foreignKeyColumn="TOVALUE"/>
<ForeignKeyLink dimension="Performed on" foreignKeyColumn="CREATEDCHANGED"/>
<ForeignKeyLink dimension="Performed by" foreignKeyColumn="USERNAME"/>
</DimensionLinks>
</MeasureGroup>
<MeasureGroup table="ISSUEVERSION">
<Measures>
<Measure aggregator="distinct-count" column="VERSIONID" name="M05- Count Versions in Issue"/>
<Measure aggregator="distinct-count" column="ID" name="M06- Count Issues in Version"/>
</Measures>
<DimensionLinks>
<!-- ISSUES -->
<ForeignKeyLink dimension="Project" foreignKeyColumn="PROJECTID"/>
<ForeignKeyLink dimension="Type" foreignKeyColumn="TYPEID"/>
<ForeignKeyLink dimension="Status" foreignKeyColumn="STATUSID"/>
<ForeignKeyLink dimension="Priority" foreignKeyColumn="PRIORITYID"/>
<ForeignKeyLink dimension="Issue" foreignKeyColumn="ID"/>
<ForeignKeyLink dimension="Created" foreignKeyColumn="CREATED"/>
<ForeignKeyLink dimension="Updated" foreignKeyColumn="UPDATED"/>
<ForeignKeyLink dimension="Due" foreignKeyColumn="DUE"/>
<ForeignKeyLink dimension="Resolved" foreignKeyColumn="RESOLVED"/>
<ForeignKeyLink dimension="Assignee" foreignKeyColumn="ASSIGNEE"/>
<ForeignKeyLink dimension="Reporter" foreignKeyColumn="REPORTER"/>
<ForeignKeyLink dimension="Resolution" foreignKeyColumn="RESOLUTIONID"/>
<!-- VERSIONS -->
<ForeignKeyLink dimension="Version" foreignKeyColumn="VERSIONID"/>
<ForeignKeyLink dimension="Start Date Version" foreignKeyColumn="START"/>
<ForeignKeyLink dimension="Release Date Version" foreignKeyColumn="RELEASED"/>
<!-- COMPONENTS -->
<ForeignKeyLink dimension="Component" foreignKeyColumn="PROJECTCOMPONENTID"/>
<!-- LABELS -->
<ForeignKeyLink dimension="Label" foreignKeyColumn="ID"/>
<!-- WORKLOGS -->
<ForeignKeyLink dimension="Worker" foreignKeyColumn="AUTHOR"/>
<ForeignKeyLink dimension="Start Worklog" foreignKeyColumn="STARTWORKLOG"/>
<!-- TRANSITIONS -->
<ForeignKeyLink dimension="From" foreignKeyColumn="FROMVALUE"/>
<ForeignKeyLink dimension="To" foreignKeyColumn="TOVALUE"/>
<ForeignKeyLink dimension="Performed on" foreignKeyColumn="CREATEDCHANGED"/>
<ForeignKeyLink dimension="Performed by" foreignKeyColumn="USERNAME"/>
</DimensionLinks>
</MeasureGroup>
<MeasureGroup table="ISSUECOMPONENTS">
<Measures>
<Measure aggregator="distinct-count" column="ID" name="M07- Count Issues in Component"/>
<Measure aggregator="distinct-count" column="PROJECTCOMPONENTID" name="M08- Count Components in Issue"/>
</Measures>
<DimensionLinks>
<!-- ISSUES -->
<ForeignKeyLink dimension="Project" foreignKeyColumn="PROJECTID"/>
<ForeignKeyLink dimension="Type" foreignKeyColumn="TYPEID"/>
<ForeignKeyLink dimension="Status" foreignKeyColumn="STATUSID"/>
<ForeignKeyLink dimension="Priority" foreignKeyColumn="PRIORITYID"/>
<ForeignKeyLink dimension="Issue" foreignKeyColumn="ID"/>
<ForeignKeyLink dimension="Created" foreignKeyColumn="CREATED"/>
<ForeignKeyLink dimension="Updated" foreignKeyColumn="UPDATED"/>
<ForeignKeyLink dimension="Due" foreignKeyColumn="DUE"/>
<ForeignKeyLink dimension="Resolved" foreignKeyColumn="RESOLVED"/>
<ForeignKeyLink dimension="Assignee" foreignKeyColumn="ASSIGNEE"/>
<ForeignKeyLink dimension="Reporter" foreignKeyColumn="REPORTER"/>
<ForeignKeyLink dimension="Resolution" foreignKeyColumn="RESOLUTIONID"/>
<!-- VERSIONS -->
<ForeignKeyLink dimension="Version" foreignKeyColumn="VERSIONID"/>
<ForeignKeyLink dimension="Start Date Version" foreignKeyColumn="START"/>
<ForeignKeyLink dimension="Release Date Version" foreignKeyColumn="RELEASED"/>
<!-- COMPONENTS -->
<ForeignKeyLink dimension="Component" foreignKeyColumn="PROJECTCOMPONENTID"/>
<!-- LABELS -->
<ForeignKeyLink dimension="Label" foreignKeyColumn="ID"/>
<!-- WORKLOGS -->
<ForeignKeyLink dimension="Worker" foreignKeyColumn="AUTHOR"/>
<ForeignKeyLink dimension="Start Worklog" foreignKeyColumn="STARTWORKLOG"/>
<!-- TRANSITIONS -->
<ForeignKeyLink dimension="From" foreignKeyColumn="FROMVALUE"/>
<ForeignKeyLink dimension="To" foreignKeyColumn="TOVALUE"/>
<ForeignKeyLink dimension="Performed on" foreignKeyColumn="CREATEDCHANGED"/>
<ForeignKeyLink dimension="Performed by" foreignKeyColumn="USERNAME"/>
</DimensionLinks>
</MeasureGroup>
<MeasureGroup table="ISSUELABELS">
<Measures>
<Measure aggregator="distinct-count" column="ID" name="M09- Count Issues with Labels"/>
<Measure aggregator="distinct-count" column="LABEL" name="M10- Count Labels in Issue"/>
</Measures>
<DimensionLinks>
<!-- ISSUES -->
<ForeignKeyLink dimension="Project" foreignKeyColumn="PROJECTID"/>
<ForeignKeyLink dimension="Type" foreignKeyColumn="TYPEID"/>
<ForeignKeyLink dimension="Status" foreignKeyColumn="STATUSID"/>
<ForeignKeyLink dimension="Priority" foreignKeyColumn="PRIORITYID"/>
<ForeignKeyLink dimension="Issue" foreignKeyColumn="ID"/>
<ForeignKeyLink dimension="Created" foreignKeyColumn="CREATED"/>
<ForeignKeyLink dimension="Updated" foreignKeyColumn="UPDATED"/>
<ForeignKeyLink dimension="Due" foreignKeyColumn="DUE"/>
<ForeignKeyLink dimension="Resolved" foreignKeyColumn="RESOLVED"/>
<ForeignKeyLink dimension="Assignee" foreignKeyColumn="ASSIGNEE"/>
<ForeignKeyLink dimension="Reporter" foreignKeyColumn="REPORTER"/>
<ForeignKeyLink dimension="Resolution" foreignKeyColumn="RESOLUTIONID"/>
<!-- VERSIONS -->
<ForeignKeyLink dimension="Version" foreignKeyColumn="VERSIONID"/>
<ForeignKeyLink dimension="Start Date Version" foreignKeyColumn="START"/>
<ForeignKeyLink dimension="Release Date Version" foreignKeyColumn="RELEASED"/>
<!-- COMPONENTS -->
<ForeignKeyLink dimension="Component" foreignKeyColumn="PROJECTCOMPONENTID"/>
<!-- LABELS -->
<ForeignKeyLink dimension="Label" foreignKeyColumn="ID"/>
<!-- WORKLOGS -->
<ForeignKeyLink dimension="Worker" foreignKeyColumn="AUTHOR"/>
<ForeignKeyLink dimension="Start Worklog" foreignKeyColumn="STARTWORKLOG"/>
<!-- TRANSITIONS -->
<ForeignKeyLink dimension="From" foreignKeyColumn="FROMVALUE"/>
<ForeignKeyLink dimension="To" foreignKeyColumn="TOVALUE"/>
<ForeignKeyLink dimension="Performed on" foreignKeyColumn="CREATEDCHANGED"/>
<ForeignKeyLink dimension="Performed by" foreignKeyColumn="USERNAME"/>
</DimensionLinks>
</MeasureGroup>
<MeasureGroup table="ISSUEWORKLOGS">
<Measures>
<Measure aggregator="distinct-count" column="ID" name="M11- Worklogs count"/>
<Measure aggregator="sum" column="TIMESPENT" name="M12- Time Spent Worklog">
<CellFormatter className="expert.marketplace.jira.mondrian.formatter.JIRAWorkFormatter"/>
</Measure>
</Measures>
<DimensionLinks>
<!-- ISSUES -->
<ForeignKeyLink dimension="Project" foreignKeyColumn="PROJECTID"/>
<ForeignKeyLink dimension="Type" foreignKeyColumn="TYPEID"/>
<ForeignKeyLink dimension="Status" foreignKeyColumn="STATUSID"/>
<ForeignKeyLink dimension="Priority" foreignKeyColumn="PRIORITYID"/>
<ForeignKeyLink dimension="Issue" foreignKeyColumn="ID"/>
<ForeignKeyLink dimension="Updated" foreignKeyColumn="UPDATED"/>
<ForeignKeyLink dimension="Due" foreignKeyColumn="DUE"/>
<ForeignKeyLink dimension="Resolved" foreignKeyColumn="RESOLVED"/>
<ForeignKeyLink dimension="Assignee" foreignKeyColumn="ASSIGNEE"/>
<ForeignKeyLink dimension="Reporter" foreignKeyColumn="REPORTER"/>
<ForeignKeyLink dimension="Resolution" foreignKeyColumn="RESOLUTIONID"/>
<!-- VERSIONS -->
<ForeignKeyLink dimension="Version" foreignKeyColumn="VERSIONID"/>
<ForeignKeyLink dimension="Start Date Version" foreignKeyColumn="START"/>
<ForeignKeyLink dimension="Release Date Version" foreignKeyColumn="RELEASED"/>
<!-- COMPONENTS -->
<ForeignKeyLink dimension="Component" foreignKeyColumn="PROJECTCOMPONENTID"/>
<!-- LABELS -->
<ForeignKeyLink dimension="Label" foreignKeyColumn="ID"/>
<!-- WORKLOGS -->
<ForeignKeyLink dimension="Worker" foreignKeyColumn="AUTHOR"/>
<ForeignKeyLink dimension="Created" foreignKeyColumn="CREATEDWORKLOG"/>
<ForeignKeyLink dimension="Start Worklog" foreignKeyColumn="STARTWORKLOG"/>
<!-- TRANSITIONS -->
<ForeignKeyLink dimension="From" foreignKeyColumn="FROMVALUE"/>
<ForeignKeyLink dimension="To" foreignKeyColumn="TOVALUE"/>
<ForeignKeyLink dimension="Performed on" foreignKeyColumn="CREATEDCHANGED"/>
<ForeignKeyLink dimension="Performed by" foreignKeyColumn="USERNAME"/>
</DimensionLinks>
</MeasureGroup>
<MeasureGroup table="ISSUESTATUSCHANGES">
<Measures>
<Measure aggregator="distinct-count" column="ID" name="M13- Count Issues in Status"/>
<Measure aggregator="sum" column="INTERVAL" name="M14- Interval">
<CellFormatter className="expert.marketplace.jira.mondrian.formatter.JIRATimeFormatter"/>
</Measure>
</Measures>
<DimensionLinks>
<!-- ISSUES -->
<ForeignKeyLink dimension="Project" foreignKeyColumn="PROJECTID"/>
<ForeignKeyLink dimension="Type" foreignKeyColumn="TYPEID"/>
<ForeignKeyLink dimension="Status" foreignKeyColumn="STATUSID"/>
<ForeignKeyLink dimension="Priority" foreignKeyColumn="PRIORITYID"/>
<ForeignKeyLink dimension="Issue" foreignKeyColumn="ID"/>
<ForeignKeyLink dimension="Created" foreignKeyColumn="CREATED"/>
<ForeignKeyLink dimension="Updated" foreignKeyColumn="UPDATED"/>
<ForeignKeyLink dimension="Due" foreignKeyColumn="DUE"/>
<ForeignKeyLink dimension="Resolved" foreignKeyColumn="RESOLVED"/>
<ForeignKeyLink dimension="Assignee" foreignKeyColumn="ASSIGNEE"/>
<ForeignKeyLink dimension="Reporter" foreignKeyColumn="REPORTER"/>
<ForeignKeyLink dimension="Resolution" foreignKeyColumn="RESOLUTIONID"/>
<!-- VERSIONS -->
<ForeignKeyLink dimension="Version" foreignKeyColumn="VERSIONID"/>
<ForeignKeyLink dimension="Start Date Version" foreignKeyColumn="START"/>
<ForeignKeyLink dimension="Release Date Version" foreignKeyColumn="RELEASED"/>
<!-- COMPONENTS -->
<ForeignKeyLink dimension="Component" foreignKeyColumn="PROJECTCOMPONENTID"/>
<!-- LABELS -->
<ForeignKeyLink dimension="Label" foreignKeyColumn="ID"/>
<!-- WORKLOGS -->
<ForeignKeyLink dimension="Worker" foreignKeyColumn="AUTHOR"/>
<ForeignKeyLink dimension="Start Worklog" foreignKeyColumn="STARTWORKLOG"/>
<!-- TRANSITIONS -->
<ForeignKeyLink dimension="From" foreignKeyColumn="FROMVALUE"/>
<ForeignKeyLink dimension="To" foreignKeyColumn="TOVALUE"/>
<ForeignKeyLink dimension="Performed on" foreignKeyColumn="CREATEDCHANGED"/>
<ForeignKeyLink dimension="Performed by" foreignKeyColumn="USERNAME"/>
</DimensionLinks>
</MeasureGroup>
</MeasureGroups>
</Cube>
</Schema> |