How to create multiple column dimensions in cross tab tab

kalpana5

How to drag and drop vertical dimensions side by side in birt.Any inputs would be appreciated.

Find more posts tagged with

Comments

kalpana5

To be apt creating mutiple column dimensions in cross tab report. Thanks.

mwilliams

So, you're just wanting to have multiple dimensions in the crosstab? To do this, you just need to create a level structure in your cube by dragging the sub levels onto the main level item you want it under in the cube editor. Then, from your crosstab, you can expose the levels you want by clicking on the icon next to the dimension field and choosing to show different levels. Or, you could expand the cube in the data explorer and drag them out manually. Let me know if I'm not understanding correctly.

kalpana5

Could you please post an example . Thanks.

kalpana5

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="120099" data-time="1378830162"><div>So, you're just wanting to have multiple dimensions in the crosstab? To do this, you just need to create a level structure in your cube by dragging the sub levels onto the main level item you want it under in the cube editor. Then, from your crosstab, you can expose the levels you want by clicking on the icon next to the dimension field and choosing to show different levels. Or, you could expand the cube in the data explorer and drag them out manually. Let me know if I'm not understanding correctly.</div></blockquote>Hi , Got it , so need to drag the columns as a sublevel on to main level depending on the requirement. Thank You. Please ignore my above reply for an example.

mwilliams

That is correct. Let me know if you run into issues with this and need the example.

kalpana5

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="120106" data-time="1378833220"><div>That is correct. Let me know if you run into issues with this and need the example.</div></blockquote>Hi , Also could you please let me know how do we use the subtotal and grand total for the sublevel and main level column groups , I can see in the properties of cross tab Row Area and Column Area, would like to get clear idea on the subtotals and grand totals. Thank You much.

mwilliams

If you click on the icon next to a dimension, in your crosstab, you'll see an option to add totals. A dialog box will pop up and give you different check boxes to select to add the different totals to your crosstab. If you have multiple dimension levels, a sub total will be available as well. Hope this helps.

kalpana5

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="120108" data-time="1378833649"><div>If you click on the icon next to a dimension, in your crosstab, you'll see an option to add totals. A dialog box will pop up and give you different check boxes to select to add the different totals to your crosstab. If you have multiple dimension levels, a sub total will be available as well. Hope this helps.</div></blockquote>Thank You so much for your inputs . All these days I was using Row Area and Column Area got confused when there are mutiple dimensions, was not aware of the icon next to the dimension. If you do not mind can you please let me know what is the purpose of Row Area and Column area , does it serve same purpose as above.

mwilliams

Are you talking about the row area and column area of the property editor? Those areas can be used to set up page breaks and such, as well, but yes, the sub totals and grand totals here would be the same thing in the end.

kalpana5

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="120116" data-time="1378840239"><div>Are you talking about the row area and column area of the property editor? Those areas can be used to set up page breaks and such, as well, but yes, the sub totals and grand totals here would be the same thing in the end.</div></blockquote>Thank You, Yes I was talking about row area and column area in propety editor. Also is there any way we can set groupings on Cross Tab Report besides the groups where we drag and drop the columns from the data set.

mwilliams

Dragging and dropping is going to be your best way, probably. If you set up your sub-levels, you'll be able to just drop out the main level and then use the levels option from the icon to select which ones are shown.

kalpana5

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="120121" data-time="1378845203"><div>Dragging and dropping is going to be your best way, probably. If you set up your sub-levels, you'll be able to just drop out the main level and then use the levels option from the icon to select which ones are shown.</div></blockquote>So if I want to drag a row dimension based on whcih I need to group the cross tab , how should it be done.

kalpana5

<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120123" data-time="1378847419"><div>So if I want to drag a row dimension based on whcih I need to group the cross tab , how should it be done.</div></blockquote>Would also like to be more apt, if there is a cross tab with row dimension, if I want to group the cross tab based on another dimension in row area, how can it be achieved.Thanks!

mwilliams

Can you create a sample using the sample database that shows where you're stuck with this and use it to explain what you're wanting it to do? That might help me understand exactly what you're having an issue with! Thanks!

kalpana5

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="120125" data-time="1378847772"><div>Can you create a sample using the sample database that shows where you're stuck with this and use it to explain what you're wanting it to do? That might help me understand exactly what you're having an issue with! Thanks!</div></blockquote>Hi, Please find the below attached report design file, would like to group by siteid in the below example. So that the resultset would break by siteid .

kalpana5

Also please find the attached screen shot when run against the database. Thanks.

mwilliams

Are you meaning like this?

kalpana5

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="120389" data-time="1379440999"><div>Are you meaning like this?</div></blockquote>Hi, Would like to segregate( group) each output based on siteid , so basically the row dimension is divided into 5 different siteid's, as per above report the output looks like this, I would like to show the cross tab output for each siteid, not all of them together.

mwilliams

Oh. I think I'm understanding now. To have a completely separate crosstab for each siteID, you'd just need to embed your crosstab into a grouped (on siteid) table bound to your dataset with siteid.. You'd then make siteid an attribute on your dimension in your data cube. You'd do this by opening the data cube editor and double clicking on the row dimension. You'll see a place to add an attribute. Now, with siteid in the outer table and as an attribute in the cube, you'd just need to add a filter to your crosstab to limit the values returned to be of the outer table's siteid. Hope this helps.

kalpana5

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="120447" data-time="1379514584"><div>Oh. I think I'm understanding now. To have a completely separate crosstab for each siteID, you'd just need to embed your crosstab into a grouped (on siteid) table bound to your dataset with siteid.. You'd then make siteid an attribute on your dimension in your data cube. You'd do this by opening the data cube editor and double clicking on the row dimension. You'll see a place to add an attribute. Now, with siteid in the outer table and as an attribute in the cube, you'd just need to add a filter to your crosstab to limit the values returned to be of the outer table's siteid. Hope this helps.</div></blockquote> Thank You so much , followed your inputs and got the output as attached.

mwilliams

Great! Glad it's working for you! Let us know whenever you have questions!