Posts Tagged Analysis Cubes
In Today’s World of Dynamics GP out-of-the-box SQL Reporting Services, Analysis Cubes and Excel Reports, is there any need for Business Intelligence Applications?
Posted by Mike Marcin in Dynamics GP, Southern California Microsoft Dynamics Partner, Systematica on June 30, 2011
I recall walking the ISV expo floor at Convergence a few years ago when Dynamics GP 10 was first released thinking, “Is there any need for all these Business Intelligence products anymore?” After all, Dynamics GP 10 came included with a reporting layer of SQL views, Excel Analysis Cubes, canned SQL Reporting Services and Excel [...]
Create free form reports using cube functions in Excel
Posted by Abi Shende in Dynamics CRM, Dynamics GP, Systematica on December 29, 2010
Microsoft Analysis Services provides an OLAP (Online Analytical Processing) engine that provides fast access to aggregated business data such as sales, budgets, inventory and costs. Analysis Services publishes data in form of a cube which enables you to filter and group data by predefined categories or dimensions. A cube is often used with Excel PivotTable [...]
Getting Insights from your Dynamics GP solution
Posted by Abi Shende in Dynamics GP on August 29, 2010
You have been using the Dynamics GP solution for some time and have captured valuable data about your customers, vendors and financial operations. Now you want to draw some useful insights from this information. You want the answers to questions such as the following: Who are our most profitable customers? What products are these customers [...]