3

If I have a parent-child-dimension, whose data I show in the IcCube/PivotTable and I want to show the leaves only (with descendants([categories].[categories].[All-M],,leaves)), those leaves are shown hierarchically. So a level5 leave of one category is suddenly the parent of a level6 leave of the next category.

Is there a way to "flatten" this tree, so that those leaves are all shown on one level and not sorted in the tree wrongly?

EDIT: Here is a query:

SELECT
NON EMPTY { [Measures].[group_quality] } ON COLUMNS,
NON EMPTY { TopCount(descendants([categories].[categories].[Level$0].[Portal],,leaves),30,[Measures].[revenue_potential]) } ON ROWS
FROM [Cube]

All categories in the picture are leaves, so none of them has any children.

UlrichWuenstel
  • 460
  • 2
  • 10
  • Could you please provide some screenshots and example of request to cube? – Artem Lopatiy Jul 01 '16 at 09:47
  • I edited my first post, to show my problem a little better. – UlrichWuenstel Jul 01 '16 at 12:48
  • @ulrich, is there an easy way to get this hierarchy so we can test (in-memory data source) ? – ic3 Jul 04 '16 at 12:07
  • You can use the data from your parent/child example: http://www.iccube.com/support/documentation/user_guide/schemas_cubes/dim_parentchild.php. With the statement select [Measures].[value] on 0, descendants([countries].[countries].[World],,leaves) on 1 from [Cube] France, Spain and Switzerland will be shown as children of Asia... – UlrichWuenstel Jul 04 '16 at 12:35

1 Answers1

2

As workaround for that case you can use simple CSS dirty-hack.

1) First of all under Widget option tab of your widget you should set Hide icons to yes.

2) After this, to avoid collision with other Pivot Tables, add custom CSS class

Custom CSS class

3) Add these styles to Report CSS.

.pt-flattened .pt-hcont{
    margin-left: 0 !important    
}
Artem Lopatiy
  • 948
  • 5
  • 15