Excel export: how to expand hierarchy

#1

I have a table in a dashboard. This table has a time hierarchy (default Y > M > D), which is expanded on screen (level=Day, top level=Year):

screenout
screenout.png736×396 21.4 KB

If I export this table in excel (via the share button, or via my own script), this hierarchy is not expanded:
xlsout

(Forget the colors, it is (according to me) another bug in the excel export, where the “total row” styles are completely mixed up in excel, whereas they are OK-ish on screen. Both images should have the same cells in red.).

As you can see, the hierarchy is nicely expanded on the screen, but only the lowest-level (Day) shows in excel. I am pretty sure it is possible to get the expanded hierarchy in Excel.

Anyone would know how to do it?
Thanks,

#2

In the Excel sheet here how it goes:
line 2 = the Dec 25 NL aa line
line 3 = the Dec 25 nl “ALL” line that is not red in your report so it is not red in Excel.

It is expanded see lines 8, 9 and 10. it just not taking up as many columns as the Dundas Table.

The only thing I see here is that 2108 (line 9) should be colored.

I know this is not a solution just wanted to point out that all the data is there and how it got transformed to an Excel style form a Dundas Table Style that has more option on how to display the data.
Basically think of it this way:
Dundas is a 3640 X 2160 (4K) display and you just exported it to 1024 X 768.

#3

Maybe I should not have put a colored image, it was not the point of my question, but I am happy to talk about it :slight_smile::
The discrepancies for the color are bigger than that:

  • the column “name” is not red at all
  • if line 4 is not colored, then line 6 should not either
  • line 9 is indeed not colored

I would argue as well that on screen the rows with (All) for the “name” are total rows as well, so should be colored.

When I said expanded, I was talking about the year/month/day columns in that case. They appear on screen, but not on excel. I only have day, although you are right that it drills up for the last rows.
I know that I had all the columns in a previous iteration of my dashboard, but I did a big-bang change of the underlying cube + dashboard, and I lost the expanded columns. I wonder how to get them back.

Thanks,

#4

did you put the date hierarchy back on the data cube, that might have been lost in the big bang change

#5

Thanks for the suggestion but I just double checked it’s indeed there. I can expand it on my screen after all :slight_smile:

#6

Just verifying that this is the current behavior of the export. Expanded members are being shown but the full hierarchy is being collapsed into a single column. If you feel strongly about different behaviour, please reach out to the support team and open a feature request.

#7

Thanks Jeff. I mostly feel like the export should (or should be able to) match the screen. At least now I know I can stop looking.

Thanks!