Show All Text Cube Values for Each Entity Member

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.

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Accepted Answer

  • Employee, Community Captain
    Fifth Anniversary 50 Answers 500 Comments 250 Likes
    Answer ✓

    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

Answers

  • Employee, Community Captain
    Fifth Anniversary 50 Answers 500 Comments 250 Likes

    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

  • Employee
    5 Answers Second Anniversary 10 Comments Board Advanced Developer
    edited February 25

    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,

  • Customer
    10 Comments 5 Likes Name Dropper Board Developer

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In