dtm_report_cell_views.html - gerrit/www.eclipse.org/efbt - Git at Google

 <!-- This file was created using the HTML documentation generator. -->
 <!-- Creation date: Mon Apr 05 13:07:04 BST 2021-->
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 	<head>
       	<title>Metamodel Documentation (platform:/resource/org.eclipse.efbt.cocalimo.dtm.model.core/model/dtm_report_cell_views.ecore)</title>
     	<script type="text/javascript">
 //<![CDATA[
 // TOC script based on code taken from http://www.quirksmode.org/dom/toc.html
 function makeTOC() {

 	var toc = document.createElement('div')
 	toc.id = "toc";
 	toc.innerHTML = "Table of Contents"
 	document.body.appendChild(toc);

 	var innertocDiv = createTOC()
 	toc.appendChild(innertocDiv);
 }


 function createTOC() {
 	var y = document.createElement('div');
 	y.id = 'innertoc';
 	//var a = y.appendChild(document.createElement('span'));
 	//a.onclick = showhideTOC;
 	//a.id = 'contentheader';
 	//a.innerHTML = 'Show Table of Contents';
 	var z = y.appendChild(document.createElement('div'));
 	//z.onclick = showhideTOC;
 	var toBeTOCced = getElementsByTagNames('h1,h2,h3');
 	if (toBeTOCced.length < 2) return false;
 	var hCount = 0;
 	var hhCount = 0;
 	var hhhCount = 0;
 	for (var i=0;i<toBeTOCced.length;i++) {
 	var tmp = document.createElement('a');
 	tmp.className = 'page';
 	var text;
 	var textPre;
 	if (toBeTOCced[i].nodeName == 'h2'){
 		tmp.className += ' indent';
 		textPre = hCount + "."+ ++hhCount + ". ";
 	}
 	else if (toBeTOCced[i].nodeName == 'h3'){
 		tmp.className += ' extraindent';
 		textPre = hCount + "."+ hhCount + "."+ ++hhhCount +". ";
 	}
 	else {
 		textPre = ++hCount + ". ";
 		hhCount = 0;
 		hhhCount = 0;
 	}
 	text = textPre + toBeTOCced[i].textContent;
 	toBeTOCced[i].innerHTML = textPre + toBeTOCced[i].innerHTML;

 	tmp.innerHTML = text;
 	z.appendChild(tmp);
 	var headerId = toBeTOCced[i].id || 'link' + i;
 	tmp.href = '#' + headerId;
 	toBeTOCced[i].id = headerId;
 	}
 	return y;
 }

 function getElementsByTagNames(list,obj) {
 	if (!obj) var obj = document;
 	var tagNames = list.split(',');
 	var resultArray = new Array();
 	for (var i=0;i<tagNames.length;i++) {
 		var tags = obj.getElementsByTagName(tagNames[i]);
 		for (var j=0;j<tags.length;j++) {
 			resultArray.push(tags[j]);
 		}
 	}
 	var testNode = resultArray[0];
 	if (!testNode) return [];
 	if (testNode.sourceIndex) {
 		resultArray.sort(function (a,b) {
 				return a.sourceIndex - b.sourceIndex;
 		});
 	}
 	else if (testNode.compareDocumentPosition) {
 		resultArray.sort(function (a,b) {
 				return 3 - (a.compareDocumentPosition(b) & 6);
 		});
 	}
 	return resultArray;
 }

 //]]>
 	    	</script>
 	    	<link rel="stylesheet" type="text/css" href="https://raw.github.com/necolas/normalize.css/master/normalize.css" />
 	    	<style>
 #toc {
 	position: fixed;
 	  right: 0;
 	  top: 0;
 	  background-color:#eee;
 	  overflow: scroll;
 	  border: 1px dashed;
 }

 #toc #innertoc {
 	display: none;
 	height: 500px;
 } /* Hide the full TOC by default */

 #toc:hover #innertoc{
 	display: block; /* Show it on hover */
 }
 	td {
 	border: 1px solid;
 	}
 	.page{
 	display:table-row;
 	}
 	.indent {
 	text-indent:12pt;
 	}
 	.extraindent {
 	text-indent:14pt;
 	}

 	    	</style>
 	    	<link rel="stylesheet" type="text/css" href="style.css" />
 	</head>
 	<body onload="makeTOC();">
 <h1 id="dtmreportcellviews"><a href="#dtmreportcellviews"><span class="packageName">dtm_report_cell_views</span> package</a></h1>

 <p>This package describes dtm preport cell views</p>
 <div class="">EPackage properties:</div>
 <div class="keyValue"><span class="label">Namespace Prefix: </span><span class="teletype">dtm_report_cell_views</span></div>
 <div class="keyValue"><span class="label">Namespace URI: </span><span class="teletype">http://www.eclipse.org/efbt/dtm_report_cell_views</span></div>
 <h2 id="dtmreportcellviewsReportCellView"><a href="#dtmreportcellviewsReportCellView"><a href="#dtmreportcellviewsReportCellView">ReportCellView</a></a></h2>

 <p>A ReportCellView is an SQL View which has the explicit purpose of calculating one report cell.
 ReportCells are represented as a TargetCube with one row. This cube has multiple Dimensions columns and one Measure Column.
 The Dimension fields for table are set to be specific members of that dimension.
 Similar concepts exist in the taxonomy of XBRL reporting language and DataPointModelling.
 For example a ReportCellView which has a sourceCube of trade, associated measure 'amount' and associated dimensions Currency and Country,
 where it has been specified that Currency will equal USD and Country will equal US, will lead to the amount measure
 being populated with the sum of the amount field in the Trade table, for all rows in the Trade Table  where Currency=USD AND Country = US.</p>
 <h4><b>Supertype:</b><a href="#dtmsqlviewsSQLView">SQLView</a></h4><table>
 <tr>
 	<th colspan="3"><div class="tableHeader">References</div></th>
 </tr>
 <tr>
 	<th><div class="columnHeader">Name</div></th>
 	<th><div class="columnHeader">Properties</div></th>
 	<th><div class="columnHeader">Documentation</div></th>
 </tr>
 <tr>	<td><div id="dtmreportcellviewsReportCellView.reportCell" class="teletype">reportCell</div>
 	</td>
 	<td><div class="keyValue"><span class="label">T: </span><span class="teletype"><a href="#reportsReportCell">ReportCell</a></span></div>
 <div class="label">Cardinality: [0..1]</div>
 <div class="label">Containment</div>
 </td>
 <td> <p>The report cell</p>
 </td>
 		</tr><tr>	<td><div id="dtmreportcellviewsReportCellView.structColumnHoldingDimension" class="teletype">structColumnHoldingDimension</div>
 	</td>
 	<td><div class="keyValue"><span class="label">T: </span><span class="teletype"><a href="#efbtadvanceddatadefinitionStructTypedVariable">StructTypedVariable</a></span></div>
 <div class="label">Cardinality: [0..1]</div>
 </td>
 <td> </td>
 		</tr><tr>	<td><div id="dtmreportcellviewsReportCellView.structColumnHoldingMeasure" class="teletype">structColumnHoldingMeasure</div>
 	</td>
 	<td><div class="keyValue"><span class="label">T: </span><span class="teletype"><a href="#efbtadvanceddatadefinitionStructTypedVariable">StructTypedVariable</a></span></div>
 <div class="label">Cardinality: [0..1]</div>
 </td>
 <td> </td>
 		</tr></table>
 <a href="#dtm_report_cell_views.ReportCellView.ref"></a>
 <h2 id="dtmreportcellviewsReportCellViewModule"><a href="#dtmreportcellviewsReportCellViewModule"><a href="#dtmreportcellviewsReportCellViewModule">ReportCellViewModule</a></a></h2>

 <p>A Module containing a set of ReportCellViews </p>
 <h4><b>Supertype:</b><a href="#modulemanagementModule">Module</a></h4><table>
 <tr>
 	<th colspan="3"><div class="tableHeader">References</div></th>
 </tr>
 <tr>
 	<th><div class="columnHeader">Name</div></th>
 	<th><div class="columnHeader">Properties</div></th>
 	<th><div class="columnHeader">Documentation</div></th>
 </tr>
 <tr>	<td><div id="dtmreportcellviewsReportCellViewModule.reportCellViews" class="teletype">reportCellViews</div>
 	</td>
 	<td><div class="keyValue"><span class="label">T: </span><span class="teletype"><a href="#dtmreportcellviewsReportCellView">ReportCellView</a></span></div>
 <div class="label">Cardinality: [0..*]</div>
 <div class="label">Containment</div>
 </td>
 <td> <p>The set of ReportCellViews</p>
 </td>
 		</tr></table>
 <a href="#dtm_report_cell_views.ReportCellViewModule.ref"></a>
 </body>
 </html>
	<!-- This file was created using the HTML documentation generator. -->
	<!-- Creation date: Mon Apr 05 13:07:04 BST 2021-->
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<title>Metamodel Documentation (platform:/resource/org.eclipse.efbt.cocalimo.dtm.model.core/model/dtm_report_cell_views.ecore)</title>
	<script type="text/javascript">
	//<![CDATA[
	// TOC script based on code taken from http://www.quirksmode.org/dom/toc.html
	function makeTOC() {

	var toc = document.createElement('div')
	toc.id = "toc";
	toc.innerHTML = "Table of Contents"
	document.body.appendChild(toc);

	var innertocDiv = createTOC()
	toc.appendChild(innertocDiv);
	}


	function createTOC() {
	var y = document.createElement('div');
	y.id = 'innertoc';
	//var a = y.appendChild(document.createElement('span'));
	//a.onclick = showhideTOC;
	//a.id = 'contentheader';
	//a.innerHTML = 'Show Table of Contents';
	var z = y.appendChild(document.createElement('div'));
	//z.onclick = showhideTOC;
	var toBeTOCced = getElementsByTagNames('h1,h2,h3');
	if (toBeTOCced.length < 2) return false;
	var hCount = 0;
	var hhCount = 0;
	var hhhCount = 0;
	for (var i=0;i<toBeTOCced.length;i++) {
	var tmp = document.createElement('a');
	tmp.className = 'page';
	var text;
	var textPre;
	if (toBeTOCced[i].nodeName == 'h2'){
	tmp.className += ' indent';
	textPre = hCount + "."+ ++hhCount + ". ";
	}
	else if (toBeTOCced[i].nodeName == 'h3'){
	tmp.className += ' extraindent';
	textPre = hCount + "."+ hhCount + "."+ ++hhhCount +". ";
	}
	else {
	textPre = ++hCount + ". ";
	hhCount = 0;
	hhhCount = 0;
	}
	text = textPre + toBeTOCced[i].textContent;
	toBeTOCced[i].innerHTML = textPre + toBeTOCced[i].innerHTML;

	tmp.innerHTML = text;
	z.appendChild(tmp);
	var headerId = toBeTOCced[i].id \|\| 'link' + i;
	tmp.href = '#' + headerId;
	toBeTOCced[i].id = headerId;
	}
	return y;
	}

	function getElementsByTagNames(list,obj) {
	if (!obj) var obj = document;
	var tagNames = list.split(',');
	var resultArray = new Array();
	for (var i=0;i<tagNames.length;i++) {
	var tags = obj.getElementsByTagName(tagNames[i]);
	for (var j=0;j<tags.length;j++) {
	resultArray.push(tags[j]);
	}
	}
	var testNode = resultArray[0];
	if (!testNode) return [];
	if (testNode.sourceIndex) {
	resultArray.sort(function (a,b) {
	return a.sourceIndex - b.sourceIndex;
	});
	}
	else if (testNode.compareDocumentPosition) {
	resultArray.sort(function (a,b) {
	return 3 - (a.compareDocumentPosition(b) & 6);
	});
	}
	return resultArray;
	}

	//]]>
	</script>
	<link rel="stylesheet" type="text/css" href="https://raw.github.com/necolas/normalize.css/master/normalize.css" />
	<style>
	#toc {
	position: fixed;
	right: 0;
	top: 0;
	background-color:#eee;
	overflow: scroll;
	border: 1px dashed;
	}

	#toc #innertoc {
	display: none;
	height: 500px;
	} /* Hide the full TOC by default */

	#toc:hover #innertoc{
	display: block; /* Show it on hover */
	}
	td {
	border: 1px solid;
	}
	.page{
	display:table-row;
	}
	.indent {
	text-indent:12pt;
	}
	.extraindent {
	text-indent:14pt;
	}

	</style>
	<link rel="stylesheet" type="text/css" href="style.css" />
	</head>
	<body onload="makeTOC();">
	<h1 id="dtmreportcellviews"><a href="#dtmreportcellviews"><span class="packageName">dtm_report_cell_views</span> package</a></h1>

	<p>This package describes dtm preport cell views</p>
	<div class="">EPackage properties:</div>
	<div class="keyValue"><span class="label">Namespace Prefix: </span><span class="teletype">dtm_report_cell_views</span></div>
	<div class="keyValue"><span class="label">Namespace URI: </span><span class="teletype">http://www.eclipse.org/efbt/dtm_report_cell_views</span></div>
	<h2 id="dtmreportcellviewsReportCellView"><a href="#dtmreportcellviewsReportCellView"><a href="#dtmreportcellviewsReportCellView">ReportCellView</a></a></h2>

	<p>A ReportCellView is an SQL View which has the explicit purpose of calculating one report cell.
	ReportCells are represented as a TargetCube with one row. This cube has multiple Dimensions columns and one Measure Column.
	The Dimension fields for table are set to be specific members of that dimension.
	Similar concepts exist in the taxonomy of XBRL reporting language and DataPointModelling.
	For example a ReportCellView which has a sourceCube of trade, associated measure 'amount' and associated dimensions Currency and Country,
	where it has been specified that Currency will equal USD and Country will equal US, will lead to the amount measure
	being populated with the sum of the amount field in the Trade table, for all rows in the Trade Table where Currency=USD AND Country = US.</p>
	<h4><b>Supertype:</b><a href="#dtmsqlviewsSQLView">SQLView</a></h4><table>
	<tr>
	<th colspan="3"><div class="tableHeader">References</div></th>
	</tr>
	<tr>
	<th><div class="columnHeader">Name</div></th>
	<th><div class="columnHeader">Properties</div></th>
	<th><div class="columnHeader">Documentation</div></th>
	</tr>
	<tr> <td><div id="dtmreportcellviewsReportCellView.reportCell" class="teletype">reportCell</div>
	</td>
	<td><div class="keyValue"><span class="label">T: </span><span class="teletype"><a href="#reportsReportCell">ReportCell</a></span></div>
	<div class="label">Cardinality: [0..1]</div>
	<div class="label">Containment</div>
	</td>
	<td> <p>The report cell</p>
	</td>
	</tr><tr> <td><div id="dtmreportcellviewsReportCellView.structColumnHoldingDimension" class="teletype">structColumnHoldingDimension</div>
	</td>
	<td><div class="keyValue"><span class="label">T: </span><span class="teletype"><a href="#efbtadvanceddatadefinitionStructTypedVariable">StructTypedVariable</a></span></div>
	<div class="label">Cardinality: [0..1]</div>
	</td>
	<td> </td>
	</tr><tr> <td><div id="dtmreportcellviewsReportCellView.structColumnHoldingMeasure" class="teletype">structColumnHoldingMeasure</div>
	</td>
	<td><div class="keyValue"><span class="label">T: </span><span class="teletype"><a href="#efbtadvanceddatadefinitionStructTypedVariable">StructTypedVariable</a></span></div>
	<div class="label">Cardinality: [0..1]</div>
	</td>
	<td> </td>
	</tr></table>
	<a href="#dtm_report_cell_views.ReportCellView.ref"></a>
	<h2 id="dtmreportcellviewsReportCellViewModule"><a href="#dtmreportcellviewsReportCellViewModule"><a href="#dtmreportcellviewsReportCellViewModule">ReportCellViewModule</a></a></h2>

	<p>A Module containing a set of ReportCellViews </p>
	<h4><b>Supertype:</b><a href="#modulemanagementModule">Module</a></h4><table>
	<tr>
	<th colspan="3"><div class="tableHeader">References</div></th>
	</tr>
	<tr>
	<th><div class="columnHeader">Name</div></th>
	<th><div class="columnHeader">Properties</div></th>
	<th><div class="columnHeader">Documentation</div></th>
	</tr>
	<tr> <td><div id="dtmreportcellviewsReportCellViewModule.reportCellViews" class="teletype">reportCellViews</div>
	</td>
	<td><div class="keyValue"><span class="label">T: </span><span class="teletype"><a href="#dtmreportcellviewsReportCellView">ReportCellView</a></span></div>
	<div class="label">Cardinality: [0..*]</div>
	<div class="label">Containment</div>
	</td>
	<td> <p>The set of ReportCellViews</p>
	</td>
	</tr></table>
	<a href="#dtm_report_cell_views.ReportCellViewModule.ref"></a>
	</body>
	</html>