creating a cube in the same Analysis Server but different database

#1

I have 2 databases NZDF DW which contains the Sales Cube and JDE Finance
which contains the CostAnalyser cube. These are both on the same Analysis
server. I am trying to use the lookupcube function to return a value from the
CostAnalyser Cube to the Sales Cube. The linked cube doesnt work because the
subscription and publishing servers are the same. I cant create a virtual
cube because the costAnalyser cube doesnt show up on the list of cubes.

Does any one else have any suggestions?

Thanks

#2

I was trying to avoid those options. But thanks for a quick response anyway.

"Jéjé" wrote:

Quote:

choice 1:
create your costanalyser cube (and all its related dimensions with dedicated
names, not shared dimensions) in the same database as you sales cube.

then you can use the lookupcube formula

choice 2:
load youir costanalyser source table in the same source server and use the
same dimensions as your sales cube (or use views and linked servers if your
2 SQL databases are under SQL server or any ODBC compliant database).
create the costanalyser cube into the same database as your sales cube and
finally create a virtual cube.
in this case you'll use some shared dimensions, so you simplify your model
and expand your capabilities.

this option provides a better data quality because you'll insure that shared
dimensions are common dimensions, so a store is the same store... (same
name, same ID...)

"smisich" <smisich (AT) discussions (DOT) microsoft.com> wrote in message
news:B3813A4D-72BA-46E2-930B-8E914996416C (AT) microsoft (DOT) com...
I have 2 databases NZDF DW which contains the Sales Cube and JDE Finance
which contains the CostAnalyser cube. These are both on the same Analysis
server. I am trying to use the lookupcube function to return a value from
the
CostAnalyser Cube to the Sales Cube. The linked cube doesnt work because
the
subscription and publishing servers are the same. I cant create a virtual
cube because the costAnalyser cube doesnt show up on the list of cubes.

Does any one else have any suggestions?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

creating a cube in the same Analysis Server but different database

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

creating a cube in the same Analysis Server but different database - 08-11-2005 , 05:51 PM

Re: creating a cube in the same Analysis Server but different data - 08-11-2005 , 06:59 PM