SAP Blogs

Reuben Cox

Reuben Cox SAP Employee  
Business Card
Company: SAP
RSS 1.0 Feed for SAP Weblogs by this person.

Starting at the beginning of 2010 I work in development support for the NetWeaver web infrastructure components specializing in Internet Communication Manager (ICM), SAP Web Dispatcher, SAP Router, Network Interface (NI). I was previously an employee at Business Objects (previously Crystal Decisions) since 2001. I initially started off as a developer on the OLAP data access team working on data drivers for Microsoft Analysis services and later SAP BW and Essbase. I've have worked on the OLAP data consumption for various Business Objects products including OLAP Intelligence, Voyager, Web Intelligence and Crystal Reports. Starting in 2007 I worked as a program manager writing feature specifications for upcoming releases and assisting customers with their OLAP deployments.

URL Filtering in the SAP ICM and Web Dispatcher
A brief overview of the URL filtering functionality available in the SAP Web Dispatcher and Internet Communication Manager (ICM). Jul. 29, 2010
Comments: 0   Rank: 13838   Page Views: 1455 (Stats updated nightly)

Collecting performance statistics for Voyager workspaces
Do you have a Voyager workspace that is taking a long time to load? This article gives instructions for collecting some performance statistics which could identify a bottleneck. Dec. 18, 2009
Comments: 0   Rank: 14109   Page Views: 1393 (Stats updated nightly)

Why are my calculations wrong? (Redux)
I had previously written a very technically focused description of what values you can expect when two calculations intersect in a Voyager workspace. I have since come up with a much less technical explanation comparing Voyager to what you can do with Excel formulas. Dec. 18, 2009
Comments: 0   Rank: 14148   Page Views: 1385 (Stats updated nightly)

Understanding and configuring memory settings for Voyager's MDAS server
A Voyager deployment contains a mid-tier server called the Multi-Dimensional Analysis Services (MDAS) server. This server is a Java process but also contains a significant C++ part. The fact that the server is a hybrid of Java and C++ has some important consequences for the way memory is used and most importantly has an impact on how much memory should be given to the Java heap. Dec. 11, 2009
Comments: 0   Rank: 13819   Page Views: 1458 (Stats updated nightly)

Troubleshooting OLAP connectivity in Business Objects products
If you are setting up one of the Business Objects products to use an OLAP data source for the first time sometimes it doesn't 'just work'. This article contains a quick list of items to check and tests to perform to get your first OLAP connection working. Dec. 10, 2009
Comments: 0   Rank: 11108   Page Views: 2151 (Stats updated nightly)

Using SE37 to verify Netweaver meta-data used by Voyager
Voyager consumes data from Netweaver using the OLAP BAPI interface. Sometimes a useful trouble shooting tool is to verify the results the OLAP BAPI delivers with what can be seen in Voyager. Dec. 9, 2009
Comments: 0   Rank: 12516   Page Views: 1737 (Stats updated nightly)

OLAP Data Access Logging: Part 7 - Choosing the correct settings and example defaults
Part 7 of a 7 part series diving deep into configuration and use of logging from Business Objects' OLAP Data Access component  Dec. 7, 2009
Comments: 0   Rank: 12857   Page Views: 1651 (Stats updated nightly)

OLAP Data Access Logging: Part 6 - Assertions, Unix and 64 bit Windows
Part 6 of a 7 part series diving deep into configuration and use of logging from Business Objects' OLAP Data Access component  Dec. 7, 2009
Comments: 0   Rank: 13960   Page Views: 1423 (Stats updated nightly)

OLAP Data Access Logging: Part 5 - Log Formatting
Part 5 of a 7 part series diving deep into configuration and use of logging from Business Objects' OLAP Data Access component Dec. 7, 2009
Comments: 0   Rank: 14353   Page Views: 1342 (Stats updated nightly)

OLAP Data Access Logging: Part 4 - Query logging
Part 4 of a 7 part series diving deep into configuration and use of logging from Business Objects' OLAP Data Access component Dec. 4, 2009
Comments: 0   Rank: 13228   Page Views: 1569 (Stats updated nightly)

