A complete tutorial on how to create an OLAP cube, with sample sales data, that you can browse in Microsoft Excel. I’ll walk you through the whole process of defining fact table, dimensions and how to configure OLAP cube in Microsoft Visual Studio 2008 and publish it on SQL Server 2005 Analysis Services. You should already have SQL Server 2005 with Analysis services and Microsoft Visual Studio 2008 installed, as installing the software is not a part of this article.
| Read more …
June 15th, 2011 | Microsoft | Tags: Analysis, BI, browse, create, cube, data, deploy, Excel, Microsoft, OLAP, pivot, process, services, table, Visual Studio | 14 Comment
Microsoft Excel is a very powerful application and now we’ve finally got a powerful API written in PHP5 to read/write/convert Excel files also directly from Linux (not using COM, etc). It’s far from perfect at the moment but it is working in 90% of cases. Software I’m talking about can be found here and it’s called PHP Excel.
| Read more …
June 15th, 2011 | PHP | Tags: Excel, PDF, PHP, write, XLS, XLSX | 16 Comment
Microsoft Excel is a very powerful application and now we’ve finally got a powerful API written in PHP5 to read/write/convert Excel files also directly from Linux (not using COM, etc). It’s far from perfect at the moment, but it is working in 90% of cases. Software I’m talking about can be found here and it’s called PHP Excel.
| Read more …
June 15th, 2011 | PHP | Tags: CSV, Excel, PDF, PHP, read, XLS, XLSX | 6 Comment