Forum Discussion

Cosimo's avatar
Cosimo
Contributor II
3 years ago

Prompting for parameters for Tableview

I've got a Tableview embedded in an Excel workbook and would like to be able to prompt the user to select an entity and period that is then used to filter records. Is this possible?
Spreadsheet
  • LeeB's avatar
    LeeB
    3 years ago

    Yes, this is possible.

    You define your parameters in a list.  "SelectEntity" could be a normal parameter i.e., Member List, Member Dialog etc. 

    Then retrieve them in your Table View rule using the strings in your SQL query.

    You'll then get prompted for these parameters on refreshing the Table View.

     

GorkemSenol's avatar
GorkemSenol
New Contributor III
2 years ago

Hi both,

Maybe a silly question but when I add the parameter it just gives me a textbox to input a value for the dimension. Is it possible to present the user with a memberdialog or a list?

  • Cosimo's avatar
    Cosimo
    Contributor II
    2 years ago

    Hi Gorkem,

    You certainly can by 1st defining a dashboard parameter (be it delimited, member list or member dialog) and then use it in cube views, table views, books, etc. Below is one example which I then call using |!DepartmentSelect!| elsewhere:

     

     

     

    • GorkemSenol's avatar
      GorkemSenol
      New Contributor III
      2 years ago

      Thanks Cosimo,

      I realized there was something wrong with how I set up the parameter. I'm also struggling to get the result of the parameter selection and use it to filter the SQL. Can you let me know how did you achieve that? I want OS to filter the SQL based on the year and scenario selection from user.