olap server

ZDNet Resources

• sort by:
• Relevance
• Date
• Popularity

Using SAS OLAP Server for a ROLAP Scenario

SAS offers a flexible Online Analytical Processing OLAP solution, not only allowing users to choose a Multidimensional OLAP MOLAP approach, but also a Relational OLAP ROLAP solution. With the latter approach, the SAS OLAP Server accesses data stored within relational database management systems directly. A ROLAP approach reduces cube build...

Tags: OLAP, SAS Institute, Server, RDBMS, OLAP Server, Data Mining, Databases, Enterprise Software, Software, Data Management

White papers 2009-02-27

The SAS OLAP Server: Understanding and Solving Common Problems

The SAS OLAP Server is a complex and powerful tool that is used for storing and exploiting multidimensional data. Because using complex tools can present complex challenges, one need solutions that simplify the use of the SAS OLAP Server and increase operational reliability. This paper provides information intended to empower...

Tags: SAS Institute, Server, OLAP Server, SAS OLAP Server, Databases, Enterprise Software, Software, Data Management

White papers 2009-02-27

SAS 9 OLAP Server: Cube Building - Data Preparation and Cube Storage

This technical paper introduces the terminology that is needed to understand multidimensional databases cubes, provides an overview of the structure of a cube, and explains how to prepare data for loading into a multidimensional cube. This paper is written for database administrators and applications developers who build cubes. It is...

Tags: Data Warehouse, SAS Institute, Server, OLAP Server, Business Intelligence, Storage, Databases, Enterprise Software, Software, Data Management, Hardware

White papers 2004-04-01

OLAP and OLAP Server Definitions

OLAP is implemented in a multi-user client/server mode and offers consistently rapid response to queries, regardless of database size and complexity. OLAP helps the user synthesize enterprise information through comparative, personalized viewing, as well as through analysis of historical and projected data in various "what-if" data model scenarios. This is...

Tags: OLAP, Server, OLAP Server, OLAP Council, Data Mining, Databases, Enterprise Software, Software, Data Management

White papers

Additional Resources

MDAccess 2.5.8 (Windows)

MDAccess is a charting/reporting program that reads data from OLAP/multi-dimensional Access/SQL Server databases created by ETR, PointMan Reporter, or MDAccess itself. Due to the multi-dimensional structure of the databases, data can be easily accessed, rotated, or manipulated. MDAccess is offering the following features: Flexible element selector allows for easy manipulation...

Tags: Alteration, Microsoft Windows, Model-driven Architecture, MDAccess, Model Driven Architecture, Storage, Databases, Ooa/Ood/Oop, Software Development, Software/Web Development, Hardware, Enterprise Software, Software, Data Management

Software downloads 2009-11-10

Response42 Query & Report 1.0 (Windows)

Response42 Query & Report lets you create database queries and reports in plain English. Simply ask an English question and the software will answer it with a fully formatted database report or an interactive dashboard. Response42 Query & Report is a web-based software that requires Microsoft IISc. It supports Microsoft...

Tags: Dashboard, Microsoft Windows, Microsoft Corp., Response42 Technology, Response42 Query & Report, Storage, Databases, Tools & Techniques, Hardware, Enterprise Software, Software, Data Management, Management

Software downloads 2009-07-03

Valentina Studio Pro 4.2 (Mac)

Valentina Studio Pro is a complete solution for managing data on the OLAP ready Valentina database system, locally or on a server. A visual SQL builder makes it easy to build, execute and store regularly used queries. Import your local or live server data, import via ODBC and run complex...

Tags: Apple Macintosh, Data, Paradigma Software, Valentina Studio Pro, Internet, Data Mining, Databases, Servers, Enterprise Software, Software, Data Management, Hardware

Software downloads 2009-06-25

Firebird Maestro 9.5 (Windows)

Firebird Maestro is a powerful solution for the Firebird server administration and development. Key features include: support for all the Firebird versions from 1.0 to 2.5; database designer; complete data management tools with viewing, editing, grouping, sorting and filtering abilities and BLOB Viewer/Editor; Unicode/UTF8 support; handy SQL Editor with code...

Tags: SQL, Microsoft Windows, Firebird Maestro, Data Management, Databases, Programming Languages, Storage, Enterprise Software, Software, Software Development, Software/Web Development, Hardware

Software downloads 2009-06-02

Business Intelligence - HP DL785 G5 server reference configurations for Microsoft SQL Server 2008

Trying to determine the correct hardware configuration to support a Business Intelligence BI workload may be challenging. Therefore, HP has made available several documents to simplify the hardware selection process by documenting various configurations to support pre-defined workloads, which access various sized databases and/or OLAP cubes. This paper provides with...

Tags: Microsoft SQL Server 2008, Hewlett-Packard Co., OLAP, Microsoft SQL Server, Server, Microsoft Corp., Pricing, Business Intelligence, Tools & Techniques, Data Mining, Databases, Enterprise Software, Marketing, Software, Data Management, Management

White papers 2009-06-01

Oracle Maestro 9.4 (Windows)

Oracle Maestro is a powerful solution for the Oracle server administration and development. The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, and compose OLAP cubes. Version 9.4 introduces advanced transaction management, significantly improves Data Export...

