dbTalk Databases Forums  

Data Source View - Copy from OLAP to Reporting?

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


Discuss Data Source View - Copy from OLAP to Reporting? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Glen
 
Posts: n/a

Default Data Source View - Copy from OLAP to Reporting? - 01-12-2006 , 03:46 AM






I have a Data Source View in my Analysis Services Project (2005) project.

Now, I want to enable reporting on it.

Is there any way to export/copy/use that Data Source View in a Report Model
Project ?

I haven't found a way.

In Report Model projects, you can view the text of a Data Source View, but I
can't view the text in the Analysis Services project...

Do I have to recreate the entire Data Source from scratch?

Thanks,
Glen



Reply With Quote
  #2  
Old   
Steven Cheng[MSFT]
 
Posts: n/a

Default RE: Data Source View - Copy from OLAP to Reporting? - 01-13-2006 , 01:27 AM






Hi Glen,

Welcome.
As for the vs 2005 Analysis Service project and ReportModel projects, they
manage the DataSource and DataSourceViews through the .ds and .dsv files.
So if you want to use the same datasource or datasourceview configuration
in new Report Module projects from another existing Analysis project, you
can consider using the Add Existing items and choose the .ds or .dsv files
from disk, the project will copy and include them in self ....

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)



--------------------
Quote:
From: "Glen" <glen (AT) community (DOT) nospam
Subject: Data Source View - Copy from OLAP to Reporting?
Date: Thu, 12 Jan 2006 02:46:47 -0700
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Message-ID: <#Ueac01FGHA.3120 (AT) TK2MSFTNGP10 (DOT) phx.gbl
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host: s142-179-147-100.ab.hsia.telus.net 142.179.147.100
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:66135
X-Tomcat-NG: microsoft.public.sqlserver.olap

I have a Data Source View in my Analysis Services Project (2005) project.

Now, I want to enable reporting on it.

Is there any way to export/copy/use that Data Source View in a Report
Model
Project ?

I haven't found a way.

In Report Model projects, you can view the text of a Data Source View,
but I
can't view the text in the Analysis Services project...

Do I have to recreate the entire Data Source from scratch?

Thanks,
Glen





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.