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.
I agree that it is not as dynamic as we would expect.
I think that in v8 you are able to use a more dynamic approach. I will probably test it in a couple of weeks..
If you come up with something more dynamic in v8+, I'd appreciate any more feedback. I've been trying it in v8+ and haven't come across anything with the suppression properties and something like this. Thanks again for your help.