Welcome to
Sign in
|
Help
in
Business Intelligence - OLAP (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Business Intelligence - OLAP
»
Re: Analysis Services Project
Analysis Services Project
Last post 04-07-2010, 5:10 PM by
katalyn
. 10 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
03-22-2010, 7:18 PM
8121
DanLaurentiu
Joined on 02-16-2010
db_datawriter
Analysis Services Project
Reply
Quote
Salut! Mi-am instalat baza de date AdventureWorks. Pentru a face o analiza Olap(sa generez cubul OLAP pe acea baza de date),probabil am nevoie de un nou proiect Analysis Services project in Sql Server Management Studio.Daca da,care ar fi cauza pentru care la Templates nu am acest tip de proiect? Cum as putea sa o rezolv ? Multumesc
Filed under:
OLAP
Report abuse
03-22-2010, 7:42 PM
8122
in reply to
8121
ggciubuc
Joined on 03-18-2006
Bucharest
sysadmin
Re: Analysis Services Project
Reply
Quote
Se foloseste tool-ul ce se poate accesa cu Programs-->Microsoft SQL Server 2005(8)-->SQL Server Business Intelligence Developer Studio , cu SQL Server Management Studio se poate deschide o bd Analysis Services.
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
Report abuse
03-22-2010, 8:51 PM
8123
in reply to
8122
DanLaurentiu
Joined on 02-16-2010
db_datawriter
Re: Analysis Services Project
Reply
Quote
Am creat DataSource-ul,DataSourceView si Cubul dar primesc aceasta eroare:
The project could not be deployed to the 'LAURENTIU-PC' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.
Serverul LAURENTIU-PC este cel pe care am creat baza de date AdventureWorks. Cum se poate rezolva?
Report abuse
03-22-2010, 10:08 PM
8124
in reply to
8123
ggciubuc
Joined on 03-18-2006
Bucharest
sysadmin
Re: Analysis Services Project
Reply
Quote
Vedeti daca puteti intra prin Management Studio (se alege Analysis Services) pe server.
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
Report abuse
03-22-2010, 10:45 PM
8125
in reply to
8123
ignatandrei
Joined on 11-17-2006
Bucuresti
sysadmin
Re: Analysis Services Project
Reply
Quote
vedeti si daca aveti serviciul de analysis pornit!
Ignat Andrei
http://serviciipeweb.ro/iafblog
Report abuse
03-22-2010, 10:49 PM
8126
in reply to
8124
DanLaurentiu
Joined on 02-16-2010
db_datawriter
Re: Analysis Services Project
Reply
Quote
Din Management Studio cand urmeaza sa ma conectez si aleg Analysis Services am la server doar LAURENTIU-PC\SQLSERVER,nu si \SQLEXPRESS(pe cea din urma avand si baza de date). Pe SQLSERVER nu pot incarca baza de date-incercand din CMD(conform unui tutorial msdn de installing adventureworks 2008) imi da o eroare noua:
Msg 5133, Level 16, State 1, Server LAURENTIU-PC\SQLSERVER, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSS
QL\Data\AdventureWorks_Data.mdf" failed with the operating system error 3(failed
to retrieve text for this error. Reason: 15105).
Banui ca datorita faptului ca nu mi vede SQLEXPRESS e si motivul pentru care nu-mi ruleaza in Development Studio. In caz nu nu-mi puteti a un target de rezolvare,tind sa cred ca e o posibila nesincronizare intre instante anterior creata la rularea instalarii softurilor de sql server ,express etc.
Report abuse
03-22-2010, 10:59 PM
8127
in reply to
8126
ggciubuc
Joined on 03-18-2006
Bucharest
sysadmin
Re: Analysis Services Project
Reply
Quote
Asa cum vedeti
aici
la editia Express nu exista Analysis Services , deci daca vreti BI renunati la Express.
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
Report abuse
03-23-2010, 3:41 PM
8129
in reply to
8127
DanLaurentiu
Joined on 02-16-2010
db_datawriter
Re: Analysis Services Project
Reply
Quote
Ulterior am reusit sa importez baza de date AdventureWorks de pe SQLEXPRESS pe SQLSERVER( serverul de BI) insa tabelele nu mai sunt relationate. Aveti idee de ce? sau relationarea o voi face personalizat in Development Studio inainte de procesul in sine?
Filed under:
OLAP
Report abuse
03-23-2010, 5:33 PM
8130
in reply to
8129
ggciubuc
Joined on 03-18-2006
Bucharest
sysadmin
Re: Analysis Services Project
Reply
Quote
Relatiile sunt sunt materializate prin cheile primare si straine (constrangeri de integritate).
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
Report abuse
03-29-2010, 3:26 PM
8154
in reply to
8129
xmldeveloper
Joined on 01-18-2006
Bucharest, Romania
Rank NA
Re: Analysis Services Project
Reply
Quote
Ce va indica faptul ca tabelele nu mai sunt relationate?
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro
Report abuse
04-07-2010, 5:10 PM
8175
in reply to
8154
katalyn
Joined on 09-20-2006
Bucureşti
sysadmin
Re: Analysis Services Project
Reply
Quote
Importul si exportul de date nu este recomandat in acest caz. Pentru a copia o baza de date de pe o instanta pe alta (aceasi masina sau masini diferite) va recomand backup/restore, dettach/attach. (acest mecanism functioneaza pt ca incercati sa copiati o baza de date de pe o instanta cu o versiune inferioara la o versiune superioara, invers nu se poate si ar trebui folosit import/export iar apoi se poate opta pentru compararea obiectelor cu un tool special si unui script de modificare a diferentelor).
Cătălin D.
Report abuse