I have a web form with many rows and columns . Is it possible for a user to view only a limited rows in the form ? Not using Adhoc/Analyze option . since there are formula rows which wont appear in Analyze grid.
The user want to see only 5 to 10 random rows in the form ? How to do this ?
Are you using Smartview or web browser? With Smartview I think you can unprotect the sheet and the use a standard Excel filter to restrict rows (although this isnt an ideal solution as will leave the whole form editable).
Im really not sure how else you can get a dynamic selection of random rows at run time depending on a particular user and their particular requirements at that moment....
You can create a user variable and use that for showing members in the data forms rows or columns.
Ex: You can created a user variable saying UserVariable_SelectEntity and in the rows you have IDESC(UserVariable_SelectEntity), now user can select Entity as per there security access and data form will show number of rows based on the member selection.
Thanks for replying . But the user wanted to select random Entities . Say for eaxmple I have Entity dimension and E1, E2, E3 , E4, E5 are the entities . All the Entities are taken in rows in the web form.
Now the user doesnt like to see all the enities(E1, E2, E3, E4, E5) , but he wants to see only E1 and E2 to be displayed. and next time he would like to see E4 and E5 only. How can we do this ?.
Please let me know.
I remember an option in 11.1 which allows users to dynamically add rows and I cannot find that in 18.104.22.168
I think the user will have to always update the user variable to what he want to see.