The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

arpitm's avatar
arpitm
New Contributor III
6 months ago
Solved

Cube Views - Nested Dimensions - Fill in all rows

Hi Everyone,

I have received a request from the business regarding a cube view report where they wish all the rows to be populated with the dimension member.

For example in the screenshot below, they would wish to see "Entity 1" populated for all the lines in the second column of Largest Clients.

 

 

I am not sure if that is feasible unless someone has found a way. Thank you in advacne for your response.

Regards

 

Cube View
Reports
  • pranav46's avatar
    pranav46
    6 months ago

    Hi,

    You got to write XFBR or memberlist which is finance function. Loop through buffer and read client which is highest cell value and return a list in cubeview.

    Thanks
    Pranav

1 Reply

  • pranav46's avatar
    pranav46
    Contributor III
    6 months ago

    Hi,

    You got to write XFBR or memberlist which is finance function. Loop through buffer and read client which is highest cell value and return a list in cubeview.

    Thanks
    Pranav