Wednesday 2 May 2012

Showing Text as measure in Crosstab

Hi Guys,

You will get this idea in IT toolbox .But that is not the point of noting this .Few things that i learned while trying

1) If you use define content property of crosstab it will override the measure values and you will be able to display whatever you have . Like placing measure twice .Helpful for conditional drill throughs .

2) If you select fact cells using ancestor button there is a property text source > source type you can specify it to be data item value you will see whatever the value is there of data item .By default it is set to cell value that is the cell that is the intersection of the rows and columns . however i think it wont display the the interseciton value in case you are calculation like

case when revenue >100 then 'YES' else 'NO' .It wont be able to display property yes and no values using this property

From IBM site


The method used to create this report was to add the measure as a nested data item under the columns, then change the Source Type property to Report Expression. After that define an expression that will calculate what text to show based on the value of the measure for that cell.
Do not add the measure to the crosstab corner or it will not work, it must be nested under the columns or rows. If you want to, you can set the Box Type property for the measure column header to None to hide it.





No comments:

Post a Comment