OLAP relations

#1

Hello, could you help me with this problem?

There are an application which by using OLAP extract data from a existing
database into a SAP server to execute querys from Excel, this database has
been created by a foreign enterprise. Currently, we have to make another
kind of reports and we need some additional relations which are not existing
in original database (we haven't permission to modificate database
structure).

Does somebody knows one way to create linked tables from SQL Server to OLAP
Provider to create a new database structure into SQL server with no lost of
information and funcionality on SAP server?

Thanks.

Víctor.

#2

See OPENROWSET or OPENQUERY in BOL might be helpful.

"VÃ*ctor" wrote:

Quote:

Hello, could you help me with this problem?

There are an application which by using OLAP extract data from a existing
database into a SAP server to execute querys from Excel, this database has
been created by a foreign enterprise. Currently, we have to make another
kind of reports and we need some additional relations which are not existing
in original database (we haven't permission to modificate database
structure).

Does somebody knows one way to create linked tables from SQL Server to OLAP
Provider to create a new database structure into SQL server with no lost of
information and funcionality on SAP server?

Thanks.

VÃ*ctor.

#3

Thanks, you've helped me a lot.

Víctor.

"James Ma" <JamesMa (AT) discussions (DOT) microsoft.com> escribió en el mensaje
news:75D56BC2-54B9-430B-9CFE-A23711074A1A (AT) microsoft (DOT) com...

Quote:

See OPENROWSET or OPENQUERY in BOL might be helpful.

"Víctor" wrote:

Hello, could you help me with this problem?

There are an application which by using OLAP extract data from a
existing
database into a SAP server to execute querys from Excel, this database
has
been created by a foreign enterprise. Currently, we have to make another
kind of reports and we need some additional relations which are not
existing
in original database (we haven't permission to modificate database
structure).

Does somebody knows one way to create linked tables from SQL Server to
OLAP
Provider to create a new database structure into SQL server with no lost
of
information and funcionality on SAP server?

Thanks.

Víctor.

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

OLAP relations

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

OLAP relations - 01-11-2006 , 10:43 AM

RE: OLAP relations - 01-11-2006 , 11:50 AM

Re: OLAP relations - 01-12-2006 , 02:24 AM