I am trying to build a new application on the existing MSOLAP
applications.

I have two MSOLAP (SQL Server 2000) databases on two different servers
S1 and S2. Server S1 has sales data for the business group BG1 in a
cube named BG1-Sales with shared dimension ALL-Products-1. Similarly
server S2 has sales data for the business group BG2 in a cube named
BG2-Sales with shared dimension ALL-Products-2. The dimensions
ALL-Products-1 on S1 and ALL-Products-2 on S2 both have the same data.
This implies that whatever product information is available in
ALL-Products-1 shared dimension is also available in the shared
dimension ALL-Products-2 and vice versa.The base data is from two
ORACLE servers.

Basic requirement requirement is to do consolidated sales reporting for
both BG1 and BG2 from one OLAP source using Pivot Table Services in
Microsoft Excel 2003.

In order to achieve this we did the following

1. Created a Linked cube named Linked-BG2-Sales in S1 pointing to BG2
sales cube (BG2-Sales).
2. Processed the linked cube.
3. Created a virtual cube named Consolidated-Sales in S1 on
Linked-BG2-Sales and BG1-Sales.

The problem that I am facing is that by using any one of the
dimensions, ALL-Products-1 or ALL-Products-2, I am not able to browse
both BG1-Sales and BG2-Sales data, even though both the dimensions have
the same data. I can browse BG1-Sales using ALL-Products-1 dimension
and BG2-Sales using ALL-Products-2 dimension. But I cannot browse
BG2-Sales using ALL-Products-1 dimension and BG1-Sales using
ALL-Products-2 dimension. Ideally I should be able to browse both
BG1-Sales and BG2-Sales using only ALL-Products-1 dimension or only
ALL-Products-2 dimension since both the dimensions have the same data
(Member Key and Member column).

Please let me know how to handle this requirement in MSOLAP (SQL Server
2000).