private void SearchFiltersButton_Click(object sender, EventArgs e) { // First clear the existing members AvailableFiltersListBox.Items.Clear(); try { foreach (object o in SearchFiltersListBox.SelectedItems) { List <string> members = CubeQueries.getMembersByHierarchy(o.ToString(), Datasource1Textbox.Text, Catalog1Textbox.Text, Cube1Textbox.Text); foreach (string s in members) { AvailableFiltersListBox.Items.Add(s); } } } catch (ArgumentException ae) { if (ae.Message.Contains("A data source must be specified in the connection string.")) { MessageBox.Show("Empty connection information entered.\n" + ae.Message, "Connection Error.", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { throw ae; } } catch (Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException ace) { if (ace.Message.Contains("A connection cannot be made.")) { MessageBox.Show("Unable to connect to server. Check your connection or connection information.\n" + ace.Message, "Connection Error.", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { throw ace; } } catch (Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException aere) { if (aere.Message.Contains("Either the user,") && aere.Message.Contains("does not have access to the ") && aere.Message.Contains("database, or the database does not exist.")) { MessageBox.Show("Unable to connect to find catalog.\n" + aere.Message, "Connection Error.", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { throw aere; } } }
private void GetCubeInfoButton_Click(object sender, EventArgs e) { try { List <string> measureNames = CubeQueries.getAllMeasures(Datasource1Textbox.Text, Catalog1Textbox.Text, Cube1Textbox.Text); List <string> attributeNames = CubeQueries.getAllAttributes(Datasource1Textbox.Text, Catalog1Textbox.Text, Cube1Textbox.Text); List <string> searchFilters = CubeQueries.getVisibleHierarchiesByCube(Datasource1Textbox.Text, Catalog1Textbox.Text, Cube1Textbox.Text); clearAvailableListboxes(); foreach (string s in measureNames) { AvailableMeasuresListBox.Items.Add(s); } foreach (string s in attributeNames) { AvailableAttributesListbox.Items.Add(s); } foreach (string s in searchFilters) { SearchFiltersListBox.Items.Add(s); DateAttributeCombobox.Items.Add(s); } } catch (ArgumentException ae) { if (ae.Message.Contains("A data source must be specified in the connection string.")) { MessageBox.Show("Empty connection information entered.\n" + ae.Message, "Connection Error.", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { throw ae; } } catch (Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException ace) { if (ace.Message.Contains("A connection cannot be made.")) { MessageBox.Show("Unable to connect to server. Check your connection or connection information.\n" + ace.Message, "Connection Error.", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { throw ace; } } catch (Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException aere) { if (aere.Message.Contains("Either the user,") && aere.Message.Contains("does not have access to the ") && aere.Message.Contains("database, or the database does not exist.")) { MessageBox.Show("Unable to connect to find catalog.\n" + aere.Message, "Connection Error.", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { throw aere; } } }