Forum Discussion

VENKAB05's avatar
VENKAB05
New Contributor III
9 months ago

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.

 

Cube View
Reports
  • JackLacava's avatar
    JackLacava
    9 months ago

    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.

  • Krishna's avatar
    Krishna
    Valued Contributor
    9 months ago

    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
      9 months ago

      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
        Honored Contributor
        9 months ago
        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
    9 months ago

    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
      Honored Contributor
      9 months ago

      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.

Related Content