Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Show empty columns in datacube
Migrateduser
Hi,<br />
<br />
I am facing a problem with my datacube, i hope you can help me on this.<br />
<br />
I have a datasource which is a csv file. In the csv file (and in my dataset so) one of the columns is "Region" which is corresponding to a location like 'US' or 'UK'. Others column can be dates or clients name.<br />
<br />
So i have created a computed column to determine what is the geographic zone of each client/region:<br />
<br />
(computed column name : 'type region')<br />
<blockquote class='ipsBlockquote' ><p>if ((row["Region"] == 'CE') || (row["Region"] == 'UK'))<br />
"Europe"<br />
<br />
if ((row["Region"] == 'SA') || (row["Region"] == 'US'))<br />
"America"<br /></p></blockquote>
<br />
Everything is ok for the moment. When a client is from UK, the "type region" computed column is correctly displaying 'Europe'.<br />
<br />
Then, i have created a datacube, in my groups (dimensions) i have : "Type region" and below 'Region'. As a summary field a count of all clients. <br />
<br />
So, my reports looks like :<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
| America | Europe |
| US | SA | CE | UK |
Row | (count) | (count) | (count) | (count) |
</pre>
<br />
But, if there is no client in the region 'SA', then the column is not displayed. I want to display it.<br />
When i am checking in my crosstab options "Empty Rows/Columns" -> Show empty columns, then the behavior is strange, look what i have :<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
| America | Europe |
| US | SA | CE | UK | US | SA | CE | UK |
Row | (count) | (count) | (count) | (count) | (count) | (count) | (count) | (count) |
</pre>
<br />
Is there any way to force BIRT to show all columns but in the right place ?<br />
<br />
I have tried the option "Show if blank" in crosstab advanced options instead, but no change.<br />
<br />
Do you have an idea ?<br />
<br />
Using BIRT 4.2.1<br />
Thanks
Find more posts tagged with
Comments
There are no comments yet