Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Cross Tatb report
kalpana5
<p>Hi ,</p><p> </p><p>Would like to design a report based on the following attached image, could any one of you please shed some light whether I need to go with cross tab or by creatign a table. Thanks.</p>
Find more posts tagged with
Comments
GLO_FR
<div>Hi</div><div>you can do both depending on your data.</div><div> </div><div>A crosstab will have all the possible intersection between rows and columns. That means that you must have in your dataset all the different values for row and at least one intersection for each column (not necessary for all row). If not, some columns will missing.</div><div>If the layout should evolve dynamically, a crosstab can be a good choice.</div><div> </div><div>With a table, you specify the layout, so the column are always there.Only the rows are/can be dynamic.</div><div>It's more static but also much easier to control.</div><div>If the layout shouldn't evolve, a table will be probably easier to build.</div>
kalpana5
<blockquote class="ipsBlockquote" data-author="GLO_FR" data-cid="128839" data-time="1403626667"><div><p> </p><div>Hi</div><div>you can do both depending on your data.</div><div> </div><div>A crosstab will have all the possible intersection between rows and columns. That means that you must have in your dataset all the different values for row and at least one intersection for each column (not necessary for all row). If not, some columns will missing.</div><div>If the layout should evolve dynamically, a crosstab can be a good choice.</div><div> </div><div>With a table, you specify the layout, so the column are always there.Only the rows are/can be dynamic.</div><div>It's more static but also much easier to control.</div><div>If the layout shouldn't evolve, a table will be probably easier to build.</div></div></blockquote><p> </p><p>Thank You, I think from your inputs, it is better to go with cross tab, as row and column values can be dynamic . Could you please let me know the term dynamic, does that mean row group which we add for example Group A for Row has 10 values, in future it might increase to 12 values which would be reflected in the report with out hard coding. Please let me know if I have put it in the right way.</p><p> </p><p> Could you please suggest if there is a way to make sure Cross tab values are not being cut off, adjusted Master page.</p>
GLO_FR
Yes, that's how crosstab works.
If it's only the number of rows which will increase, table is also available.
Table is dynamic in vertical side (row only), crosstab is dynamic in both sides : vertically and horizontally
kalpana5
<blockquote class="ipsBlockquote" data-author="GLO_FR" data-cid="128844" data-time="1403631217"><div><p>Yes, that's how crosstab works.
If it's only the number of rows which will increase, table is also available.
Table is dynamic in vertical side (row only), crosstab is dynamic in both sides : vertically and horizontally</p></div></blockquote><p>Thank You so much for the inputs, it is clear now.</p>
kalpana5
<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="128847" data-time="1403631796">r<div><p>Thank You so much for the inputs, it is clear now</p></div></blockquote><p>Could you please let me know how can we add title to the cross tab as shown in the attached image.</p>
GLO_FR
<p>Hi,</p><p> </p><p>two ways :</p><p>* add a text field in your report above the crosstab with your title</p><p>or</p><p>* create a computed filed in your dataset and inside the cube with your title (the value will be the same for each row).</p><p>Use it directly in your crosstab like a measure. The column will be automaticaly merged</p><p> </p><p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/topic/34772-adding-title-for-columns-common-header-for-all-the-columns-in-cross-tab/?p=128915'>Example
posted here</a></p>
