SQL – XLCubed Blog ../../../ XLCubed Blog Thu, 05 Mar 2020 15:57:43 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png SQL – XLCubed Blog ../../../ 32 32 Updating SQL Tables from Excel ../../../2020/03/updating-sql-tables-from-excel/ ../../../2020/03/updating-sql-tables-from-excel/#comments Thu, 05 Mar 2020 15:55:02 +0000 https://blog.xlcubed.com/?p=5896 Most of our customers use XLCubed for reporting, analysis and data visualisation, but an increasing number use it for data updates, either within budgeting and forecasting solutions or in niche applications. XL3RunSQL is a neat method for running SQL updates from Excel, and allows users to build input forms (which can ultimately be web-enabled) quickly […]

The post Updating SQL Tables from Excel appeared first on XLCubed Blog.

]]> ../../../2020/03/updating-sql-tables-from-excel/feed/ 2 Data Mashups 101 ../../../2019/01/data-mashups-101/ ../../../2019/01/data-mashups-101/#respond Fri, 04 Jan 2019 09:25:37 +0000 https://blog.xlcubed.com/?p=4724 In an ideal world for report designers, all the data required for a report is available in one data source, and the structure and hierarchies perfectly match the reporting needs. Sadly, the world isn’t always ideal (just ask Theresa May…). We often see scenarios where users are reporting numerical data from Analysis Services but want […]

The post Data Mashups 101 appeared first on XLCubed Blog.

]]> ../../../2019/01/data-mashups-101/feed/ 0 XLCubed V7 & SQL Server 2012 ../../../2012/03/xlcubed-v7-sql-server-2012/ ../../../2012/03/xlcubed-v7-sql-server-2012/#respond Mon, 19 Mar 2012 12:22:32 +0000 http://blog.xlcubed.com/?p=3270 SQL server 2012 has recently been released to manufacturing, and at XLCubed we’re well placed to take advantage of everything that is new in 2012. SQL 2012 delivers Business Intelligence under the ‘BISM’ umbrella (Business Intelligence Semantic Model). BISM comes in different flavours though: BISM Multi-dimensional (Latest version of Analysis Services as we know it) […]

The post XLCubed V7 & SQL Server 2012 appeared first on XLCubed Blog.

]]> ../../../2012/03/xlcubed-v7-sql-server-2012/feed/ 0