Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tresgatos

    Front end tools to access MS Analysis Server cubes

    Is web access important? or are you building custom clients? I have worked with a tool called alphablox before for doing custom web front-ends. You might check them out.
  2. tresgatos

    DW model for Retailbanking

    I used to work for NCR, and they sold a retail banking data model and were capable of providing consulting to go with it. Of course they would then try to sell you teradata :) But the data model was not teradata specific as I recall. I wish I could give a contact... but alas I can't. I bet you...
  3. tresgatos

    Supporting Alternate Hierarchies?

    Hi, I have been tasked with providing UI support for displaying alternate hierarchies. For example, we have a test cube that has Time.Fiscal and Time.Calendar. The basic request from my customer says, "if you show me Time.Calendar then hide Time.Fiscal (and vice versa)" Since I am...
  4. tresgatos

    Multi Dimensional Modelling in Teradata

    And one more thing.... If you are using ODBC to talk to teradata, I don't see why you can't build cubes pretty easily using MS Analysis Services. I haven't tried it, but people have used it to work with Oracle, so I don't know why it should be any harder to use it with teradata. That would be...
  5. tresgatos

    Multi Dimensional Modelling in Teradata

    Microstrategy has continued to develop the product. They have strong ROLAP support for teradata. And thanks to the teracube software purchased from NCR you can now talk to microstategy using OLEDB/MDX.
  6. tresgatos

    Accessing Roles Permissions via DSO

    I have done this using the code below. However, one pitfall you might run in to (if memory serves) is that you are running this as your all-powerful administrator self, as as a result have no limitations. Make sure that the user you test on is a wimpy non-administrative, local user. (you are...
  7. tresgatos

    Making cell level security work?

    Anybody using cell level security successfully? I am having trouble. I set up a user that I know is not an olapadministrator I set the user so that it can only see store.CurrentMember.Name = 'CA' (in the foodmart sales cube) I test the cell level security. It seems to work from the admin...
  8. tresgatos

    Getting at cell level security?

    Actually, I _was_ missing something. :) it is under the role object. So thanks anyway.
  9. tresgatos

    Getting at cell level security?

    It doesn't appear possible to examine the cell level (or dimension level) security settings from VB and/or DSO. Or am I missing something? Any ideas for getting to this info from a program?
  10. tresgatos

    Pros and cons of choosing MS OLAP Services

    why would anyone pay big money for similar products? Well, as good as Analysis Services is (and it is _very_ good) here's an issue or two: It has this tendency to lock your enterprise into using MS infrastructure. For example the fact that you are forced to use the MS Lanman based...

Part and Inventory Search

Back
Top