topic Re: Crosstab with hierarchy width not working in SAS Visual Analytics

Crosstab with hierarchy width not working

Athg — Fri, 10 Jun 2022 10:00:57 GMT

Crosstab including hierarchy doesn't change cell width after saving and reopening the report. Changes referring to width seem to be discarded.

Image after saving changes:

Image after reopening report:

Re: Crosstab with hierarchy width not working

Madelyn_SAS — Fri, 10 Jun 2022 13:04:08 GMT

Which version of SAS Visual Analytics are you using?

Re: Crosstab with hierarchy width not working

Athg — Fri, 10 Jun 2022 14:12:20 GMT

Version: 8.5.1

SAS Viya Version: V.03.05

Re: Crosstab with hierarchy width not working

Madelyn_SAS — Fri, 10 Jun 2022 14:27:37 GMT

I have access only to 8.5.2. In that version, if the viewer state feature is enabled, the table should honor the width even if it is set in the viewer. Whether or not the feature is enabled, the table should honor the width saved in edit mode.

If that is not working for you, can you provide more details about the table.

How many data items are assigned?
How many levels is the hierarchy?
How is the hierarchy expanded (or not)?
Which types (category or measure) of data items are on the rows and which on the columns?

It is also possible that this is a defect in 8.5.1, but I have not found anything that seems related.

Re: Crosstab with hierarchy width not working

Athg — Wed, 15 Jun 2022 07:28:36 GMT

1 row with category hierarchy and 4 measure items are assigned
Hierarchy consists of 4 levels and can be expanded
The width problem remains in each level of hierarchy

Re: Crosstab with hierarchy width not working

Madelyn_SAS — Wed, 15 Jun 2022 14:26:21 GMT

Thank you for the information. With those role assignments, I do see a problem with the width. I am sorry but I don't see any way to retain the width after the report has been closed and reopened. I tried unchecking the options to extend width and fit columns to width, but the behavior was the same.