Welcome to Sign in | Join | Help
in Search

Analysis Services Project

Last post 04-07-2010, 5:10 PM by katalyn. 10 replies.
Sort Posts: Previous Next
  •  03-22-2010, 7:18 PM 8121

    Analysis Services Project

    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:
  •  03-22-2010, 7:42 PM 8122 in reply to 8121

    Re: Analysis Services Project

    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)
  •  03-22-2010, 8:51 PM 8123 in reply to 8122

    Re: Analysis Services Project

    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?
  •  03-22-2010, 10:08 PM 8124 in reply to 8123

    Re: Analysis Services Project

    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)
  •  03-22-2010, 10:45 PM 8125 in reply to 8123

    Re: Analysis Services Project

    vedeti si daca aveti serviciul de analysis pornit!

    Ignat Andrei
    http://serviciipeweb.ro/iafblog
  •  03-22-2010, 10:49 PM 8126 in reply to 8124

    Re: Analysis Services Project

    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.
  •  03-22-2010, 10:59 PM 8127 in reply to 8126

    Re: Analysis Services Project

    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)
  •  03-23-2010, 3:41 PM 8129 in reply to 8127

    Re: Analysis Services Project

    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:
  •  03-23-2010, 5:33 PM 8130 in reply to 8129

    Re: Analysis Services Project

    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)
  •  03-29-2010, 3:26 PM 8154 in reply to 8129

    Re: Analysis Services Project

    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
  •  04-07-2010, 5:10 PM 8175 in reply to 8154

    Re: Analysis Services Project

    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.
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems