Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    3

    Unanswered: restrict local cube

    Does anyone know how can we prevent users from creating offline/local cube (in Excel) from our OLAP/Analysis Service server ?
    Thank you.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm almost certain that this isn't possible. There are ways that you can make it a bit more difficult, but those will only annoy your users.

    If you find some way to do this, please let me know how you went about it.

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Deny them access to the cubes ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Oct 2002
    Posts
    3
    Quote Originally Posted by Enigma
    Deny them access to the cubes ???
    No, users still allowed to perform live access but must be prevented from creating local (offline) cube which they can bring home.

    I'm aware of a new property introduced on SQL 2000 SP3a named RESTRICTED CLIENT but not sure if it has anything to do with our need nor how to set it up.

Posting Permissions

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