Tell Me About Your DW Development Life Cycle

From: Deb Wolfe (thedebwolfe_at_hotmail.com)
Date: 05/05/04

  • Next message: Alexander Nenashev: "URGENT: problem with dimension members security in russian!" 
    Date: Tue, 4 May 2004 19:13:13 -0700

    What are some good ways to get development cubes into
    production?

    I currently use a developer's edition of SQL Server 2000
    with Analysis Services. In the past couple of years I
    have been responsible for running reports. The plan now
    is to let users run reports for themselves by connecting
    to the Enterprise version at the client site via some
    simple client tool.

    The database is relatively small--just over 1 gig. There
    are about 250K members (students) and 2 million facts
    (test scores). I am responsible for doing ETL and
    building cubes.

    What sounds good?
    1) Build everything locally and then just copy the .mdf
    and .cab files to the Enterprise server.

    2) Connect to the production server via VPN and run the
    ETL statements against that database. Connect to the
    Analysis Services Server and rebuild cubes. (Currently I
    get an error message when trying to connect to the remote
    server via Analysis Services although I can see it in
    Enterprise Manager).

    3) And the other logical possiblity--local database
    (which is then copied to production) but remote analysis
    services cube building.

  • Next message: Alexander Nenashev: "URGENT: problem with dimension members security in russian!"

    Relevant Pages

    • Analysis Services
      ... with the Analysis Services of that version, in a Production Server... ... We don`t have any problem to register the OLAP Production Server in the ...
      (microsoft.public.sqlserver.olap)
    • Business Intelligencia and the Authentication mountain
      ... analysis services on the production server? ... Just in case the server is ... What do I use as the connection in my ETL process at the point ... I am currently using the "Analysis Services ...
      (microsoft.public.sqlserver.datawarehouse)
    • Re: Installation Question
      ... What is the recommended server configuration for an organization that wishes to use all three applications in a production environment? ... > For Analysis Services, if you use Analysis Manager and right-click on the ... > will see the high and low memory allocation which Analysis Services will ...
      (microsoft.public.sqlserver.olap)
    • Cube access problem
      ... In a Analysis Services ... server there is a series of cubes with their permissions of access ... because the server does not allow the access him ... permissions without changing nothing, everything works OK and the user ...
      (microsoft.public.sqlserver.olap)
    • Analysis Services Security
      ... I have created several cubes on Analysis Services and am ... trying to have a user access the cube through Excel pivot ... server 'ServerName' OLAP Server error: ...
      (microsoft.public.sqlserver.security)