Forum Discussion
Solved
Linked Parameter in Table View
Hello,
I have a doubt about table view custom parameter. Let's say we have defined two parameters namely "Param_1" and "Param_2". the requirement is my "Param_2" values should be based on "Param_1"...
Second TableView won't work. it will combine and prompt all TableView Parameters at once. using a separate cube view connection only for parameters solved my issue.
I am guessing you need additional details on Jack's response. You will need to define Param_2's values based on Param_1's selection with a Dashboard XFBR String business rule.
In the following example, the available periods to be selected are defined by the selected scenario. My scenario parameter (par_Comparative_Scenario) has no logic, but my period parameter (par_Comparative_Time) calls an XFBR String helper that defines the available values as shown next.
Parameter par_Comparative_Time, calls XFBR String String_Helper passing the selected scenario par_Comparative_Scenario:
Selecting Actual allows selecting 2022, 2023, or 2024. Whereas selecting other scenarios only allows selecting 2024.
Regards,
Mauro Gallo.
Hello Mauro,
Thanks for quick reply, the solution which you have provided is dashboard based using two different combo boxes, this logic is not working in the table view case. I guess it is not working because all the Parameters in the table view gets prompted once.
For more details about my case please look at my reply to the Jack's comment. I really appreciate if you take out your time and see if you find any work around for this.
Thank you!
Apologies, I missed the "in Table View" part of the ask. I believe you can't nest parameter definitions in table views in this dynamic way, as there are not two "events" to resolve the second parameter based on the first one.
Could you solve this with a second TableView on the spreadsheet? Not suggesting you can, just thinking out loud.
