Multiple independent groups in a crosstab

Hi, 
 
I'm trying to build a crosstab that displays multiple groups from a data cube, all crossed with the same dimension. I can do this now, but I need to define multiple crosstabs. I wonder if there's an easier way. 
 
The use-case: cross "Age" w/ "Gender", "Income" w/ "Gender" and present like so: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
| | MALE | FEMALE | Total |
| Age | | | |
| 18-34 | | | |
| ... | | | |
| Total | | | |
| Income| | | |
| 0-10K | | | |
| ... | | | |
| Total | | | |
</pre>
 
My cube has all three dimensions (age, income and gender). This table provides a summary of multiple dimensions crossed against a common one... 
 
Is this doable or do I need to make multiple crosstabs? If I need to make multiple crosstabs, what is the best way to "hide" the header of subsequent ones? 
 
Thanks, 
Philippe

Find more posts tagged with

Comments

mwilliams

plaflamme

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70920" data-time="1291222105" data-date="01 December 2010 - 09:48 AM">
You could make your query or use joins in a way to get your data like: </blockquote>
 
It isn't an SQL query, its a custom ODA. 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70920" data-time="1291222105" data-date="01 December 2010 - 09:48 AM">
If you can't do that, multiple crosstabs is probably the way to go. In this case, you should be able to hide the labels by setting the display property of the cells to "no display". </blockquote>
 
Thanks, I got the labels to disapear, but the layout is still weird because of the extra table cell (there are 2 header rows in a crosstab). Is there a way to get rid of one row? 
 
Thanks, 
Philippe

mwilliams

Philippe,

Can you show a screenshot of what you're talking about?

plaflamme

Here's the result of using multiple cross-tabs:

mwilliams

In the "general" section of the property editor for the crosstab, you can choose to "hide measure header". This should hide the measure header cell. As for the other cells, you should be able to select the cell, go to the property editor, go to the advanced tab, go to the "section" section, and set the display setting to "no display". This should hide that cell completely. You may need to put a label in between each crosstab to display what is shown in each rather than putting the label in the row label area so that the other cells can go away.