My Business Intelligence Experience

I recently had a requirement where the user wanted data from an existing Crosstab report to repeat every line so he can use the output in excel for comparison/analysis. It must be an old trick for most of us as I see so many posts around but none of them are straight forward and are hard to follow so i thought why not log it here, besides its only been 10 months since I shared anything. Sorry guys I'm in support right now so no time to explore new tips and tricks or maybe i'm being lazy ;) By default Crosstab groups columns nested based on the position on the cross tab, the trick here is to identify your lowest and highest level of data granularity. Lets pick the below crosstab as an example with PRODUCT, DESCRIPTION, LOCATION as nested dimension columns and default measure of SALES $ across MONTHS.                   Measure: Sales $      MONTH 1 | MONTH 2 .................................... Product | Descripti...

Recently one of the users pointed out a strange issue that data is not showing up in the Poweplay Studio work area(where you drag and drop cube items), user was able to see the dimension and measure folders on the left hand side. Initially i thought it has to do with a setting in users IE, so I suggested opening up the same in Firefox and it worked without issues. Deleting cookies,temp files, restoring default settings din't help either. After struggling  for 15-20 minutes and considerable amount of googling gave a wild answer...guess? It was ZOOM that caused this freaky effect in IE, at times I do this too. If you hold your CTRL key and use mouse scroll bar it shrinks or zooms any page, when it zooms somehow the Powerplay work Area disappears. 

Came across this slick option that will help you fit multiple Crosstabs or Lists into one page in Report Studio and thought would share it here. In report studio go to: File > Report Properties > Page break by data container for interactive HTML : Yes If this doesn't work make sure you put the Crosstabs/Lists in table cells inside Block.