Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    Nuernberg, Germany
    Posts
    36

    Unanswered: MS OLAP job (dimension- and cube-update) without SQL-Server-Agent

    Hi all,

    I want to solve the following problem.

    There is a MS SQL Server with a Data-Warehouse.
    I build on this Server an MS OLAP Cube which is
    used by our OLAP Tool Q4bis.

    Some users want to use this cube offline
    (especially the CEO !!!)

    So I got two "railways to heaven"

    1. Cubebuilder:
    Making .CUB-Files on the server and copy them to
    harddisk of offline user.

    disadvantages:
    I heard about some size and performance problems
    when using CUB-Files.
    I dont know how to automate Cubebuilder.exe
    I have to automate the copy *.cub - file within the LAN.

    2. Second MS OLAP installation on offline PC:

    There it goes:

    How do I schedule
    a) update dimensions
    b) update cube
    without(!!!) the MS SQL Server Agent?

    (Automation with the MS SQL Server Agent is quit easy and is running
    on the server mentioned above)

    thanks for any hints

    Michael

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Check out this page on creating local cubes:

    http://msdn.microsoft.com/library/de...eties_2rsj.asp

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Sep 2003
    Location
    Nuernberg, Germany
    Posts
    36
    Dear rhigdon,

    thank you for that link!
    I think it will help me solving that issue.

    While reading a new idea entered my mind:

    What if the "target"-PC will share a folder and the server
    (with MS SQL Server Agent running) will write directly over the
    local network into the shared path \\computername\sharename ....
    So the "offline"-user could use this CUB-File after leaving the
    LAN.
    I could automate this job and the "only" thing to be shure of
    is that the client is in the LAN when the job will run.

    Or:
    Im going to create the CUB-File anyway local on the server machine
    and some batch-job is prompting for
    the copy.
    Like:
    "New CUB-File available.
    Do you want to update now?"

    I will give you feedback after testing this
    (if youre interested)

    regards

    Michael


    Originally posted by rhigdon
    Check out this page on creating local cubes:

    http://msdn.microsoft.com/library/de...eties_2rsj.asp

    HTH

  4. #4
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    I would love to hear your findings, I don't use local cubes, but definitely see the possibilities.

    GL
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  5. #5
    Join Date
    Sep 2003
    Location
    Nuernberg, Germany
    Posts
    36
    Hi Ray,

    my partner and I decided to use first the following way:

    Backup the Cube-File on the server into a shared path.
    Copy (pull) the file to the laptop-harddisk.
    Restore it there into the local MS OLAP installation.
    (This will give also the advantage to save monthly stands for
    comparisons)

    I did a screenshot-docu for that process even the CEO could handle... ;-)

    Now Im looking for a way to automate the process
    of backing up the MS OLAP databases.

    any ideas?

    regards

    Michael

  6. #6
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Do you mean backup of the OLAP cubes or backup of the mart/warehouse that the cubes are derived from?

    For the mart/warehouse you can use standard SQL backups, for the OLAP cube data/store you can use the command "msmdarch", see BOL for full syntax.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •