public override void Exec()
{
ProjectItem piCurrent = null;
try
{
listPackageProperties = new List<PackageProperties>();
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = ((UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0));
SolutionClass solution = hierItem.Object as SolutionClass;
if (hierItem.Object is EnvDTE.Project)
{
EnvDTE.Project p = (EnvDTE.Project)hierItem.Object;
Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectExt projExt = (Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectExt)p;
this.DatabaseName = "Project: " + p.Name;
try
{
using (WaitCursor cursor1 = new WaitCursor())
{
int iProgress = 0;
ApplicationObject.StatusBar.Animate(true, vsStatusAnimation.vsStatusAnimationGeneral);
foreach (ProjectItem pi in p.ProjectItems)
{
ApplicationObject.StatusBar.Progress(true, "Scanning package " + pi.Name, iProgress++, p.ProjectItems.Count);
string sFileName = pi.Name.ToLower();
if (!sFileName.EndsWith(".dtsx")) continue;
piCurrent = pi;
this.PackagePathPrefix = pi.Name;
PackageProperties props = GetPackageProperties(pi);
if (props == null) continue;
listPackageProperties.Add(props);
}
}
}
finally
{
try
{
ApplicationObject.StatusBar.Animate(false, vsStatusAnimation.vsStatusAnimationGeneral);
ApplicationObject.StatusBar.Progress(false, "", 1, 1);
}
catch { }
}
}
else if (solution != null)
{
this.DatabaseName = "Solution: " + System.IO.Path.GetFileNameWithoutExtension(solution.FullName);
try
{
this.DatabaseName = "Solution: " + solution.Properties.Item("Name").Value;
}
catch { }
try
{
using (WaitCursor cursor1 = new WaitCursor())
{
ApplicationObject.StatusBar.Animate(true, vsStatusAnimation.vsStatusAnimationGeneral);
foreach (EnvDTE.Project p in solution.Projects)
{
Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectExt projExt = (Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectExt)p;
if (projExt.Kind == BIDSProjectKinds.SSIS)
{
int iProgress = 0;
foreach (ProjectItem pi in p.ProjectItems)
{
ApplicationObject.StatusBar.Progress(true, "Scanning project " + p.Name + " package " + pi.Name, iProgress++, p.ProjectItems.Count);
string sFileName = pi.Name.ToLower();
if (!sFileName.EndsWith(".dtsx")) continue;
piCurrent = pi;
this.PackagePathPrefix = p.Name + "\\" + pi.Name;
PackageProperties props = GetPackageProperties(pi);
if (props == null) continue;
listPackageProperties.Add(props);
}
}
}
}
}
finally
{
try
{
ApplicationObject.StatusBar.Animate(false, vsStatusAnimation.vsStatusAnimationGeneral);
ApplicationObject.StatusBar.Progress(false, "", 1, 1);
}
catch { }
}
}
ReportViewerForm frm = new ReportViewerForm();
frm.ReportBindingSource.DataSource = this.listPackageProperties;
frm.Report = "SSIS.SortablePackageProperties.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "BIDSHelper_PackageProperties";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = frm.Report;
frm.Caption = "Sortable Package Properties Report";
frm.WindowState = FormWindowState.Maximized;
frm.Show();
}
catch (DtsRuntimeException ex)
{
if (ex.ErrorCode == -1073659849L)
{
MessageBox.Show((piCurrent == null ? "This package" : piCurrent.Name) + " has a package password. Please open the package designer, specify the password when the dialog prompts you, then rerun the Sortable Package Properties report.\r\n\r\nDetailed error was:\r\n" + ex.Message + "\r\n" + ex.StackTrace, "BIDS Helper - Password Not Specified");
}
else
{
MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace, "BIDS Helper - Error" + (piCurrent == null ? string.Empty : " scanning " + piCurrent.Name));
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace, "BIDS Helper - Error" + (piCurrent == null ? string.Empty : " scanning " + piCurrent.Name));
}
}
private void openReportWithAllDimensionsToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
List<VisualizeAttributeLatticeImageForReport> images = new List<VisualizeAttributeLatticeImageForReport>();
foreach (Microsoft.AnalysisServices.Dimension d in dimension.Parent.Dimensions)
{
Bitmap img = VisualizeAttributeLattice.Render(d, VisualizeAttributeLattice.LatticeLayoutMethod.DeepestPathsFirst, showOnlyMultilevelRelationshipsToolStripMenuItem.Checked);
images.Add(new VisualizeAttributeLatticeImageForReport(d.Name, img));
img.Dispose();
}
ReportViewerForm frm = new ReportViewerForm();
frm.ReportBindingSource.DataSource = images;
frm.Report = "SSAS.VisualizeAttributeLattice.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "VisualizeAttributeLatticeImageForReport";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = "SSAS.VisualizeAttributeLattice.rdlc";
frm.Caption = "Visualize All Attribute Lattices";
frm.Show();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override void Exec()
{
try
{
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = (UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0);
ProjectItem projItem = (ProjectItem)hierItem.Object;
Cube cub = (Cube)projItem.Object;
ReportViewerForm frm = new ReportViewerForm();
frm.ReportBindingSource.DataSource = PrinterFriendlyDimensionUsage.GetDimensionUsage(cub);
frm.Report = "SSAS.PrinterFriendlyDimensionUsage.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "BIDSHelper_DimensionUsage";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = "BIDSHelper.PrinterFriendlyDimensionUsage.rdlc";
frm.Caption = "Printer Friendly Dimension Usage";
frm.Show();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override void Exec()
{
try
{
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = (UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0);
ProjectItem projItem = (ProjectItem)hierItem.Object;
DataSourceView dsv = (DataSourceView)projItem.Object;
IterateDsvColumns(dsv);
ReportViewerForm frm = new ReportViewerForm();
frm.ReportBindingSource.DataSource = usedColumns;
frm.Report = "SSAS.UsedColumns.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "BIDSHelper_UsedColumn";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = "SSAS.UsedColumns.rdlc";
frm.Caption = "Used Columns Report";
frm.WindowState = FormWindowState.Maximized;
frm.Show();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override void Exec()
{
ProjectItem piCurrent = null;
try
{
listNonDefaultProperties = new List<NonDefaultProperty>();
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = ((UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0));
SolutionClass solution = hierItem.Object as SolutionClass;
EnvDTE.Project p = GetSelectedProjectReference();
if (p != null)
{
Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectExt projExt = (Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectExt)p;
if (projExt.Kind == BIDSProjectKinds.SSAS)
{
Database db = (Database)p.Object;
ScanAnalysisServicesProperties(db);
}
else
{
this.DatabaseName = "Project: " + p.Name;
this.SSASProject = false;
try
{
using (WaitCursor cursor1 = new WaitCursor())
{
int iProgress = 0;
ApplicationObject.StatusBar.Animate(true, vsStatusAnimation.vsStatusAnimationGeneral);
Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
foreach (ProjectItem pi in p.ProjectItems)
{
ApplicationObject.StatusBar.Progress(true, "Scanning package " + pi.Name, iProgress++, p.ProjectItems.Count);
string sFileName = pi.Name.ToLower();
if (!sFileName.EndsWith(".dtsx")) continue;
piCurrent = pi;
this.PackagePathPrefix = pi.Name;
Package package = GetPackageFromIntegrationServicesProjectItem(pi);
ScanIntegrationServicesProperties(package);
}
}
}
finally
{
try
{
ApplicationObject.StatusBar.Animate(false, vsStatusAnimation.vsStatusAnimationGeneral);
ApplicationObject.StatusBar.Progress(false, "", 1, 1);
}
catch { }
}
}
}
else if (solution != null)
{
this.DatabaseName = "Solution: " + System.IO.Path.GetFileNameWithoutExtension(solution.FullName);
try
{
this.DatabaseName = "Solution: " + solution.Properties.Item("Name").Value;
}
catch { }
this.SSASProject = false;
try
{
using (WaitCursor cursor1 = new WaitCursor())
{
ApplicationObject.StatusBar.Animate(true, vsStatusAnimation.vsStatusAnimationGeneral);
foreach (EnvDTE.Project proj in solution.Projects)
{
Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectExt projExt = (Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectExt)proj;
if (projExt.Kind == BIDSProjectKinds.SSIS)
{
int iProgress = 0;
Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
foreach (ProjectItem pi in proj.ProjectItems)
{
ApplicationObject.StatusBar.Progress(true, "Scanning project " + proj.Name + " package " + pi.Name, iProgress++, proj.ProjectItems.Count);
string sFileName = pi.Name.ToLower();
if (!sFileName.EndsWith(".dtsx")) continue;
piCurrent = pi;
this.PackagePathPrefix = proj.Name + "\\" + pi.Name;
Package package = GetPackageFromIntegrationServicesProjectItem(pi);
ScanIntegrationServicesProperties(package);
}
}
}
}
}
finally
{
try
{
ApplicationObject.StatusBar.Animate(false, vsStatusAnimation.vsStatusAnimationGeneral);
ApplicationObject.StatusBar.Progress(false, "", 1, 1);
}
catch { }
}
}
else
{
ProjectItem pi = (ProjectItem)hierItem.Object;
piCurrent = pi;
Package package = GetPackageFromIntegrationServicesProjectItem(pi);
this.DatabaseName = "Package: " + package.Name;
this.SSASProject = false;
this.PackagePathPrefix = string.Empty;
ScanIntegrationServicesProperties(package);
}
//clear the cache
this.packageDefault = null;
this.dictCachedDtsObjects.Clear();
if (listNonDefaultProperties.Count == 0)
{
MessageBox.Show("No properties set to non-default values were found.", "BIDS Helper - Non-Default Properties Report");
return;
}
//pop up the form to let the user exclude properties from showing on the report
List<string> listExcludedProperties = new List<string>(this.ExcludedProperties.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries));
BIDSHelper.SSAS.NonDefaultPropertiesSelectionForm selector = new BIDSHelper.SSAS.NonDefaultPropertiesSelectionForm();
foreach (NonDefaultProperty prop in listNonDefaultProperties)
{
if (!selector.listProperties.Items.Contains(prop.PropertyName))
{
bool bChecked = !listExcludedProperties.Contains(prop.PropertyName);
selector.listProperties.Items.Add(prop.PropertyName, bChecked);
}
}
DialogResult selectorResult = selector.ShowDialog();
if (selectorResult == DialogResult.OK)
{
//remove the the report rows they unchecked
for (int i = 0; i < listNonDefaultProperties.Count; i++)
{
if (!selector.listProperties.CheckedItems.Contains(listNonDefaultProperties[i].PropertyName))
{
listNonDefaultProperties.RemoveAt(i--);
}
}
//save their prefs... keep previously prefs which haven't been changes (because an excluded property may not show up in the possible properties list each time you run the report)
foreach (object item in selector.listProperties.Items)
{
if (!selector.listProperties.CheckedItems.Contains(item)) //if excluded, then add to the excluded list
{
if (!listExcludedProperties.Contains(item.ToString()))
listExcludedProperties.Add(item.ToString());
}
else //if included, then remove from the excluded list
{
if (listExcludedProperties.Contains(item.ToString()))
listExcludedProperties.Remove(item.ToString());
}
}
this.ExcludedProperties = string.Join(",", listExcludedProperties.ToArray());
ReportViewerForm frm = new ReportViewerForm();
frm.ReportBindingSource.DataSource = this.listNonDefaultProperties;
frm.Report = "SSAS.NonDefaultProperties.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "BIDSHelper_NonDefaultProperty";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = frm.Report;
frm.Caption = "Non-Default Properties Report";
frm.WindowState = FormWindowState.Maximized;
frm.Show();
}
}
catch (DtsRuntimeException ex)
{
if (ex.ErrorCode == -1073659849L)
{
MessageBox.Show((piCurrent == null ? "This package" : piCurrent.Name) + " has a package password. Please open the package designer, specify the password when the dialog prompts you, then rerun the Non-Default Properties report.\r\n\r\nDetailed error was:\r\n" + ex.Message + "\r\n" + ex.StackTrace, "BIDS Helper - Password Not Specified");
}
else
{
MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace, "BIDS Helper - Error" + (piCurrent == null ? string.Empty : " scanning " + piCurrent.Name));
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace, "BIDS Helper - Error" + (piCurrent == null ? string.Empty : " scanning " + piCurrent.Name));
}
}
public override void Exec()
{
try
{
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = (UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0);
ProjectItem projItem = (ProjectItem)hierItem.Object;
Database db = projItem.ContainingProject.Object as Database;
List<DimensionOptimizations> list = GetDimensionOptimizations(db);
ReportViewerForm frm = new ReportViewerForm();
frm.ReportBindingSource.DataSource = list;
frm.Report = "SSAS.DimensionOptimization.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "BIDSHelper_DimensionOptimizations";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = frm.Report;
frm.Caption = "Dimension Optimizations Report";
frm.WindowState = FormWindowState.Maximized;
frm.Show();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override void Exec()
{
try
{
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = (UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0);
ProjectItem projItem = (ProjectItem)hierItem.Object;
string sFileName = ((ProjectItem)hierItem.Object).Name.ToLower();
#if DENALI || SQL2014
Microsoft.AnalysisServices.BackEnd.DataModelingSandbox sandbox = null;
#endif
bool bIsTabular = false;
Cube cub = null;
if (projItem.Object is Cube)
{
cub = (Cube)projItem.Object;
}
else if (sFileName.EndsWith(".bim"))
{
#if DENALI || SQL2014
sandbox = TabularHelpers.GetTabularSandboxFromBimFile(hierItem, true);
cub = sandbox.Cube;
bIsTabular = true;
Microsoft.AnalysisServices.BackEnd.IDataModelingObjectCollection<Microsoft.AnalysisServices.BackEnd.DataModelingMeasure> measures = sandbox.Measures;
#endif
}
else
{
//if you are launching this feature from the Dimension Usage tab, but some other item in Solution Explorer is highlighted, then this code works and the above doesn't
projItem = this.ApplicationObject.ActiveWindow.ProjectItem;
cub = (Cube)projItem.Object;
}
DialogResult res = MessageBox.Show("Would you like a detailed report?\r\n\r\nPress Yes to see a detailed dimension usage report.\r\n\r\nPress No to see a summary level Bus Matrix dimension usage report.", "BIDS Helper - Printer Friendly Dimension Usage - Which Report Type?", MessageBoxButtons.YesNo);
ReportViewerForm frm = new ReportViewerForm();
if (bIsTabular)
{
#if DENALI || SQL2014
bool bIsBusMatrix = (res == DialogResult.No);
System.Collections.Generic.List<DimensionUsage> list = PrinterFriendlyDimensionUsage.GetTabularDimensionUsage(sandbox, bIsBusMatrix);
DeploymentSettings _deploymentSettings = new DeploymentSettings(projItem);
//reset the database and cube name per the deployment settings
foreach (DimensionUsage du in list)
{
du.DatabaseName = _deploymentSettings.TargetDatabase;
du.CubeName = _deploymentSettings.TargetCubeName;
}
frm.ReportBindingSource.DataSource = list;
#endif
}
else
{
frm.ReportBindingSource.DataSource = PrinterFriendlyDimensionUsage.GetDimensionUsage(cub);
}
if (res == DialogResult.No)
frm.Report = "SSAS.PrinterFriendlyDimensionUsageBusMatrix.rdlc";
else
frm.Report = "SSAS.PrinterFriendlyDimensionUsage.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "BIDSHelper_DimensionUsage";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
if (res == DialogResult.No)
{
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = "BIDSHelper.PrinterFriendlyDimensionUsageBusMatrix.rdlc";
frm.Caption = "Printer Friendly Dimension Usage Bus Matrix";
}
else
{
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = "BIDSHelper.PrinterFriendlyDimensionUsage.rdlc";
frm.Caption = "Printer Friendly Dimension Usage";
}
frm.Show();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override void Exec()
{
try
{
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = (UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0);
ProjectItem projItem = (ProjectItem)hierItem.Object;
Database db = null;
string sFileName = ((ProjectItem)hierItem.Object).Name.ToLower();
bool bIsTabular = false;
if (sFileName.EndsWith(".bim"))
{
#if DENALI || SQL2014
Microsoft.AnalysisServices.BackEnd.DataModelingSandbox sandbox = TabularHelpers.GetTabularSandboxFromBimFile(hierItem, true);
db = sandbox.Database;
bIsTabular = true;
#endif
}
else
{
db = projItem.ContainingProject.Object as Database;
}
DeploymentSettings _deploymentSettings = new DeploymentSettings(projItem);
//get the target server
_deploymentTargetServer = _deploymentSettings.TargetServer;
List<RoleMemberInfo> listRoleMembers = new List<RoleMemberInfo>();
List<RoleDataSourceInfo> listRoleDataSources = new List<RoleDataSourceInfo>();
List<RoleCubeInfo> listRoleCubes = new List<RoleCubeInfo>();
List<RoleDimensionInfo> listRoleDimensions = new List<RoleDimensionInfo>();
List<RoleMiningInfo> listRoleMining = new List<RoleMiningInfo>();
foreach (Role r in db.Roles)
{
if (r.Members.Count == 0)
{
RoleMemberInfo infoMember = new RoleMemberInfo();
infoMember.TargetServerName = _deploymentTargetServer;
infoMember.database = db;
infoMember.role = r;
listRoleMembers.Add(infoMember);
}
foreach (RoleMember rm in r.Members)
{
RoleMemberInfo infoMember = new RoleMemberInfo();
infoMember.TargetServerName = _deploymentTargetServer;
infoMember.database = db;
infoMember.role = r;
infoMember.directoryEntry = GetDirectoryEntry(rm.Name);
infoMember.MemberName = GetDomainAndUserForDirectoryEntry(infoMember.directoryEntry);
if (string.IsNullOrEmpty(infoMember.MemberName))
infoMember.MemberName = rm.Name;
listRoleMembers.Add(infoMember);
listRoleMembers.AddRange(GetGroupMembers(infoMember.directoryEntry, db, r, 1));
}
if (!bIsTabular)
{
foreach (DataSource ds in db.DataSources)
{
RoleDataSourceInfo info = new RoleDataSourceInfo();
info.role = r;
info.dataSource = ds;
listRoleDataSources.Add(info);
}
foreach (Cube c in db.Cubes)
{
RoleCubeInfo info = new RoleCubeInfo();
info.role = r;
info.cube = c;
listRoleCubes.Add(info);
}
foreach (MiningStructure ms in db.MiningStructures)
{
RoleMiningInfo info = new RoleMiningInfo();
info.role = r;
info.miningStructure = ms;
listRoleMining.Add(info);
foreach (MiningModel mm in ms.MiningModels)
{
info = new RoleMiningInfo();
info.role = r;
info.miningStructure = ms;
info.miningModel = mm;
listRoleMining.Add(info);
}
}
}
foreach (Dimension d in db.Dimensions)
{
RoleDimensionInfo info = new RoleDimensionInfo();
info.role = r;
info.dimension = d;
if (!bIsTabular || !string.IsNullOrEmpty(info.AllowedMemberSet))
listRoleDimensions.Add(info);
if (!bIsTabular)
{
foreach (DimensionAttribute da in d.Attributes)
{
RoleDimensionInfo info2 = new RoleDimensionInfo();
info2.role = r;
info2.dimension = d;
info2.dimensionAttribute = da;
if (!string.IsNullOrEmpty(info2.AllowedMemberSet) || !string.IsNullOrEmpty(info2.DeniedMemberSet) || !string.IsNullOrEmpty(info2.DefaultMember) || !string.IsNullOrEmpty(info2.VisualTotals))
listRoleDimensions.Add(info2);
}
}
}
if (!bIsTabular)
{
foreach (Cube c in db.Cubes)
{
foreach (CubeDimension cd in c.Dimensions)
{
RoleDimensionInfo info = new RoleDimensionInfo();
info.role = r;
info.dimension = cd.Dimension;
info.cubeDimension = cd;
if (info.ReadAccess != "Inherited")
listRoleDimensions.Add(info);
foreach (CubeAttribute ca in cd.Attributes)
{
RoleDimensionInfo info2 = new RoleDimensionInfo();
info2.role = r;
info2.dimension = cd.Dimension;
info2.cubeDimension = cd;
info2.dimensionAttribute = ca.Attribute;
if (!string.IsNullOrEmpty(info2.AllowedMemberSet) || !string.IsNullOrEmpty(info2.DeniedMemberSet) || !string.IsNullOrEmpty(info2.DefaultMember) || !string.IsNullOrEmpty(info2.VisualTotals))
listRoleDimensions.Add(info2);
}
}
RoleDimensionInfo infoMeasures = new RoleDimensionInfo();
infoMeasures.role = r;
infoMeasures.isMeasuresDimension = true;
infoMeasures.cube = c;
if (!string.IsNullOrEmpty(infoMeasures.AllowedMemberSet) || !string.IsNullOrEmpty(infoMeasures.DeniedMemberSet) || !string.IsNullOrEmpty(infoMeasures.DefaultMember) || !string.IsNullOrEmpty(infoMeasures.VisualTotals))
listRoleDimensions.Add(infoMeasures);
}
}
}
ReportViewerForm frm = new ReportViewerForm();
frm.ReportBindingSource.DataSource = listRoleMembers;
frm.Report = "SSAS.RolesReport.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "BIDSHelper_RoleMemberInfo";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource2 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource2.Name = "BIDSHelper_RoleDataSourceInfo";
reportDataSource2.Value = listRoleDataSources;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource2);
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource3 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource3.Name = "BIDSHelper_RoleCubeInfo";
reportDataSource3.Value = listRoleCubes;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource3);
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource4 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource4.Name = "BIDSHelper_RoleDimensionInfo";
reportDataSource4.Value = listRoleDimensions;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource4);
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource5 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource5.Name = "BIDSHelper_RoleMiningInfo";
reportDataSource5.Value = listRoleMining;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource5);
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = frm.Report;
frm.Parameters.Add(new Microsoft.Reporting.WinForms.ReportParameter("IsTabular", (bIsTabular ? "true" : "false"), false));
frm.Caption = "Roles Report";
frm.WindowState = System.Windows.Forms.FormWindowState.Maximized;
frm.Show();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace);
}
}
public override void Exec()
{
try
{
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = (UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0);
ProjectItem projItem = (ProjectItem)hierItem.Object;
string sFileName = ((ProjectItem)hierItem.Object).Name.ToLower();
if (sFileName.EndsWith(".bim"))
{
#if DENALI || SQL2014
Microsoft.AnalysisServices.BackEnd.DataModelingSandbox sandbox = TabularHelpers.GetTabularSandboxFromBimFile(hierItem, true);
foreach (DataSourceView o in sandbox.Database.DataSourceViews)
{
IterateDsvColumns(o);
}
#endif
}
else
{
DataSourceView dsv = (DataSourceView)projItem.Object;
IterateDsvColumns(dsv);
}
if (unusedColumns.Count == 0)
{
MessageBox.Show("There are no unused columns.", "BIDS Helper - Unused Columns Report");
return;
}
ReportViewerForm frm = new ReportViewerForm();
frm.ReportBindingSource.DataSource = unusedColumns.Values;
frm.Report = "SSAS.UnusedColumns.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource();
reportDataSource1.Name = "BIDSHelper_UnusedColumn";
reportDataSource1.Value = frm.ReportBindingSource;
frm.ReportViewerControl.LocalReport.DataSources.Add(reportDataSource1);
frm.ReportViewerControl.LocalReport.ReportEmbeddedResource = "SSAS.UnusedColumns.rdlc";
frm.Caption = "Unused Columns Report";
frm.WindowState = FormWindowState.Maximized;
frm.Show();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}