OLAP linked Server

OLAP linked Server

Post by William Chen [M » Tue, 07 May 2002 15:10:09



For your reference:

Q242025 INF: How to Set Up Security for Linked Server to OLAP Services
http://support.microsoft.com/support/kb/articles/q242/0/25.asp

Q218592 HOWTO: SQL Server 7 Distributed Query with OLAP Server
http://support.microsoft.com/support/kb/articles/q218/5/92.asp

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks,

William Chen

 
 
 

1. Linked OLAP Query from SQL Server 2000 to Analysis Server- Return Data Types

Here is a simple MDX query that I am executing to return multidimensional
data in table format using a linked query.
One of the problems I am facing is the return datatypes.
SQL Server converts all data values into ntext(4000) (Why is it allocating
so many chars). How can I return the values as char or varchar.
Further the measures are also returned as ntext instead of float.
Any help in modifying this query to fix the data conversion would be
much appreciated.

SELECT * INTO foobar FROM OPENQUERY(MTG_OLAP,
'Select
       {[Measures].[vsmm], [Measures].[Wtd Avg LTV]}  ON AXIS(0),
       {[Seasoning].[Age].Members} ON AXIS(1),
       {[LoanPurpose].[Lpurpose].Members} ON AXIS(2),
       {[PrepayPenalty].[Pp Flag].Members} ON AXIS(3),
       {[RelativeCouponLag3].[Rel Cpn3].Members} ON AXIS(4),
       { [LTV].[Ltv Bucket].Members} ON AXIS(5),
       {[BorrowerGrade].[Bgrade Mod].Members} ON AXIS(6),
       {[OrigBalance].[Obal Bucket].Members} ON AXIS(7),
       {[BeginDelinqStatus].[Bmba].Members} ON AXIS(8)      
FROM ResearchCube
WHERE
( [CouponType].[All CouponType].[Fixed] , [LienType].[All LienType].[1]) ' )
go

2. test

3. Reliable link to Oracle server (linked, server, oracle)

4. HELP! Can't connect to Oracle Server via ADO: ORA-00000: normal, successful completion

5. Remote Server -- Changing from Remote Server to Linked Server

6. SQL Date Formats

7. Problem connecting one SQL Server server to another SQL Server server

8. Access97 as front end

9. Linked Server Drivers: No OLAP OLE driver shown in Enterprise Manager

10. Linking SQL server 7 to AS400 using linked feature

11. Linked Server from SQL Server to Oracle

12. Linked Server to PostgreSQL in SQL server Problem

13. SQL Server CE as Linked Server?