Add Subtotals Support in Export Data Set feature for Unbalanced Entities

Akrem ABDELHAFIDH · 2025-05-06T15:28:23+00:00

There was an error rendering this rich post.

Currently, when exporting a Data Set from a cube that includes an unbalanced entity, the subtotals of that entity’s members are not included in the export.

I suggest enhancing the Export Data Set feature to properly support subtotals for unbalanced hierarchies

thanks

Find more posts tagged with

Open For Voting

Data Modeling

Entity

Procedures

Data Extract

Status: Open For Voting

Comments

Kevin Kowalski

Hello Akrem,

Thanks for sharing your interest on unbalanced hierarchies ! As you mentionned the only way is by 'Extract Dataview"…

From my perspective the solution is a matter of "unbalanced selection mode" applied, which I described in the article below😊

Part :
"Export Dataset/Dataview with unbalanced totals"

https://community.board.com/discussion/18479/unbalanced-hierarchies-allowing-selection-mode-configuration-in-dataflow-and-export

Kind Regards,

Kevin

Akrem ABDELHAFIDH

Hi Kevin

Thanks for sharing the article it’s very interesting.
Appreciate the clear explanation and examples.

Best,
Akrem