Tags: Oracle Corp., SQL, Microsoft Windows, SQL Maestro, Oracle Maestro, Programming Languages, Databases, Productivity, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2009-05-14

MS SQL Maestro 9.4 (Windows)

MS SQL Maestro is a powerful solution for the Microsoft SQL Server administration and development. The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, and compose OLAP cubes. Supports all the SQL Server latest features up...

Tags: Microsoft SQL Server, SQL, Microsoft Windows, Microsoft Corp., SQL Maestro, MS SQL Maestro, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2009-04-24

Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions

View Available Dates and LocationsIn this five-day instructor-led course, you will learn to design and maintain business intelligence solutions for your organization using SQL Server 2008. You will learn how to use the SQL Server development tools to create Analysis Services databases and OLAP cubes. In addition,...

Tags: Business Intelligence, Microsoft SQL Server 2008, Solution, Microsoft SQL Server, Analysis, Databases, Enterprise Software, Software, Data Management

Training 2009-04-01

Best Practice: Optimizing the Cube Build Process in SAS 9.2

The loading and processing of the data into a cube needs to be controlled and optimized to get the best performance out of one's system and meet appropriate time window constraints that may be set by IT or the business user. The SAS OLAP Server 9.2 shows several performance improvements...

Tags: SAS Institute, Best Practice, SAS OLAP Server 9.2

White papers 2009-04-01

Multinational Dealer Gains Efficient Business Intelligence Solution

Mantrac Group, a multinational dealer that represents many leading companies including Caterpillar, deployed Microsoft SQL Server 2008 data management software to enhance its Business Intelligence BI. With this solution, Mantrac has accelerated data extraction, the building of multidimensional Online Analytical Processing OLAP cubes, and reporting. The company is phasing in...

Tags: OLAP, Microsoft Corp., Pricing, Business Intelligence, Tools & Techniques, Data Mining, Databases, Microsoft SQL Server 2008, Data Management, Enterprise Software, Marketing, Software, Management

Case studies 2009-04-01

Intelligencia Query for SQL 2005 3.0.23 (Windows)

Intelligencia Query for BIDS and Reporting Services delivers add-in functionality for Visual Studio that transforms the task of creating OLAP reports with Microsoft SQL Server Reporting Services. State-of-the-art query tools are combined with a custom data extension that understands how OLAP reporting should work. Implemented using the Microsoft Fluent user...

Tags: Query, OLAP, Microsoft Windows, Microsoft SQL Server 2005, iT-Workplace, Data Mining, Databases, Enterprise Software, Software, Data Management

Software downloads 2009-03-09

Implementing a BI Reporting Environment - Making Dashboards More OLAP Friendly

The Credit Corp reporting environment is used on a daily basis by the management team to track performance at all levels of the business. Taking advantage of SAS Enterprise BI Server (in particular SAS BI dashboards, SAS OLAP Server, and SAS Web Report Studio), users are able to get a...

Tags: Business Intelligence, OLAP, Environment, SAS Institute, Dashboard, Pricing, Data Mining, Databases, Marketing, Enterprise Software, Software, Data Management

White papers 2009-02-27

Identifying Complications and Overcoming Problems Using SAS Enterprise BI Server

The Open University in the United Kingdom has been involved in analysing, designing, and implementing a data warehouse system. There is nothing unusual about such a project, but the university had no exposure to the SAS9 suite of tools and has come across many problems and issues during the project...

Tags: SAS Institute, Server, SAS Enterprise BI Server

White papers 2009-02-27

DTM DB Stress 1.08.00 (Windows)

DTM DB Stress is a utility for stress testing the server parts of information systems and applications, as well as DBMSs and servers themselves. This tool allows you to create and configure a continuous set of requests to the server of the OLAP query execution and OLTP (adding, modifying and...

Tags: Information System, Server, Microsoft Windows, DTM DB Stress, Storage, Databases, Hardware, Enterprise Software, Software, Data Management

Software downloads 2009-01-22

New year fast approaching, and so is the next-generation enterprise data warehouse

This has been one of the most pivotal years in the evolution of the enterprise data warehousing EDW market. Every EDW vendor of note has firmly repositioned its go-to-market strategy around the appliance approach, with some also taking tentative steps into what is sure to be a key theme in...

Tags: Appliance, Amazon.com Inc., Microsoft Corp., I&KM, MPP, Business Intelligence, Databases, Service-Oriented Architecture (SOA), Tools & Techniques, Data Centers, Pricing, Programming Languages, Cloud Computing, Enterprise Software, Software, Data Management, Web Services, Management, Storage, Hardware, Marketing, Software Development, Software/Web Development, James Kobielus

Blog posts 2008-12-24

ContourCube .NET 4.0 (Windows)

ContourCube is an OLAP component for interactive reporting and data analysis. It offers embeddable OLAP technology for all Windows and Web applications based on relational data. Application powered with ContourCube allows users to create numerous nice-formed screen and printable reports in a minute. User can interact with data: slice and...

Tags: Data Source, Microsoft .NET, OLAP, Contour Components, ContourCube, Data Mining, Microsoft Windows, Databases, Enterprise Software, Software, Data Management, Operating Systems

Software downloads 2008-12-12