Posts

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

XLCubed who's calling

Image
If you have multiple reports calling a master report like this :

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.cPathas 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),f.oData)),
CHARINDEX('</sqlconnections>',convert(varchar(m…

XLCubed clickable region in image

Image
We needed a Q&D way for our clients to indicatie te location of their pain in/on there body.