Removing Eliminations.
Hello,
When using eliminations, in the ribbon there is an option to remove eliminations. Also available in the wizard as well, you can hit the cross on an elimination.
To me this suggests that the eliminations will be removed therefore added back into the report? But this isn't the case, when you remove them they get taken out of the wizard but not added back in.
Is this expected?
Because if so it is a bit confusing because they no longer appear in the wizard, so if this is a saved the report you'll have to just remember, that it is no longer included still but without mention. Or if it is just one Dimensions you'll have to remove it and re-add it in or re-build the report if you have done multiple eliminations?
Causing further complications if multiple people use the report and someone saves without rebuilding and another user is unaware.
As an example:
Open the In-Memory DB > PC - Sales > Training - Sales
Build a report: Sales by Date year and Manufacturer
Columns: Values, Date Year
Rows: Manufacturer
Values: Sales
Run the report > Highlight the row for Nuke > Right click > Member Selection > Eliminate > Nuke
This takes Nuke out
Then go to the Query Ribbon > Eliminations > Remove Eliminations > Run report
Nuke does not reappear
Thank you for any information you have regarding this.
1 reply
-
Hi Cyan Winter ,
I'll start by saying that I understand the complication and we'll try to rethink the way this acts.
Here is a small overview of elimination and deselection:
Deselection: you can view the elements for a column, in the element panel, and there you can deselect the ones you don't want to see. How ever, if an element you deselected also exist in a set (list) that you did select, then you will get that element.
Elimination: a higher level of removal. you can eliminate either a single element or a combination of elements.
- Combination: you can remove the combination of Nuke and Canada for example. You won't see that elimination in the element list (because it's cross-columns), and it will remove any data-point in the results that has the combination of the 2 elements.
- Single element: the difference from a deselect of an element is that even if the element is in a set (list), it will still be removed. So it's more powerful removal than the deselect.
If you eliminate a single element from the context menu of your visual (right-click), then both an eliminate and a deselect are created for it.
- If you "remove eliminations", the deselect is not effected. This is why you don't see Nuke.
- If you "re-select" in the elements list (an element that was deselected) then it automatically removes the elimination for it.
I hope this helps you understand the flow.
Thank you for the feedback,
Imbar