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

VENKAB05's avatar
VENKAB05
New Contributor III
2 years ago
Solved

Is it Possible to use Drop Down in Cube View ?

Hello Experts,

Is it possible to use Combo Box and let users select value from the list in Cube View Rows (Headers) just like how we do in Excel. 

I see an option called Cell Type which has Combo Box but when i try it, doesn't work for some reason. Thanks in advance for the suggestions.

 

  • As others said, you can drive the parameter with a ComboBox component in a Dashboard. The CV itself does not support drop-downs directly on row headers; you can file an enhancement request on IdeaStream for that.

7 Replies

  • Krishna's avatar
    Krishna
    Valued Contributor

    VENKAB05  - You have to provide the List Parameter in the Next Cell. See below Screenshot. The Origin should be forms.

     

     

     

    • VENKAB05's avatar
      VENKAB05
      New Contributor III

      Thanks for the reply Krishna,

      This requirement is on the Row Headers, not on the data. The Metadata Balance Sheet itself should be a drop down which user can select..

      • JackLacava's avatar
        JackLacava
        Icon for OneStream Employee rankOneStream Employee
        1. Create a Parameter of Type "Member List", specifying which members should be available
        2. place that Parameter on the filter

           

  • VENKAB05's avatar
    VENKAB05
    New Contributor III

    Thanks JackLacava . Using Parameters brings it up before the CV is opened but the ask here was to display members as a drop down. Like Balance Sheet in the below example, that should have a flexibilty on the row to open a drop down and change Balance Sheet to 19999 - Assets.. Basically i want this Drop on Row Headers after the CV is opened. Not sure if its possible..Just checking..

     

     

    • JackLacava's avatar
      JackLacava
      Icon for OneStream Employee rankOneStream Employee

      As others said, you can drive the parameter with a ComboBox component in a Dashboard. The CV itself does not support drop-downs directly on row headers; you can file an enhancement request on IdeaStream for that.