using (AdomdConnection mdConn = new AdomdConnection())
            {
                mdConn.ConnectionString = "provider=msolap;Data Source=(local);initial catalog=SalesAnalysis;";
                mdConn.Open();

                AdomdCommand mdCommand = mdConn.CreateCommand();

                mdCommand.CommandText = @"SELECT 
                                        {[Time Dim].[Year].MEMBERS} ON COLUMNS,
                                        {[Country Dim].[Country Name].MEMBERS} ON ROWS
                                        FROM [Sales DB]
                                        WHERE ([Measures].[Sales])";

                DataSet ds = new DataSet();
                try
                {
                    AdomdDataAdapter ada = new AdomdDataAdapter(mdCommand.CommandText, mdConn);
                    ada.Fill(ds);
                    resultGridView.DataSource = ds.Tables[0];
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }

                mdConn.Close();
            }