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
 

 olap ilm

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 » olap ilm

DataSelf Corp


DataSelf is a provider of business intelligence solutions for the mid-market. DataSelf BI, its flagship solution, is easy to use, quick to deploy, and affordable. The easy-to-customize solution comes pre-configured with a data warehouse, OLAP cubes, in-memory analytics, dashboards, and more than 2,000 reports and key performance indicators (KPIs).

olap ilm  with a data warehouse, OLAP cubes, in-memory analytics, dashboards, and more than 2,000 reports and key performance indicators (KPIs). Read More

Business Intelligence Success, Lessons Learned


Is business intelligence (BI) an application that pays off? We have all heard mixed results but a 2003 extensive study on on-line analytical processing (OLAP) states that BI usually pays off over 60 percent of the time , explains where the value is found, and describes what’s required to get the pay off.

olap ilm  269 pages industry report, OLAP 3 that was published in November 2003 by Nigel Pendse explains that BI benefits are very real. While the report covers many aspects of OLAP and BI, we will focus on business benefits and overcoming the obstacles of achieving those benefits. According to the report, approximately 19 percent of companies implementing BI claim they have met or exceeded their business goals. Over 60 percent state they have at least largely met their goals. As always, soft benefits were more Read More

Business Intelligence: Its Ins and Outs


In today's highly competitive business climate, the quality and timeliness of business information for an organization is not only a choice between profit and loss, it is a question of survival or bankruptcy. No business organization can deny the inevitable benefits of business intelligence.

olap ilm  dashboards , OLTP , OLAP , data mining , alerting and notification systems , and analytics . Under the BI umbrella all these tools are combined within a special architecture. Data Warehouses and Data Mart Because data can come from various sources, like OLTP, ERP, CRM, legacy applications, and external data sources, data can be stored in a diversified database, in different formats and structures. As a result, a data warehouse (DW), is the most important and expensive player in the whole BI system Read More

Panorama Software


Founded in 1993, Panorama Software provides business intelligence (BI) solutions. Panorama sold its online analytical processing (OLAP) technology to Microsoft Corporation in 1996. That technology became the foundation for SQL Server Analysis Services, and Panorama has since been a strategic Microsoft partner. Panorama focuses on delivering BI solutions to companies as traditional on-premise offerings or through software-as-a-service (SaaS). Panorama's BI solution combines aspects of Microsoft's BI platform, Microsoft Office, and Microsoft SharePoint, with BI functionality designed to meet the needs of analysts and information workers. Panorama is headquartered in Toronto, Ontario (Canada), with offices in New York, New York (US); London (England); and Tel Aviv (Israel).

olap ilm  its online analytical processing (OLAP) technology to Microsoft Corporation in 1996. That technology became the foundation for SQL Server Analysis Services, and Panorama has since been a strategic Microsoft partner. Panorama focuses on delivering BI solutions to companies as traditional on-premise offerings or through software-as-a-service (SaaS). Panorama''s BI solution combines aspects of Microsoft''s BI platform, Microsoft Office, and Microsoft SharePoint, with BI functionality designed to meet the Read More

J.D. Edwards Teams with FRx Software to Improve Reporting Solutions


J.D. Edwards recently announced support for financial reporting solutions from FRx Software. This software makes it possible to consolidate information from multiple databases, platforms, and servers to provide a complete financial picture.

olap ilm  PeopleSoft. In addition, building OLAP cubes on the fly is very resource intensive. The upside is that the data is completely current as of the time the report is run. Sales representatives for the various ERP vendors will argue long and hard as to which approach is better. User Recommendations Customers investigating ERP solutions should include J.D. Edwards on their selection list. However, the vendor should be closely questioned as to exactly what mechanics FRx Software is using for data access, and Read More

Can You Add New Life To an Old ERP System?


Getting ERP transaction data into a summarized form that is useful to knowledge workers is one way to extend the value of your ERP system. This article discusses the advantages that can be gained by moving ERP and other transaction data to a data warehouse.

olap ilm  Processing (OLAP) tool. Today, OLAP tools are available as client-server applications or can be operated from a Web browser. The data warehouse also can include information that is not in your ERP system. By adding information from outside the ERP system, IT can provide users access to ALL the transaction information that the company collects as well as whatever information they might want to collect from OUTSIDE the company. This is a significant difference and a potentially powerful advantage. Pat Read More

Operational Business Intelligence and Performance Management: Key Differentiators


The distinction between business performance management and operational business intelligence is sometimes unclear. Many vendor offerings overlap in terms of features and functionality, making it difficult to distinguish between the two. However, there are some differences worth exploring.

olap ilm  complexity, the use of OLAP cubes was relegated to a few decision makers across the organization. Report distribution was more widely circulated; however, the advantages provided by the tools were not necessarily being exploited to their full potential. As data volumes increased and the demand for more frequent updates became the norm, data warehousing structures and BI platforms had to accommodate the additional needs of users. Extract, transform, and load (ETL) evolved to encompass technologies such as Read More

Oracle Information Lifecycle Management and Pillar Axiom


Oracle has information lifecycle management (ILM) functionality integrated in its database product, but its value still relies heavily on the customer buying various tiers of storage dedicated to ILM. It seems that when implementing an ILM solution, saving money can be an expensive proposition. Find out how one company decided to “think inside the box” and work with Oracle to solve the ILM storage problems.

