SQL Server Performance

visual basic tools for brows the cube

Discussion in 'Analysis Services/Data Warehousing' started by alsafar, Jul 4, 2004.

  1. alsafar New Member

    hi ever body<br />i have found a components in visual basic called olap manager which has two tools one of them used to browse the data cube i kow it from the tool name (cubhebrowser) but i could not used can any one help me using that tool <br />[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]
  2. vbkenya New Member

    Since I have not used/seen this tool before, I would be interested in knowing where exactly you found it. Is it an ActiveX control installed as part of the Analysis services setup?

    We could then help each other out. Thank you in advance.

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
  3. satya Moderator

  4. alsafar New Member

    hello
    i found the components called (olap maneger) after instuling the SQL-server 2000 this components has two tools one of them called cubebrowser you can test that by your self...
  5. satya Moderator

    I hope the MSDN page referred via email helped you in this regard and check for MSSQL home page for more details as help in Analysis services is limited.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. alsafar New Member

    Hi every body i found it !!!!!

    I found a way to use the way to browse the cube from visual basic.
    1. Add the components olap manager cube browser
    2. Add the tolls cubebrowser and text to the form
    3. Add the flowing connection to the load form code

    CubeBrowser1.ConnectWStr "LocalHost", "FoodMart 2000", "sales"
    ‘localhost is the server name, foodmart 2000 is the database name, sales is the cube name.
    Text1.Text = CubeBrowser1.ActiveCubeName

Share This Page