X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 cube




Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Documents related to » cube

Reporting Tools


Analysis and reporting services are an important part of the enterprise resource planning process. Microsoft Dynamics NAV has been designed to give users options for optimal analysis and reporting, and to leave room for partners to provide customized solutions. With the correct reporting tools and Microsoft Dynamics NAV, practical analysis and reporting is available and adaptable to individual users’ needs.

cube  you can create a cube based on Vendor Ledger Entries: When the cube has been defined, the configuration can be deployed. If you do this from inside Microsoft Dynamics NAV, any existing solution will be deleted and the new one created in its place. It is possible to maintain two active configurations by working with the SQL tools directly. This is described at http://blogs.msdn.com/clausba/ (this is not an out-of-the box functionality of the current release ). To be able to use cubes created in Business Read More

SAP HANA-One Technology to Watch in 2012 (and Beyond)


Did you know that SAP HANA is much more than a high-speed analytic appliance? TEC principal analyst P.J. Jakovljevic reveals how HANA is a universal database that will enable companies to analyze large volumes of operational and transactional information in real time, from virtually any data source, and that will eventually deliver an entirely new class of applications that will change the way people think, work, plan, and operate.

cube  Analytic View or OLAP cube is a set of physical tables, interconnected in a star schema. Only the fact table provides the information the user is actually interested in. The facts, also referred to as metrics, measures, or key figures, are generally numbers (or numerical values) such as “Sales Net Revenue.” The dimension tables provide the categories, classes, or attributes by which the facts can be grouped. In other words, the fact table provides the content of the OLAP cube, i.e., the “what” to Read More

Thinking Radically about Data Warehousing and Big Data: Interview with Roger Gaskell, CTO of Kognitio


Managing data—particularly in large numbers—still is and probably will be the number one priority for many organizations in the upcoming years. Many of the traditional ways to store and analyze large amounts of data are being replaced with new technologies and methodologies to manage the new volume, complexity, and analysis requirements. These include new ways of developing data warehousing, the

cube  online analytical processing (OLAP) cube solution. We had the pleasure of interviewing Roger Gaskell, chief technical officer (CTO) of Kognitio, and got some of interesting insights on Kognitio’s systems as well the BI and the data warehouse space in general. Roger Gaskell is responsible for all the product development that goes on at Kognitio. Prior to Kognitio, Mr. Gaskell worked as a test development manager at AB Electronics, primarily for the development and testing of the first mass production of Read More

Applix Still Shows a Presence in the OLAP Market


Applix Inc. has announced an agreement with Pelephone, Israel's second largest cellular network and handset supplier, to deliver its real-time, multi-dimensional On-Line Analytical Processing (OLAP) solution, iTM1 to analyze customer profiles for over 1.2 million Pelephone subscribers.

cube  and whether the OLAP cube will be sparse or dense . (Sparsity caused by the design of the cube can result in aggregate explosion , which can lead to huge increases in the size of the database.) Applix representatives should be questioned about the future of their OLAP offerings (given their propensity towards Linux at the moment), and reference accounts should be consulted. Read More

The Top Five Challenges with SQL Server Reporting and BI


Users of SQL Server value its power, speed, and affordability. But research shows that these users often face significant challenges in producing the business intelligence (BI)—reports, analysis, and dashboards—that they need to gain insight into their businesses. Learn how to evaluate three BI alternatives for Microsoft SQL users, and discover a new reporting and BI paradigm for SQL Server.

cube  Dashboards Challenge 4: OLAP Cube Maintenance Challenge 5: High Total Cost of Ownership Evaluating Alternatives to Microsoft Business Intelligence Introducing Birst: A New BI Paradigm for SQL Server Conclusion.   Executive Summary   The Top Five Challenges with SQL Server Reporting and BI SQL Server is the world's most widely used database for small and medium businesses for good reason: users of SQL Server value its power, speed and affordability. However, research shows that these users also often Read More

Microsoft’s Underlying Platform Parts for Enterprise Applications: Somewhat Explained - Part 2


Part 1 of this blog series concluded that Microsoft would not converge all of its diverse Microsoft Dynamics  product lines into a single enterprise resource planning (ERP) solution. Rather, the vendor has been attempting to leverage the best practices and technologies across all of the products, where possible. The idea is to deliver applications that have the following characteristics: are

cube  AX 2009 has the cube generation capability, whereby analytics perspectives have been added to the business logic model, and which can generate Data Source Views (DSV’s) and Online Analytic Processing (OLAP) cubes. The future research and development (R&D) forays will likely enable the round-trip (between VS.NET and SQL Server) advanced features that will require similar features to the abovementioned reporting tools. As a little caveat, these native reporting and analytics features will not be automatic Read More

Business Intelligence for SMBs: MBS Excel Applications and Competitive Analysis


Companies relying on an Excel or Excel-like system need to know that, while Excel might suffice for ad hoc analysis and data storage for individuals or small groups, the technological flaw of data and referential integrity prevents it from a corporate-wide, collaborative effort like planning and budgeting, not to mention product development and sourcing.

cube  online analytical processing (OLAP) cube. These solutions generally provide all-purpose, ad hoc, slice-and-dice analytic capabilities, definite analytic functions (such as, data mining, dashboard, or scorecard visualization), or the ability to generate enterprise or operational reports from within Excel. An additional list of commonly available capabilities includes Excel's ability to have multiple worksheets stored in one workbook file makes it appealing for management briefing books. Users can access Read More

SAS Institute Shoots for the Two-Stop-Shop with new Release of Warehouse Administrator


SAS Institute, a vendor of integrated data warehousing, decision support and information delivery software, has announced the production availability of SAS/Warehouse Administrator® software, Version 2.1. With an open component-based architecture, improved data access and management capabilities, thin-client interfaces, and other enhancements, it is an important component of the new SAS® software V8.1.

cube   Read More

You Need More Than Functions and Features to Implement an ERP Package Part One: The Administrator and Customizer


You have selected an ERP package. Now you have to worry about implementing the software. This article looks at four categories of tools that a vendor may supply that can make the implementation easier for your project team, end users, and IT department. Read on to see what tools you may want to have in your toolbox before proceeding with the implementation.

cube  often that solving Rubik's Cube is mere child's play. So the hard work is behind you; you can start coasting to the finish line. Think again, my mouse jockey friend. Unless you turn those functions and features into reality with a successful implementation, the benefits and savings, that you think are there for the taking, won't materialize. Sure, if you don't select the most appropriate software in the first place, a truly successful implementation may never be an option. The majority of the hard work, h Read More