Hi, so I have a dimension in cognos cube, which is basically: Level 1 > part_code.
Now what is needed is, in addition to this, there needs to be another drill-down to this final level (part_code), which goes :
Level 1 > Level 2> part_code -- level 2 is either going to be 'Other' or 'Show'. Anything under 'other' should not be shown, all that should be seen of the values under this section is 'other'. So to achieve this, I suppressed all the values under this level so all you see is the heading 'others' without being able to drill into this. The values under 'show' are fine as they are. So when you look at the cube, level 2 has either 'other' or the values under show displayed.
This works fine, all the part_codes under other are summed up into 'Other' where as you can still see the ones under 'Show'. the problem is that any suppressions in one drill-down seem to affect the other. any part_codes i suppress in this new drill-down are also so suppressed in the old one. is there a way to only display certain values in one drill-down and not in another?
The other way round i tried was doing another dimension instead of a drill-down but seems you cant have two dimensions with part_code at the bottom level.
Thanks, any suggestions v much appreciated
Now what is needed is, in addition to this, there needs to be another drill-down to this final level (part_code), which goes :
Level 1 > Level 2> part_code -- level 2 is either going to be 'Other' or 'Show'. Anything under 'other' should not be shown, all that should be seen of the values under this section is 'other'. So to achieve this, I suppressed all the values under this level so all you see is the heading 'others' without being able to drill into this. The values under 'show' are fine as they are. So when you look at the cube, level 2 has either 'other' or the values under show displayed.
This works fine, all the part_codes under other are summed up into 'Other' where as you can still see the ones under 'Show'. the problem is that any suppressions in one drill-down seem to affect the other. any part_codes i suppress in this new drill-down are also so suppressed in the old one. is there a way to only display certain values in one drill-down and not in another?
The other way round i tried was doing another dimension instead of a drill-down but seems you cant have two dimensions with part_code at the bottom level.
Thanks, any suggestions v much appreciated