Crosstab Data Binding Issue

Hi,

I'm using a Data Cube to build a Crosstab where data can potentially vary. I've added a couple of additional fields into the Data Cube, specifically one to the grouping hierarchy ("A") and another to the summary data fields ("B").

A is intended to be used as conditions to determine what data is to be brought into the Crosstab, but the field itself will not appear in the Crosstab. However, when I re-bind the Crosstab and re-add the data, I cannot find it in the Expression Builder, unless I pull it onto the table. Any way I can let it show up in the Data Column Binding list without pulling it into the Crosstab?

The problem with B is that when I tried to add it to the Data Column Binding by clicking "Add Aggregation", it didn't show up in the dropdown list of "Expression" as a "measure["B"]", which was what I wanted. I had other summary data fields before adding A and B and they showed up correctly. So I manually changed the "measure["previous fields"]" to "measure["B"]" in the Expression. I then found that when I went back to the Data Cube and tried to delete any of the previous fields, a "Reference Found" message would show up saying that the field to be deleted "has clients in 'Measure View'", but this message did not show up when I tried to delete field B.

Any idea how to solve these problems?

Thank you!!

Find more posts tagged with

Comments

RSP

Hi All,

I am using eclipse Birt 2.2.1,I want to show more fields in the table data,
i tried ,but the data is exceeding the report.could you please assist me.
as soon as possible.
thanks
rsp

mwilliams

Hi Evenstar,

Unfortunately, if you don't include a field in the crosstab, you can't access the value from the cube. This is because of the binding structure of the crosstab. You could include the group value in the crosstab and use the visibility property to hide it. Depending on your setup, this may or may not work for you, I guess.