How to connect to remote cube with PivotView in code ?

Posted by: monstru on 3 August 2017, 4:01 pm EST

  • Posted 3 August 2017, 4:01 pm EST

    Hello !

    I find example for connect to local cube. how can i connect to remote cube in web application ?
  • Replied 3 August 2017, 4:01 pm EST

    MonsterU,

    Could you please clarify further what you mean exactly by a remote cube? Are you trying to a SSAS Cube in a Web Application?

    Best Regards,
    Abhishel
  • Replied 3 August 2017, 4:01 pm EST

    yes.

    this is example connect to cube, stored in local file NwindLocalCube.ddacube



    Me.LocalCubeDataSource1.LocalCubeFile = "C:\Users\YourUserName\Documents\GrapeCity\ActiveAnalysis\DataSources\NWind\NwindLocalCube.ddacube"

    Me.LocalCubeDataSource1.Connect()

    Me.PivotView1.DataSource = LocalCubeDataSource1



    how can i connect to cube on Analysis Services - i know only connection string .
  • Replied 3 August 2017, 4:01 pm EST

    monstrU,

    Please go through the "To connect to a SQL Server Analysis Services (MDX) data cube using code" section of this link to get more information regarding how to connect ActiveAnalysis to SSAS Cube.

    http://helpcentral.componentone.com/nethelp/ActiveAnalysis2WebHelp/ConnectToDataSourcesWinForms.html
    Best Regards,
    Abhishek
  • Replied 3 August 2017, 4:01 pm EST

    <BLOCKQUOTE><table width="85%"><tr><td class="txt4"><img src="/wp-content/uploads/CS_images/icon-quote.gif"> Abhishek Dutta wrote:</td></tr><tr><td class="quoteTable"><table width="100%"><tr><td width="100%" valign="top" class="txt4">monstrU,

    Please go through the "To connect to a SQL Server Analysis Services (MDX) data cube using code" section of this link to get more information regarding how to connect ActiveAnalysis to SSAS Cube.

    http://helpcentral.componentone.com/nethelp/ActiveAnalysis2WebHelp/webframe.html

    Best Regards,
    Abhishek
    </td></tr></table></td></tr></table></BLOCKQUOTE>



    Class MdxDataSource do not has method Connect- see you documentation



    http://www.datadynamics.com/Help/ActiveAnalysis/GrapeCity.ActiveAnalysis.Web~GrapeCity.ActiveAnalysis.Web.DataSources.MdxDataSource_members.html#MethodsBookmark
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels