Multi-Dimensional Sets in a hierarchy

[Former Member]

Hi

I'm trying to create a set hierarchy which contains multi-dimensional sets. When adding the multi-dimensional set as a sub-ordinate in the hierarchy I receive the error <Set Name> invalid characteristic for Input Field HKONT.

The requirement is that on a report in BI we need to limit rows on a report to specific GL accounts and then specific transaction types (BEWAR) within those GL accounts. We have around 20 reports that have the same format but the GL accounts and Transaction Types on each row are different - hence we wanted to use sets to maintain the GL accounts and transaction types for each row.

So I've created several sets which are single sets and it all works fine. But when I create a multidimensional set (with Account and Transaction Type) it works fine. But when I attempt to add that as a subordinate set (ie to create the row in the report hierarchy) I get this message.

The Set that contains the rows can't be a multidimensional set as I can't add multi-dimensional sets to multi-dimensional sets.

Anyone come across this or know of a way around it ? or perhaps a different approach.

Thanks

[ajaycwa1981]

Hi

I guess the problem is because, in a multi dimensional set, you have more than one char i.e. HKONT and BEWAR... In your report row, have you included both of these chars or just one?

Try to include both the chars and then use a multi dimensional set in the row...

The idea of multi dimensional set is that no char in it should repeat... When you are adding this multi set to a BASIC SET or SINGLE SET, you are bound to get this error in GS01

Br, Ajay M

[Former Member]

Hi Ajay

I don't think you can add multiple characteristics to a single set. - ie it has to be a multi-dimensional set to do that but you can't include a multi-dimensional set as a subordinate of a multidimensional set.

Thanks