Cross table bound to cube in rptlibrary
<p>Hello BIRT community,</p>
<p> </p>
<p>today I have create cube and cross table elements in a library but I can not bind the date from the cube to the cross table. In a rptdesign this work well.</p>
<p>Is it possible to define cross table which is bound to a cube in a rptlibrary?</p>
<p> </p>
<p>The data set used for the cube is an scripted data set and I am using BIRT 4.3.1.</p>
<p> </p>
<p>For any suggestions and hints thanks in advance.</p>
<p> </p>
<p>Best Regards,</p>
<p>Kosta</p>
<p> </p>
<p>today I have create cube and cross table elements in a library but I can not bind the date from the cube to the cross table. In a rptdesign this work well.</p>
<p>Is it possible to define cross table which is bound to a cube in a rptlibrary?</p>
<p> </p>
<p>The data set used for the cube is an scripted data set and I am using BIRT 4.3.1.</p>
<p> </p>
<p>For any suggestions and hints thanks in advance.</p>
<p> </p>
<p>Best Regards,</p>
<p>Kosta</p>
Warning
No formatter is installed for the format ipb
0
Comments
-
<p>Hi Michael,</p>
<p> </p>
<p>the cube and the cross table are in the same library. I 'll copy them via the DEAPI to an design object in Java on runtime.</p>
<p>I thought that the connection between the cube and the cross table can be made in the report editor for that library like bounding data set and table or dataset and list.</p>
<p> </p>
<p>I dont know if this is not possible because it is specified that way or the report designer in eclipse do not let me to bound them because is buggy.</p>
<p> </p>
<p>Best Regards,</p>
<p>Kosta</p>
Warning No formatter is installed for the format ipb0 -
<p>Hello Michael,<br>
<br>
I have made an example library.<br>
<br>
You can see that there are 2 cross tables.</p>
<ul class="bbc"><li>One copied from rptdesign file</li>
<li>Second one created in the library</li>
</ul><p>You can see that for the second cross tab the designer focuses on click on the current element. So If I want to drag and drop an dimension from the cube to the cross tab that is not possible.<br>
The designer shows empty content in the layout when the cube is focused, not the same behaviour when working on rptdesign file.<br>
<br>
This maybe is an bug.</p>
<p> </p>
<p>+++++++++</p>
<p>I am not able to upload the file. (Error <strong>You aren't permitted to upload this kind of file</strong>). So I will post the content here.</p>
<pre class="_prettyXprint _lang-xml _linenums:1">
<?xml version="1.0" encoding="UTF-8"?>
<library xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 4.3.2.v20140211-1400 Build <4.3.2.v20140218-1056></property>
<property name="units">in</property>
<property name="theme">defaultTheme</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7">
<list-property name="privateDriverProperties">
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="8">
<list-property name="columnHints">
<structure>
<property name="columnName">STATE</property>
<text-property name="displayName">STATE</text-property>
<text-property name="heading">STATE</text-property>
</structure>
<structure>
<property name="columnName">QUANTITYORDERED</property>
<text-property name="displayName">QUANTITYORDERED</text-property>
<text-property name="heading">QUANTITYORDERED</text-property>
</structure>
<structure>
<property name="columnName">PRICEEACH</property>
<text-property name="displayName">PRICEEACH</text-property>
<text-property name="heading">PRICEEACH</text-property>
</structure>
<structure>
<property name="columnName">PRODUCTLINE</property>
<text-property name="displayName">PRODUCTLINE</text-property>
<text-property name="heading">PRODUCTLINE</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">QUANTITYORDERED</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PRICEEACH</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRODUCTLINE</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STATE</property>
<property name="nativeName">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">QUANTITYORDERED</property>
<property name="nativeName">QUANTITYORDERED</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PRICEEACH</property>
<property name="nativeName">PRICEEACH</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRODUCTLINE</property>
<property name="nativeName">PRODUCTLINE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT Customers.state,
Orderdetails.quantityOrdered,
Orderdetails.priceEach,
Products.productline
FROM Customers
INNER JOIN Orders ON Customers.customerNumber = Orders.customerNumber
INNER JOIN Orderdetails ON Orders.orderNumber = Orderdetails.orderNumber
INNER JOIN Products ON Orderdetails.productCode = Products.productCode
WHERE Customers.country = 'USA'
]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>STATE</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>STATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STATE</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>QUANTITYORDERED</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>QUANTITYORDERED</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>QUANTITYORDERED</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>PRICEEACH</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRICEEACH</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRICEEACH</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>PRODUCTLINE</design:name>
<design:position>4</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>PRODUCTLINE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>PRODUCTLINE</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<cubes>
<tabular-cube name="Data Cube" id="9">
<property name="dimensions">
<tabular-dimension name="ProductLine" id="19">
<property name="defaultHierarchy">NewTabularHierarchy</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy" id="20">
<property name="levels">
<tabular-level name="PRODUCTLINE" id="21">
<property name="dataType">string</property>
<property name="columnName">PRODUCTLINE</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
<tabular-dimension name="State" id="22">
<property name="defaultHierarchy">NewTabularHierarchy1</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy1" id="23">
<property name="levels">
<tabular-level name="STATE" id="24">
<property name="dataType">string</property>
<property name="columnName">STATE</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="Summary Field" id="25">
<property name="measures">
<tabular-measure name="QUANTITYORDERED" id="26">
<expression name="measureExpression" type="javascript">dataSetRow["QUANTITYORDERED"]</expression>
<property name="dataType">integer</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">Data Set</property>
</tabular-cube>
</cubes>
<themes>
<theme name="defaultTheme" id="4"/>
</themes>
<components>
<extended-item extensionName="Crosstab" extensionVersion="3.7.0" name="CrossTabCopyPasteFromRptDesign"
id="27">
<property name="cube">Data Cube</property>
<property name="measures">
<extended-item extensionName="MeasureView" name="NewMeasure View" id="40">
<property name="measure">QUANTITYORDERED</property>
<property name="detail">
<extended-item extensionName="AggregationCell" id="41">
<property name="aggregationOnRow">State/STATE</property>
<property name="aggregationOnColumn">ProductLine/PRODUCTLINE</property>
<property name="content">
<data name="NewData" id="42">
<property name="resultSetColumn">QUANTITYORDERED_State/STATE_ProductLine/PRODUCTLINE</property>
</data>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="43"/>
</property>
</extended-item>
</property>
<property name="rows">
<extended-item extensionName="CrosstabView" name="NewCrosstab View" id="35">
<property name="views">
<extended-item extensionName="DimensionView" name="NewDimension View" id="36">
<property name="dimension">State</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View1" id="37">
<property name="level">State/STATE</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="38">
<property name="content">
<data name="STATE" id="39">
<property name="resultSetColumn">STATE</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="columns">
<extended-item extensionName="CrosstabView" name="NewCrosstab View1" id="29">
<property name="views">
<extended-item extensionName="DimensionView" name="NewDimension View1" id="30">
<property name="dimension">ProductLine</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View" id="31">
<property name="level">ProductLine/PRODUCTLINE</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="32">
<property name="content">
<data name="PRODUCTLINE" id="33">
<property name="resultSetColumn">PRODUCTLINE</property>
</data>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>
</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="45"/>
<extended-item extensionName="CrosstabCell" id="28"/>
</property>
<structure name="toc"/>
<list-property name="boundDataColumns">
<structure>
<property name="name">PRODUCTLINE</property>
<expression name="expression">dimension["ProductLine"]["PRODUCTLINE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATE</property>
<expression name="expression">dimension["State"]["STATE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">QUANTITYORDERED_State/STATE_ProductLine/PRODUCTLINE</property>
<expression name="expression">measure["QUANTITYORDERED"]</expression>
<property name="dataType">integer</property>
<simple-property-list name="aggregateOn">
<value>State/STATE</value>
<value>ProductLine/PRODUCTLINE</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
</structure>
</list-property>
</extended-item>
<extended-item extensionName="Crosstab" extensionVersion="3.7.0" name="NewCrossTab"
id="46">
<property name="cube">Data Cube</property>
<property name="header">
<extended-item extensionName="CrosstabCell" id="47"/>
</property>
</extended-item>
</components>
<page-setup>
<simple-master-page name="NewSimpleMasterPage" id="3"/>
</page-setup>
</library>
</pre>
<p>Best Regards,</p>
<p>Kosta</p>
Warning No formatter is installed for the format ipb0 -
<p>I was able to drag the cube fields into the crosstab in the library with no issue. Maybe I'm confusing the issue a bit? I created a new library, copied your source in, clicked on the crosstab in the outline, went to the data explorer, expanded the data cube, then drug the fields to the crosstab in the layout. Let me know.</p>
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management