OLAP Data Access Logging: Part 3 - API call timings
Part 3 of a 7 part series diving deep into configuration and use of logging from Business Objects' OLAP Data Access component  Dec. 3, 2009
Comments: 0   Rank: 13794   Page Views: 1460 (Stats updated nightly)

OLAP Data Access Logging: Part 2 - Modules and Components
Part 2 of a 7 part series diving deep into configuration and use of logging from Business Objects' OLAP Data Access component Dec. 1, 2009
Comments: 0   Rank: 13085   Page Views: 1606 (Stats updated nightly)

OLAP Data Access Logging: Part 1 - Introduction and basic settings
Part 1 of a 7 part series diving deep into configuration and use of logging from Business Objects' OLAP Data Access component. Nov. 27, 2009
Comments: 2   Rank: 10596   Page Views: 2317 (Stats updated nightly)

Why are my calculations wrong?
Are your Voyager calculations showing the wrong values? It could be a solve order problem. This article explains what solve order is, how Voyager uses it and how to fix problems with solve orders. Nov. 13, 2009
Comments: 0   Rank: 11752   Page Views: 1962 (Stats updated nightly)

Understand the Matrix (of OLAP support in Business Objects products)
It has always been a non-trivial exercise to understand which OLAP data sources are supported in which Business Objects products on which operating system. Here is a handy summary. Nov. 12, 2009
Comments: 0   Rank: 11477   Page Views: 2035 (Stats updated nightly)

An introduction to Voyager logging
When a problem with a piece of software occurs the first diagnostic step is often to enable logging and examine the output. This article gives a brief overview of the various types of logging that are available in Voyager. Nov. 10, 2009
Comments: 0   Rank: 12661   Page Views: 1711 (Stats updated nightly)

Voyager, multi-tabbed browsers, http sessions, Ctrl N, errors, crashes and hangs
Voyager uses session scoped JSF Managed Beans. Understanding how this works is key to avoiding certain errors and, if you are not on the right patch level, crashes and hangs in the MDAS server. Nov. 3, 2009
Comments: 0   Rank: 11865   Page Views: 1923 (Stats updated nightly)

Using Voyager's auto save feature
Voyager has an auto save feature that prevents work being lost if a session timeout occurs. This article explains how the auto save feature works, how to configure when the auto save occurs and how to disable it. Oct. 22, 2009
Comments: 0   Rank: 13327   Page Views: 1552 (Stats updated nightly)

Extracting Voyager MDX queries
Sometimes it necessary to extract the MDX Voyager is executing so you can examine it and execute it in another tool. This article explains how to do that when the OLAP data source is Microsoft Analysis Services. Oct. 16, 2009
Comments: 0   Rank: 12006   Page Views: 1877 (Stats updated nightly)

Understanding formatted values in Voyager
Understand the difference between 'formatted' and 'actual' OLAP cell values, how Voyager handles them and how you can troubleshoot problems. Oct. 15, 2009
Comments: 0   Rank: 12951   Page Views: 1630 (Stats updated nightly)

Voyager: Capturing MDX timings using SQL Profiler
When deploying Voyager there are times where you need to troubleshoot performance problems. Checking for long running MDX statements is one of those trouble shooting steps. This article describes how to use SQL Server Profiler to capture MDX execution times. Oct. 13, 2009
Comments: 0   Rank: 12628   Page Views: 1708 (Stats updated nightly)

Voyager: Understanding scrolling in the crosstab
The Voyager crosstab implements a data loading strategy that balances the need for quick scrolling against query execution time and memory usage when fetching large amounts of data from the OLAP server. Voyager uses the concept of fetching a data window of a certain size within which scrolling is fast. The size of this data window can be configured therefore it is important to understand how Voyager implements scrolling so as to choose the correct size data window for Voyager to operate effectively in a particular scenario. Oct. 9, 2009
Comments: 2   Rank: 12445   Page Views: 1751 (Stats updated nightly)

Voyager: Incorrect member drill states
Sometimes when using Voyager against Microsoft Analysis Services members that are drilled down will appear drilled up. This explains in what circumstance this can happen, why it happens, and how you can work around the problem. Sep. 30, 2009
Comments: 0   Rank: 13294   Page Views: 1554 (Stats updated nightly)