Show All Text Cube Values for Each Entity Member

Efraim · 2025-02-25T11:31:04+00:00

There was an error rendering this rich post.

Hi all,

Is it possible to show all text cube values for each specific entity member?

I am trying to show all values from a text cube that are mapped against the accounts (See sample table below).

When I try to use the text cube in the Layout, it's only showing one line of text when there should have been multiple lines. I set the Summary to "No total" so hopefully it would not summarize it and show all but no success.

Find more posts tagged with

Accepted answers

Helmut Heimann

Hi @Efraim ,

that's what I thought.

You will still need the dimension of the Sublevel to distinguish the different texts. Both in the cube and the dataview. In the dataview, you need to flatten the hierarchy, then you can set the sublevel column to

width of 1
no text-wrapping

That's what I'd try.

Best,
Helmut

All comments

Helmut Heimann

Hi @Efraim ,

my question would be how those different texts can be distinguished.

A text cube usually stores only one line (you can't insert any carriage return or linefeed) per dimensional combination. So I'd suspect you need a distinguishing dimension for each line and introduce that into the cube.

Best,
Helmut

Hamza Mesbahi

Hi @Efraim

As @Helmut Heimann mentioned above, each row in a layout represents a separate entity member. In your case, if you expect each Text value (e.g., Text 1, Text 2, Text 3, Text 4) to have its own row, you would need to enter those values under different entity members, not all under Account 1.

However, if you're asking about formatting, specifically, how to have separate lines within the same text entry for an entity member (like having separate lines for each of the "Text #" values under Account 1), you can achieve this by skipping a line after each Text entry (e.g., "Text 1", skip line, "Text 2", skip line, etc.). You would skip line in a data entry cell by pressing Alt+Enter after each input. Afterward, enable the “Wrap text” option in your dataview Columns settings (see below for reference).

The screenshot below shows the first dataview without the setting enabled, the second with it enabled.

I hope this helps!

Kind regards,

Efraim

Hello @Helmut Heimann,

Sorry, I should have mentioned that in the question.

The text are distinguished by the Account breakdown (1 level lower than the Account) but I wanted to somehow Summarize it to only show Account and the Text column.

So I think the question would now be - Is it possible to show the table format (Screenshot above) without displaying the Breakdown.

Helmut Heimann

Hi @Efraim ,

that's what I thought.

width of 1
no text-wrapping

That's what I'd try.

Best,
Helmut