Forum Discussion

CarlosAlvear's avatar
CarlosAlvear
Contributor II
2 years ago
Solved

repeat row headers in a CV using Data Explorer

Dear all, I'd like to know whether you've been faced to this issue. When defining the CV there are several nested dimensions in the row definition and I'd like to show it so that the header is repe...
Cube View
  • JackLacava's avatar
    JackLacava
    2 years ago

    I think that's just how Data Explorer works.

    What you're asking for, if you think about it, is basically a straight table of records. So if I really wanted this for display purposes (not PDF), I'd build a Data Adapter of type Cube View or Cube View MD and wire it to a Grid Component, BI Viewer, or Pivot Grid.

    Obviously that doesn't work if you need a CV for things like forms or Excel submissions. In that case, I'd just try to be clever with XF functions directly in Excel, again to produce effectively a table of full records.

    PDF outputs are a different ballpark, because they have more options and, where they fall short, even CV Extender rules.

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

I think that's just how Data Explorer works.

What you're asking for, if you think about it, is basically a straight table of records. So if I really wanted this for display purposes (not PDF), I'd build a Data Adapter of type Cube View or Cube View MD and wire it to a Grid Component, BI Viewer, or Pivot Grid.

Obviously that doesn't work if you need a CV for things like forms or Excel submissions. In that case, I'd just try to be clever with XF functions directly in Excel, again to produce effectively a table of full records.

PDF outputs are a different ballpark, because they have more options and, where they fall short, even CV Extender rules.