XLCubed Good Housekeeping

When I make a new report I start with adding two extra sheets:
  • Slicers
  • Parameters



The 'slicers' sheet I use as a landing page for all the slicers, the 'parameter' page to store temp parameters and hidden calculations

Comments

Post a Comment

Popular posts from this blog

XLCubed to which Cube or Database is a report connecting?

Image
We are planning a major overhaul on one of our cubes. The problem is that we don't know which reports are connection to this cube. We have over twohunderd possible candidates and don't want to open each one to check. I wrote a simple query to extract the connections from the repository: SELECT DISTINCT   fp.cPath as ReportPath , r.[cName] as ReportName , case when CHARINDEX('<connections>',convert(varchar(max),f.oData)) > 0 THEN SUBSTRING(convert(varchar(max),f.oData), CHARINDEX('<connections>',convert(varchar(max),f.oData)), CHARINDEX('</connections>',convert(varchar(max),f.oData)) - CHARINDEX('<connections>',convert(varchar(max),f.oData))+14) END as CubeConnections , case when CHARINDEX('<sqlconnections>',convert(varchar(max),f.oData)) >0 THEN SUBSTRING(convert(varchar(max),f.oData), CHARINDEX('<sqlconnections>',convert(varchar(max),...
Read more

XLCubed XL3Toolbar:SAVETOPOWERPOINT

You already might know the XL3Toolbar buttons . XL3Toolbar:REFRESH              XL3Toolbar:PRINT              XL3Toolbar:SUBMITCHANGES            XL3Toolbar:SAVETOEXCELFIXED            XL3Toolbar:SAVETOEXCELLIVE            XL3Toolbar:SAVETOREPOSITORY            XL3Toolbar:PRINTSHEET            XL3Toolbar:PRINTWB              XL3Toolbar:CLOSETAB              XL3Toolbar:SAVETOEXCELFIXEDSHEET I found a (currently) undocumented one: XL3Toolbar:SAVETOPOWERPOINT It does exactly as the name suggests, it opens the save / export to PowerPoint dialog. The XL3Toolbar: are very handy if you use picture links . Till Next Time
Read more