olap ilm  Information Lifecycle Management and Pillar Axiom Oracle has information lifecycle management (ILM) functionality integrated in its database product, but its value still relies heavily on the customer buying various tiers of storage dedicated to ILM. It seems that when implementing an ILM solution, saving money can be an expensive proposition. Find out how one company decided to “think inside the box” and work with Oracle to solve the ILM storage problems. Read More

Datawarehouse Vendors Moving Towards Application Suites


During September, two more data warehousing vendors announced product suites that they claim offer broader integration between different data warehousing technologies. BI vendor Cognos announced "Cognos platform", a tool to build complete "BI-ready data infrastructures". Data Movement vendor Ardent Software announced "DataStage XE", which is designed to "simplify integration of multiple data sources and business intelligence tools".

olap ilm  tool capable of populating OLAP hypercubes, such as the one used by Cognos PowerPlay. Metadata management capabilities to provide centralized metadata and business rules. All applications in the suite share a common meta model. Business intelligence tools in the form of Cognos PowerPlay and Impromptu. These products have made Cognos one of the top three business intelligence vendors. Additional services such as data mart modeling and common security functions. Ardent DataStage XE Ardent has acquired a Read More

What’s New in Microsoft SQL Server 2000


SQL Server 2000, the next major release of SQL Server 7, is Microsoft’s SQL 7 release of its database both re-architected and re-written. Microsoft has high hopes for the latest version in a market that was worth $8 Billion in 1999, an 18% increase over 1998. What remains to be seen is whether it will attract customers not already using SQL Server.

olap ilm  sources. Analysis Services: (Formerly OLAP Services). The capability to create On-Line Analytical Processing multi-dimensional databases (MDBs or cubes ) within SQL Server. Also provides roll-up (aggregation) capabilities. Includes support for Multidimensional, Relational, and Hybrid OLAP. Integrated Data Mining: The ability to perform such tasks as clickstream analysis for web sites. Analysis services also provides the ability to link cubes (multiple cubes, either inside and/or outside the firewall Read More

CorVu


CorVu provides CPM and BPM modules including stratgeic management, scorecarding, balanced scorecards, risk management, budgeting and planning, consolidations, incentive management, dashbaords, web delivery, OLAP, business intelligence, report writing, financial report writing, graphical analysis, data mining, and foreacsting.  

olap ilm  management, dashbaords, web delivery, OLAP, business intelligence, report writing, financial report writing, graphical analysis, data mining, and foreacsting. Read More

TARGIT BI Product Certified


Recently, I met over the Web with TARGIT’s Ruben Knudsen and Ulrik Pedersen, along with some TEC cohorts to verify TARGIT’S BI product.  TARGIT had  completed a TEC-designed RFI containing a list of BI capabilities that every BI vendor could support  “out of the box.” The RFI is a common list of BI capabilities that we send to all BI vendors, and from the long list of TARGIT responses, we chose

olap ilm  standard data marts and OLAP facilities allow for drill downs to detailed information, desktop and Web reporting, as well as drill through analysis via SQL functions. TARGIT indicated that the majority of their implementations are done via  resellers. I asked Ruben and Ulrik about TARGIT as a company and I liked what I heard. Many of their 75 employees and 80+ distributors have been with the company since it was founded, 22 years ago.  Major clients include municipalities. They do most of their sales Read More

BI Reporting: Does the Tool Really Matter?


Last month I listened to several discussions about the importance of choosing the right reporting tool when installing a business intelligence (BI) solution. Here are some questions that were raised: Is the reporting tool really relevant when deploying a complete BI solution? Which type of reporting tool should I choose when deploying a BI system? Choosing the right reporting tool may not be as

olap ilm  •    analysis capabilities like OLAP cubes, predictive analytics; and •    other advanced features like alerts, advanced report distribution, etc. The above list is not an exhaustive one and can grow to add more specific functional criteria. It is essential to establish a list of at least three to five priorities for your organization. The Bottom Line Selecting a reporting tool can be a critical phase when deploying a BI solution for an organization. At the end of the day, reporting is an end Read More

Innovations in Business Intelligence


Business intelligence (BI) is in the midst of a new wave of innovations. Ideas in the search space, software as a service, and real-time analytics are extending the reach of BI across the complete size spectrum of organizations. This article looks at these technologies and their impact on businesses.

olap ilm  (data warehouses, data marts, OLAP cubes) and applying query mechanisms that understand the data structures. For instance, structured query language (SQL) and multi-dimensional expressions (MDX) are common ways of querying data that is stored in a data warehouse or OLAP cubes. Innovations in the search space include high-performance searching across unstructured and disparate data sources, new storage mechanisms, new approaches to user experience, and advanced multilingual search capabilities. The Read More

DataSelf Analytics


DataSelf Analytics is easy to use and quick to deploy. The easy-to-customize solution comes pre-configured with a data warehouse, online analytical processing (OLAP) cubes, in-memory analytics, dashboards, and more than 2,000 reports and key performance indicators (KPIs).

olap ilm  warehouse, online analytical processing (OLAP) cubes, in-memory analytics, dashboards, and more than 2,000 reports and key performance indicators (KPIs). Read More