private static Microsoft.AnalysisServices.VSHost.VSHostManager GetVSHostManager(UIHierarchyItem hierItem, bool openIfNotOpen)
{
Microsoft.VisualStudio.Project.Automation.OAFileItem project = hierItem.Object as Microsoft.VisualStudio.Project.Automation.OAFileItem;
if (project == null)
{
return(null);
}
return(GetVSHostManager(project, openIfNotOpen));
}
//public static Microsoft.AnalysisServices.Common.SandboxEditor GetTabularSandboxEditorFromActiveWindow()
//{
// return GetTabularSandboxEditorFromProjectItem(Connect.Application.ActiveWindow.ProjectItem, false);
//}
public static Microsoft.AnalysisServices.Common.SandboxEditor GetTabularSandboxEditorFromProjectItem(ProjectItem projectItem, bool openIfNotOpen)
{
Microsoft.VisualStudio.Project.Automation.OAFileItem project = projectItem as Microsoft.VisualStudio.Project.Automation.OAFileItem;
Microsoft.AnalysisServices.VSHost.VSHostManager host = GetVSHostManager(project, openIfNotOpen);
if (host == null)
{
return(null);
}
return(host.Editor);
}
public static Microsoft.AnalysisServices.BackEnd.DataModelingSandbox GetTabularSandboxFromProjectItem(ProjectItem projectItem, bool openIfNotOpen)
{
Microsoft.VisualStudio.Project.Automation.OAFileItem project = projectItem as Microsoft.VisualStudio.Project.Automation.OAFileItem;
Microsoft.AnalysisServices.VSHost.VSHostManager host = GetVSHostManager(project, openIfNotOpen);
if (host == null)
{
return(null);
}
return(host.Sandbox);
}
private void ExecInternal(bool bPreBuildCheckOnly)
{
try
{
UIHierarchy solExplorer = this.ApplicationObject.ToolWindows.SolutionExplorer;
UIHierarchyItem hierItem = ((UIHierarchyItem)((System.Array)solExplorer.SelectedItems).GetValue(0));
cube = sandbox.Cube;
if (cube == null)
{
throw new Exception("The workspace database cube doesn't exist.");
}
SSAS.TabularDisplayFoldersAnnotation annotationSavedFolders = TabularDisplayFolderPlugin.GetAnnotation(sandbox);
SSAS.TabularTranslationsAnnotation annotationSaved = GetAnnotation(sandbox);
string sTargetDatabase = null;
string sTargetCubeName = null;
try
{
//get the deployment settings to display in the translations dialog (rather than the workspace database and cube name)
Microsoft.VisualStudio.Project.Automation.OAFileItem fileitem = hierItem.Object as Microsoft.VisualStudio.Project.Automation.OAFileItem;
DeploymentSettings deploySet = new DeploymentSettings(fileitem.ContainingProject);
sTargetDatabase = deploySet.TargetDatabase;
sTargetCubeName = deploySet.TargetCubeName;
}
catch { } //this seems to blow up in debug mode on my laptop... oh well
bool bRestoredDisplayFolders = false;
List <SSAS.TabularTranslatedItem> translationRows = new List <BIDSHelper.SSAS.TabularTranslatedItem>();
Microsoft.AnalysisServices.AdomdClient.AdomdRestrictionCollection restrictions = new Microsoft.AnalysisServices.AdomdClient.AdomdRestrictionCollection();
restrictions.Add(new Microsoft.AnalysisServices.AdomdClient.AdomdRestriction("CUBE_NAME", cube.Name));
DataSet datasetMeasures = sandbox.AdomdConnection.GetSchemaDataSet("MDSCHEMA_MEASURES", restrictions);
DataRowCollection rowsMeasures = datasetMeasures.Tables[0].Rows;
Database db = cube.Parent;
SSAS.TabularTranslatedItem captionTranslationDatabase = new SSAS.TabularTranslatedItem(null, db, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
if (!string.IsNullOrEmpty(sTargetDatabase))
{
captionTranslationDatabase.OverrideCaption(sTargetDatabase);
}
translationRows.Add(captionTranslationDatabase);
if (!string.IsNullOrEmpty(db.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(null, db, SSAS.TabularTranslatedItemProperty.Description, captionTranslationDatabase, null));
}
List <CalculationProperty> calcProperties = new List <CalculationProperty>();
foreach (Cube c in db.Cubes)
{
SSAS.TabularTranslatedItem captionTranslationCube = new SSAS.TabularTranslatedItem(null, c, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
if (!string.IsNullOrEmpty(sTargetCubeName))
{
captionTranslationCube.OverrideCaption(sTargetCubeName);
}
translationRows.Add(captionTranslationCube);
if (!string.IsNullOrEmpty(c.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(null, c, SSAS.TabularTranslatedItemProperty.Description, captionTranslationCube, null));
}
foreach (Perspective p in c.Perspectives)
{
SSAS.TabularTranslatedItem captionTranslationPerspective = new SSAS.TabularTranslatedItem(null, p, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
translationRows.Add(captionTranslationPerspective);
if (!string.IsNullOrEmpty(p.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(null, p, SSAS.TabularTranslatedItemProperty.Description, captionTranslationPerspective, null));
}
}
foreach (MdxScript mdx in c.MdxScripts)
{
foreach (CalculationProperty calc in mdx.CalculationProperties)
{
if (calc.Visible && !calc.CalculationReference.StartsWith("KPIs."))
{
calcProperties.Add(calc);
}
}
}
}
foreach (Dimension d in db.Dimensions)
{
SSAS.TabularTranslatedItem captionTranslationDimension = new SSAS.TabularTranslatedItem(d.Name, d, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
translationRows.Add(captionTranslationDimension);
if (!string.IsNullOrEmpty(d.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(d.Name, d, SSAS.TabularTranslatedItemProperty.Description, captionTranslationDimension, null));
}
foreach (DimensionAttribute da in d.Attributes)
{
if (da.Type != AttributeType.RowNumber && da.AttributeHierarchyVisible)
{
if (string.IsNullOrEmpty(da.AttributeHierarchyDisplayFolder))
{
SSAS.TabularDisplayFolderAnnotation a = annotationSavedFolders.Find(da);
if (a != null)
{
da.AttributeHierarchyDisplayFolder = a.DisplayFolder;
bRestoredDisplayFolders = true; //we have to restore the display folder or the translations on the display folder won't even be visible in the translations dialog
}
}
SSAS.TabularTranslatedItem captionTranslation = new SSAS.TabularTranslatedItem(d.Name, da, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
translationRows.Add(captionTranslation);
if (!string.IsNullOrEmpty(da.AttributeHierarchyDisplayFolder))
{
translationRows.Add(new SSAS.TabularTranslatedItem(d.Name, da, SSAS.TabularTranslatedItemProperty.DisplayFolder, captionTranslation, null));
}
if (!string.IsNullOrEmpty(da.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(d.Name, da, SSAS.TabularTranslatedItemProperty.Description, captionTranslation, null));
}
}
}
foreach (Hierarchy h in d.Hierarchies)
{
if (string.IsNullOrEmpty(h.DisplayFolder))
{
SSAS.TabularDisplayFolderAnnotation a = annotationSavedFolders.Find(h);
if (a != null)
{
h.DisplayFolder = a.DisplayFolder;
bRestoredDisplayFolders = true; //we have to restore the display folder or the translations on the display folder won't even be visible in the translations dialog
}
}
SSAS.TabularTranslatedItem captionTranslation = new SSAS.TabularTranslatedItem(d.Name, h, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
translationRows.Add(captionTranslation);
if (!string.IsNullOrEmpty(h.DisplayFolder))
{
translationRows.Add(new SSAS.TabularTranslatedItem(d.Name, h, SSAS.TabularTranslatedItemProperty.DisplayFolder, captionTranslation, null));
}
if (!string.IsNullOrEmpty(h.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(d.Name, h, SSAS.TabularTranslatedItemProperty.Description, captionTranslation, null));
}
foreach (Level level in h.Levels)
{
SSAS.TabularTranslatedItem captionTranslationLevel = new SSAS.TabularTranslatedItem(d.Name, level, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
translationRows.Add(captionTranslationLevel);
if (!string.IsNullOrEmpty(level.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(d.Name, level, SSAS.TabularTranslatedItemProperty.Description, captionTranslationLevel, null));
}
}
}
for (int i = 0; i < rowsMeasures.Count; i++)
{
DataRow r = rowsMeasures[i];
if (Convert.ToString(r["MEASUREGROUP_NAME"]) == d.Name)
{
foreach (CalculationProperty calc in calcProperties)
{
if (Convert.ToString(r["MEASURE_UNIQUE_NAME"]) == "[Measures]." + calc.CalculationReference)
{
if (string.IsNullOrEmpty(calc.DisplayFolder))
{
SSAS.TabularDisplayFolderAnnotation a = annotationSavedFolders.Find(calc);
if (a != null)
{
calc.DisplayFolder = a.DisplayFolder;
bRestoredDisplayFolders = true; //we have to restore the display folder or the translations on the display folder won't even be visible in the translations dialog
}
}
SSAS.TabularTranslatedItem captionTranslation = new SSAS.TabularTranslatedItem(d.Name, calc, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
translationRows.Add(captionTranslation);
if (!string.IsNullOrEmpty(calc.DisplayFolder))
{
translationRows.Add(new SSAS.TabularTranslatedItem(d.Name, calc, SSAS.TabularTranslatedItemProperty.DisplayFolder, captionTranslation, null));
}
if (!string.IsNullOrEmpty(calc.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(d.Name, calc, SSAS.TabularTranslatedItemProperty.Description, captionTranslation, null));
}
rowsMeasures.Remove(r);
i--;
break;
}
}
}
}
}
foreach (Cube c in db.Cubes)
{
SSAS.TabularActionsAnnotation actionAnnotations = TabularActionsEditorPlugin.GetAnnotation(c);
foreach (Microsoft.AnalysisServices.Action a in c.Actions)
{
SSAS.TabularAction actionAnnotation = actionAnnotations.Find(a.ID);
if (actionAnnotation == null)
{
actionAnnotation = new SSAS.TabularAction();
}
if (!string.IsNullOrEmpty(actionAnnotation.OriginalTarget) &&
!actionAnnotation.IsMasterClone)
{
continue;
}
SSAS.TabularTranslatedItem captionTranslationAction = new SSAS.TabularTranslatedItem(null, a, SSAS.TabularTranslatedItemProperty.Caption, null, annotationSaved);
translationRows.Add(captionTranslationAction);
if (!string.IsNullOrEmpty(a.Description))
{
translationRows.Add(new SSAS.TabularTranslatedItem(null, a, SSAS.TabularTranslatedItemProperty.Description, captionTranslationAction, null));
}
}
}
bool bRestoredTranslations = false;
//get a list of all the distinct languages
List <int> listLanguages = new List <int>();
foreach (SSAS.TabularTranslatedItem item in translationRows)
{
foreach (int iLang in item.Languages.Keys)
{
if (!listLanguages.Contains(iLang))
{
listLanguages.Add(iLang);
}
}
if (item.RestoredTranslations)
{
bRestoredTranslations = true;
}
}
listLanguages.Sort();
if (bRestoredTranslations)
{
MessageBox.Show("Some translations have been wiped out by other editing operations. Restoring translations may be possible except when an object like a measure or a hierarchy has been renamed.\r\n\r\nBIDS Helper will attempt to restore the translations now. Be sure to click OK after you finish your edits in the Tabular Translations window.", "BIDS Helper Tabular Translations");
}
else if (bRestoredDisplayFolders)
{
MessageBox.Show("Some display folders have been wiped out by other editing operations. Restoring display folders may be possible except when an object like a measure or a hierarchy has been renamed.\r\n\r\nBIDS Helper will attempt to restore the display folders now. Properly restored display folders are necessary for this Tabular Translations dialog to function properly. Be sure to click OK after you finish your edits in the Tabular Translations window.", "BIDS Helper Tabular Translations");
}
else if (bPreBuildCheckOnly)
{
return; //if this is just a pre-build check and if there's nothing that needs to be restored, then just return without popping up the dialog
}
SSAS.TabularTranslationsEditorWindow form = new SSAS.TabularTranslationsEditorWindow(db.Language, listLanguages);
form.WindowState = System.Windows.WindowState.Maximized;
form.dataGrid1.ItemsSource = translationRows;
if (form.ShowDialog() == true)
{
//count dirty changes and create annotation
int iNumberOfChanges = 0;
foreach (SSAS.TabularTranslatedItem item in translationRows)
{
if (item.Dirty)
{
iNumberOfChanges++;
}
}
if (iNumberOfChanges > 0 || bRestoredDisplayFolders || bRestoredTranslations)
{
AlterDatabase(translationRows);
}
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace, "BIDS Helper - Error");
}
}
internal override void OnUpdateConfigBegin(IVsHierarchy pHierProj, VSSOLNBUILDUPDATEFLAGS dwAction, ref int pfCancel)
{
if (!this.Enabled)
{
return;
}
if (dwAction == VSSOLNBUILDUPDATEFLAGS.SBF_OPERATION_CLEAN)
{
return;
}
foreach (UIHierarchyItem hierItem in VisualStudioHelpers.GetAllItemsFromSolutionExplorer(this.ApplicationObject.ToolWindows.SolutionExplorer))
{
if (hierItem.Name != null && hierItem.Name.ToLower().EndsWith(".bim"))
{
Microsoft.AnalysisServices.BackEnd.DataModelingSandbox sandbox = TabularHelpers.GetTabularSandboxFromBimFile(this, false);
if (sandbox == null)
{
var sandboxEditor = TabularHelpers.GetTabularSandboxEditorFromBimFile(hierItem, true);
if (sandboxEditor != null)
{
sandbox = sandboxEditor.Sandbox;
}
}
if (sandbox != null)
{
#if !DENALI && !SQL2014
if (sandbox.IsTabularMetadata)
{
return;
}
#endif
List <BIDSHelperPluginBase> checks = new List <BIDSHelperPluginBase>();
foreach (BIDSHelperPluginBase plugin in BIDSHelperPackage.Plugins.Values)
{
Type t = plugin.GetType();
if (plugin is ITabularOnPreBuildAnnotationCheck &&
!t.IsInterface &&
!t.IsAbstract)
{
ITabularOnPreBuildAnnotationCheck check = (ITabularOnPreBuildAnnotationCheck)plugin;
if (check.TabularOnPreBuildAnnotationCheckPriority == TabularOnPreBuildAnnotationCheckPriority.HighPriority)
{
checks.Insert(0, plugin); //insert the high priority checks at the front of the list so they get run first
}
else
{
checks.Add(plugin);
}
}
}
foreach (BIDSHelperPluginBase plugin in checks)
{
ITabularOnPreBuildAnnotationCheck check = (ITabularOnPreBuildAnnotationCheck)plugin;
string sWarning = check.GetPreBuildWarning(sandbox);
if (sWarning != null)
{
if (MessageBox.Show(sWarning, "BIDS Helper Pre-Build Warning - " + plugin.FeatureName, MessageBoxButtons.OKCancel) == DialogResult.OK)
{
Microsoft.VisualStudio.Project.Automation.OAFileItem project = hierItem.Object as Microsoft.VisualStudio.Project.Automation.OAFileItem;
Window win = project.Open(EnvDTE.Constants.vsViewKindPrimary);
win.Activate();
check.FixPreBuildWarning(sandbox);
project.Save(hierItem.Name);
}
}
}
}
}
}
}
public static IServiceProvider GetTabularServiceProviderFromProjectItem(ProjectItem projectItem, bool openIfNotOpen)
{
Microsoft.VisualStudio.Project.Automation.OAFileItem project = projectItem as Microsoft.VisualStudio.Project.Automation.OAFileItem;
GetVSHostManager(project, openIfNotOpen); //just to force the window open if not open
return(((Microsoft.VisualStudio.Project.ProjectNode)((project.ContainingProject).Object)).Site);
}
private static Microsoft.AnalysisServices.VSHost.VSHostManager GetVSHostManager(Microsoft.VisualStudio.Project.Automation.OAFileItem project, bool openIfNotOpen)
{
if (project == null)
{
return(null);
}
if (openIfNotOpen && (!project.get_IsOpen(EnvDTE.Constants.vsViewKindPrimary) || project.get_IsOpen(EnvDTE.Constants.vsViewKindCode))) //having the code view open was passing this test previously
{
Window win = project.Open(EnvDTE.Constants.vsViewKindPrimary);
if (win == null)
{
throw new Exception("BIDS Helper was unable to open designer window.");
}
win.Activate();
}
Microsoft.AnalysisServices.VSHost.Integration.BISMFileNode bim = project.Object as Microsoft.AnalysisServices.VSHost.Integration.BISMFileNode;
if (bim == null)
{
return(null);
}
Microsoft.AnalysisServices.VSHost.VSHostManager host = (Microsoft.AnalysisServices.VSHost.VSHostManager)bim.GetType().InvokeMember("VSHostManager", System.Reflection.BindingFlags.ExactBinding | System.Reflection.BindingFlags.GetProperty | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic, null, bim, null); //bim.VSHostManager;
return(host);
}
private void BuildEvents_OnBuildBegin(vsBuildScope Scope, vsBuildAction Action)
{
if (!this.Enabled)
{
return;
}
if (Action == vsBuildAction.vsBuildActionClean)
{
return;
}
foreach (UIHierarchyItem hierItem in VisualStudioHelpers.GetAllItemsFromSolutionExplorer(this.ApplicationObject.ToolWindows.SolutionExplorer))
{
if (hierItem.Name != null && hierItem.Name.ToLower().EndsWith(".bim"))
{
Microsoft.AnalysisServices.BackEnd.DataModelingSandbox sandbox = TabularHelpers.GetTabularSandboxFromBimFile(hierItem, false);
if (sandbox != null)
{
List <BIDSHelperPluginBase> checks = new List <BIDSHelperPluginBase>();
foreach (BIDSHelperPluginBase plugin in Connect.Plugins.Values)
{
Type t = plugin.GetType();
if (plugin is ITabularOnPreBuildAnnotationCheck &&
!t.IsInterface &&
!t.IsAbstract)
{
ITabularOnPreBuildAnnotationCheck check = (ITabularOnPreBuildAnnotationCheck)plugin;
if (check.TabularOnPreBuildAnnotationCheckPriority == TabularOnPreBuildAnnotationCheckPriority.HighPriority)
{
checks.Insert(0, plugin); //insert the high priority checks at the front of the list so they get run first
}
else
{
checks.Add(plugin);
}
}
}
foreach (BIDSHelperPluginBase plugin in checks)
{
ITabularOnPreBuildAnnotationCheck check = (ITabularOnPreBuildAnnotationCheck)plugin;
string sWarning = check.GetPreBuildWarning(sandbox);
if (sWarning != null)
{
if (MessageBox.Show(sWarning, "BIDS Helper Pre-Build Warning - " + plugin.FeatureName, MessageBoxButtons.OKCancel) == DialogResult.OK)
{
Microsoft.VisualStudio.Project.Automation.OAFileItem project = hierItem.Object as Microsoft.VisualStudio.Project.Automation.OAFileItem;
Window win = project.Open(EnvDTE.Constants.vsViewKindPrimary);
win.Activate();
check.FixPreBuildWarning(sandbox);
project.Save(hierItem.Name);
}
}
}
}
}
}
}
