Cross table bound to cube in rptlibrary

kosta · October 1, 2014

Hello BIRT community,
 
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.
Is it possible to define cross table which is bound to a cube in a rptlibrary?
 
The data set used for the cube is an scripted data set and I am using BIRT 4.3.1.
 
For any suggestions and hints thanks in advance.
 
Best Regards,
Kosta

mwilliams · October 1, 2014

Did you bring the cube into the report from the library? Can you attach a sample library and report using the sample database that shows your issue so I can see your setup?

kosta · October 1, 2014

Hi Michael,
 
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.
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.
 
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.
 
Best Regards,
Kosta

kosta · October 2, 2014

Hello Michael, 
 
I have made an example library. 
 
You can see that there are 2 cross tables.
<ul class="bbc"><li>One copied from rptdesign file</li>
<li>Second one created in the library</li>
</ul>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. 
The designer shows empty content in the layout when the cube is focused, not the same behaviour when working on rptdesign file. 
 
This maybe is an bug.
 
+++++++++
I am not able to upload the file. (Error You aren't permitted to upload this kind of file). So I will post the content here.
<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>
Best Regards,
Kosta

mwilliams · October 7, 2014

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.

kosta · October 15, 2014

Strange, in my designer when I am choosing the data set then the main window is empty, I guess it want to display the layout presentation of the dataset which doesnt exists. What version of BIRT have you used?

Cross table bound to cube in rptlibrary

Comments

Categories