public string GetPreBuildWarning(Microsoft.AnalysisServices.BackEnd.DataModelingSandbox sandbox)
{
#if DENALI || SQL2014
cube = sandbox.Cube;
#else
cube = ((Microsoft.AnalysisServices.BackEnd.DataModelingSandboxAmo)sandbox.Impl).Cube;
#endif
SSAS.TabularActionsAnnotation annotation = GetAnnotation(cube);
bool bContainsPerspectiveListAnnotation = false;
foreach (Microsoft.AnalysisServices.Action action in cube.Actions)
{
SSAS.TabularAction actionAnnotation = annotation.Find(action.ID);
if (actionAnnotation == null)
{
continue;
}
//see if this action is assigned to perspectives
if (actionAnnotation.Perspectives != null && actionAnnotation.Perspectives.Length > 0)
{
bContainsPerspectiveListAnnotation = true;
}
}
long lngPerspectiveActionsCount = 0;
foreach (Perspective p in cube.Perspectives)
{
lngPerspectiveActionsCount += p.Actions.Count;
}
//note: this logic is also duplicated in the constructor of TabularActionsEditorForm since we will just rely on it to fix the actions
if (bContainsPerspectiveListAnnotation && lngPerspectiveActionsCount == 0 && cube.Perspectives.Count > 0)
{
return("Click OK for BIDS Helper to restore the assignments of actions to perspectives. The Tabular Actions Editor form will open. Then click Yes then OK.");
}
else
{
return(null);
}
}
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");
}
}
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");
}
}
public Microsoft.AnalysisServices.Action[] Actions()
{
annotation = new TabularActionsAnnotation();
List<Microsoft.AnalysisServices.Action> list = new List<Microsoft.AnalysisServices.Action>();
List<TabularAction> listAnnotationActions = new List<TabularAction>();
foreach (Microsoft.AnalysisServices.Action action in _listActionClones)
{
bool bAlreadyAdded = false;
var daction = (Microsoft.AnalysisServices.Action)action;
MeasureGroup mg = null;
foreach (MeasureGroup mg2 in cube.MeasureGroups)
{
if (daction.Target == "MeasureGroupMeasures(\"" + mg2.Name + "\")")
{
mg = mg2;
break;
}
}
if (mg != null) //if this is a drillthrough action targeting a whole measure group, MeasureGroupMeasures doesn't actually return the calculated measures in a measure group, so we have to take this one drillthrough action and clone it for each measure under the covers
{
Microsoft.AnalysisServices.AdomdClient.AdomdRestrictionCollection restrictions = new Microsoft.AnalysisServices.AdomdClient.AdomdRestrictionCollection();
restrictions.Add(new Microsoft.AnalysisServices.AdomdClient.AdomdRestriction("CUBE_NAME", cube.Name));
restrictions.Add(new Microsoft.AnalysisServices.AdomdClient.AdomdRestriction("MEASUREGROUP_NAME", mg.Name));
DataSet dataset = conn.GetSchemaDataSet("MDSCHEMA_MEASURES", restrictions);
int i = 0;
foreach (DataRow r in dataset.Tables[0].Rows)
{
TabularAction actionAnnotation = new TabularAction();
var newaction = (Microsoft.AnalysisServices.Action)daction.Clone();
string sSuffix = " " + (i++);
newaction.Target = Convert.ToString(r["MEASURE_UNIQUE_NAME"]);
if (i == 1)
{
actionAnnotation.IsMasterClone = true;
}
else
{
newaction.ID = daction.ID + sSuffix;
newaction.Name = daction.Name + sSuffix;
_dictActionPerspectives.Add(newaction.ID, _dictActionPerspectives[action.ID]);
}
actionAnnotation.ID = newaction.ID;
actionAnnotation.Perspectives = _dictActionPerspectives[action.ID];
actionAnnotation.OriginalTarget = daction.Target;
listAnnotationActions.Add(actionAnnotation);
list.Add(newaction);
bAlreadyAdded = true;
}
}
if (!bAlreadyAdded)
{
list.Add(action);
TabularAction actionAnnotation = new TabularAction();
actionAnnotation.ID = action.ID;
actionAnnotation.Perspectives = _dictActionPerspectives[action.ID];
listAnnotationActions.Add(actionAnnotation);
}
}
annotation.TabularActions = listAnnotationActions.ToArray();
return list.ToArray();
}
public TabularActionsEditorForm(Microsoft.AnalysisServices.Cube cube, Microsoft.AnalysisServices.AdomdClient.AdomdConnection conn)
{
InitializeComponent();
this.MinimumSize = this.Size;
this.Icon = BIDSHelper.Resources.Common.BIDSHelper;
this.cube = cube;
this.conn = conn;
arrEnabledControls = new Control[] { this.btnDelete, this.btnAdd, this.cmbAction, this.okButton, this.cancelButton, this.linkHelp };
_listDrillthroughColumns = new List<TabularActionsEditorPlugin.DrillthroughColumn>();
this.drillthroughColumnBindingSource.DataSource = _listDrillthroughColumns;
_listReportParameters = new List<ReportParameter>();
this.reportParameterBindingSource.DataSource = _listReportParameters;
List<string> list = new List<string>();
List<string> listAttributes = new List<string>();
list.Add(string.Empty);
listAttributes.Add(string.Empty);
foreach (Microsoft.AnalysisServices.CubeDimension cd in cube.Dimensions)
{
list.Add(cd.Name);
foreach (DimensionAttribute a in cd.Dimension.Attributes)
{
listAttributes.Add(a.Name);
}
}
DrillthroughDataGridCubeDimension.Items.AddRange(list.ToArray());
DrillthroughDataGridAttribute.Items.AddRange(listAttributes.ToArray());
long lngPerspectiveActionsCount = 0;
listPerspectives.Items.Clear();
foreach (Perspective p in cube.Perspectives)
{
listPerspectives.Items.Add(p.Name);
lngPerspectiveActionsCount += p.Actions.Count;
}
this.cmbActionType.Items.AddRange(Enum.GetNames(typeof(ActionType)));
this.cmbTargetType.Items.AddRange(Enum.GetNames(typeof(ActionTargetType)));
this.cmbTargetType.Items.Remove(ActionTargetType.Set.ToString());
this.cmbInvocation.Items.AddRange(Enum.GetNames(typeof(ActionInvocation)));
TabularActionsAnnotation annotation = BIDSHelper.TabularActionsEditorPlugin.GetAnnotation(cube);
bool bContainsPerspectiveListAnnotation = false;
_listActionClones = new List<Microsoft.AnalysisServices.Action>();
foreach (Microsoft.AnalysisServices.Action action in cube.Actions)
{
TabularAction actionAnnotation = annotation.Find(action.ID);
if (actionAnnotation == null) actionAnnotation = new TabularAction();
if (!string.IsNullOrEmpty(actionAnnotation.OriginalTarget)
&& !actionAnnotation.IsMasterClone)
{
continue;
}
Microsoft.AnalysisServices.Action clone = action.Clone();
_listActionClones.Add(clone);
if (!string.IsNullOrEmpty(actionAnnotation.OriginalTarget))
{
clone.Target = actionAnnotation.OriginalTarget;
}
List<string> lPerspectives = new List<string>();
foreach (Perspective perspective in cube.Perspectives)
{
if (perspective.Actions.Contains(action.ID))
{
lPerspectives.Add(perspective.Name);
}
}
if (!_dictActionPerspectives.ContainsKey(action.ID))
_dictActionPerspectives.Add(action.ID, lPerspectives.ToArray());
else
_dictActionPerspectives[action.ID] = lPerspectives.ToArray();
//see if this action is assigned to perspectives
if (actionAnnotation.Perspectives != null && actionAnnotation.Perspectives.Length > 0)
{
bContainsPerspectiveListAnnotation = true;
}
}
if (bContainsPerspectiveListAnnotation && lngPerspectiveActionsCount == 0 && cube.Perspectives.Count > 0)
{
//we have a backup of the perspectives list, and no actions are assigned to perspectives currently
if (MessageBox.Show("No actions are currently included in any perspectives, but BIDS Helper did retain a backup of the perspective assignments from the last actions editing session. Changes made to perspectives may have caused action assignments to be lost. Restoring action perspective assignments may be possible except when a perspective has been renamed.\r\n\r\nWould you like BIDS Helper to attempt restore the action perspective assignments now?", "BIDS Helper Tabular Actions Editor", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
foreach (Microsoft.AnalysisServices.Action action in _listActionClones)
{
TabularAction actionAnnotation = annotation.Find(action.ID);
if (actionAnnotation == null) actionAnnotation = new TabularAction();
if (actionAnnotation.Perspectives != null && actionAnnotation.Perspectives.Length > 0)
{
List<string> lPerspectives = new List<string>();
foreach (string sPerspectiveID in actionAnnotation.Perspectives)
{
if (cube.Perspectives.Contains(sPerspectiveID))
{
lPerspectives.Add(cube.Perspectives[sPerspectiveID].Name);
}
}
_dictActionPerspectives[action.ID] = lPerspectives.ToArray();
}
}
}
}
cmbAction.Items.AddRange(_listActionClones.ToArray());
cmbAction.DisplayMember = "Name";
cmbAction.ValueMember = "ID";
cmbAction.ResumeLayout();
if (_listActionClones.Count > 0)
cmbAction.SelectedIndex = 0;
else
DisableControls(true, arrEnabledControls);
}
