Dimension Filters doesn't work on grayed items

[c_pradelli]

I HideEmptyItems=False and you set a filter using dimension editor or from dimension button, grayed items (empty items) are not hide, they are shown along with the filtered value.
Is this a bug?

[AlexZencovich]

Empty items (dimension items which have not any related cube cell) could not be filtered.

You may change way how to handle empty items in dimension - mark it with gray, place to disabled or just delete after cube built. See and set TPivotCube.Dimensions[].EmptyItems value.

[c_pradelli]

>You may change way how to handle empty items in dimension - mark it
>with gray, place to disabled or just delete after cube built.

I need to have it marked with gray because I have made some custom groups that I don't want to lost when I load the cube in different periods.

But at some momment I need to filter items to see only one o two, but all empty items (about 1000) keeps visible in the grid, so I can't make a view of the items that I need.

[c_pradelli]

Yes, that could work, I don't need HideEmptyItems=False when I set the filter, but It would be nice if can automatically set it to True when I set any filter and the back to False when I quit the filters.
I'll try your sugestion.

[AlexZencovich]

Set TPivotMap.OnBeforeRefresh with something like

PivotMap.HideEmptyRows = True;
for i := 0 to PivotMap.Dimensions.Count - 1 do
begin
if PivotMap.Dimensions[i].FilterChanged then
begin
PivotMap.HideEmptyRows = False;
break;
end;
end;

[AlexZencovich]

Christian, I have uploaded new build with all these issues are fixed

[c_pradelli]

Thank you very much!