Appreciate your help on this

we have table called sales table in 15 different sites (different servers)
I try to create each site is one partition, couldn't let me do it.
Error : Analysis Server Error: Processing error [Object does not exist]
'Remo'

Sales table doesn’t have any key field

Example

Sales(site1 or location1)

Site , sitedescription, net price
Bamo bamosite 12
Bamo bamosite 15
Bamo bamosite 16

sales (site2 or location2)
Site , sitedescription, net price
Remo bamosite 10
Ramo bamosite 1
Ramo bamosite 2


how do i do this ?

Thanks for your help

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200610/1

Hi,

what I would try is on one Sql server, create a linked view from the
different server and be sure the keys between fact adn dim are
matching.

then in AS, you create the partition as normally...


Francis



meghana via SQLMonster.com wrote:

Thank you
If you look at below link, it doesn't talk about creating sql views,I try to
process remote partitions
This time I got different error: processed dimensions successfully then I
received
Error(-2147221411): Process operation failed; Time:10/20/2006 9:22:48 AM
can't I do this without creating sql view?

http://msdn.microsoft.com/library/de...vpart_0rub.asp

Cube 1996-1999 and its four partitions are defined on Analysis Server 1. The
data sources of the partitions specify the locations of the source data of
the partitions:

The source data for Partition 1996 is stored on SQL Server 1, which is
installed on the same computer as Analysis Server 1.


The source data for Partition 1997 is stored on SQL Server 2.

Example: Four-Partition Cube
The source data for Partition 1998 is stored on SQL Server 3.


The source data for Partition 1999 is stored on SQL Server 4.
Unlike partitions 1996, 1997, and 1998, Partition 1999 is defined as a remote
partition. Its aggregate data is stored on a different Analysis server
computer, Analysis Server 2. (Aggregate data is stored on the Analysis server
computer only if the partition's storage mode is multidimensional OLAP (MOLAP)
or hybrid OLAP (HOLAP); otherwise, data is stored in the same database as the
partition's source data.)



Francis.Incourt (AT) gmail (DOT) com wrote:
--
Message posted via http://www.sqlmonster.com