Line Item Suppression on Planning Forms
Does anyone know of a way to handle this situation while using a Line Item dimension on a cube view input form?
Let's say the Line Item dimension has 20 members. Can you set a default number of Li...
Forum Discussion
We had a similar requirement with 10 entity members that should be either hidden or shown on demand and we used the following workaround in v7.
- We created 10 delimited list parameters with "Yes" and "No" on the display item and "No, :U7#None".
- We added the parameters on the forms via 10 combo boxes
- We also added the parameter on the row of the each entity member in the form.
- For each row, we enabled the Suppress Invalid data
If the user selects No, the parameter value will be No and the POV of the row will be invalid and the row will be hidden. If the user selects Yes, the parameter will be :U7#None and the POV of the row will be valid and the row will be visible.
Cheers,
Thanos
Thank you. I tried this and the process does work, but I was hoping for something more dynamic. Using the parameter approach for line items would become quite cumbersome. I appreciate your help as the idea does have merit.