Post reply

Analysis services and Management Studio

  • May 10, 2007 at 2:13 am

    #176340

    Hi All

    I have a problem with sql server 2005. In analysis services in management stuido I can only create Database but I cannot do anything else. Not even assign data source etc. NOTHING!

    When I do a project in BI it is okay but I can not see also what I created in Management studio analysis services. I feel I am missing something. Please help

    Yisehaq

  • May 10, 2007 at 2:50 pm

    #705669

    The objects (cubes, dimensions, etc) are created and published from BIDS. After you create the project, deploy it to the server. In BIDS, go to project properties, then deployment, set the server and database in target fields.

    From SSMS you can process the objects once they are published.

  • May 10, 2007 at 11:59 pm

    #705726

    so the good old sql 2000 days are over. Thanks

  • May 11, 2007 at 10:00 am

    #705897

    Well, technically, you *could* create DB's, Cubes, dimensions etc from within SSMS but you'd have to be pretty well versed at writing XMLA scripts.

    Steve.

  • May 14, 2007 at 2:29 am

    #706137

    Thanks, I also have some cubes of sql2K. can you tell me how I could import them?

     

  • May 14, 2007 at 7:54 am

    #706224

    This link should give you a heads up on where to start, note it also has a link to the Migration Considerations, really worthwhile reading if you've got anything but very vanilla/standard cubes in AS2000.

     

    Steve.

  • May 14, 2007 at 9:25 am

    #706264

    Thanks a lot Steve

  • June 7, 2007 at 12:31 pm

    #711496

    Hi Steve

    I am working on a project where we hav eto generate dimnsions and cubes using XML query, could u please let me know from where to start first?

    i dont get whats xsd,xi stands for if u look the first line of XML code in the designer of analysis serv

    waiting for the reply

    thanks

  • June 7, 2007 at 10:10 pm

    #711583

    Is there no way you can use the object model instead? 

    If you really have to use an XML approach then it will definitely help if you can use another object model (like the xml objects such as xml writer etc) that come with languages like c# (but again, if you can use C#, then why not use the AS object model?)  For reference, what you're probably seeing is the name space declaration. 

     

    Steve.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply