This discussion is archived
3 Replies Latest reply: Dec 24, 2012 3:09 AM by 981489 RSS

HFM Form Query

user12121146 Newbie
Currently Being Moderated

We have a data form in which we have blocked few combinations for user input.
We have checked the form & it was working fine even through smatview as well.
But some of the user has inputted the data by taking those combination into excel.
So does that mean user can input the data for any account combination which holds valid for input?
If it is correct then what should be the correct approach to take input from user so
that user can't input the data for the combinations which are blocked for input in forms.

Also in current HFM Application we have around 5thousand accounts.
I can't write all those accounts for no input in rule.

Please share your suggestions.

  • 1. Re: HFM Form Query
    chris barbieri Oracle ACE
    Currently Being Moderated
    If you want users to only be able to input via forms, then you should restrict their security from loading via Excel or from grids. Use the role security in HFM to help with this.

  • 2. Re: HFM Form Query
    user12121146 Newbie
    Currently Being Moderated
    Thanks Chris for replying.

    We don't want to restrict user from inputting data via data forms. They used to download the forms in Smart view and then upload data. Please suggest how we can restrict user not to insert data rest of the combination which are not there in forms.
  • 3. Re: HFM Form Query
    981489 Newbie
    Currently Being Moderated
    In the HSS user roles, there is an option which allows users to input data using data grids.
    Pl remove this role

    This role allows users to input data using data grids (web on on Smartview)
    Since the users were enabled to input through grids, they were able to form their own grids in Smartview and input the data.

    Remove this and this check will be in place.
    The catch to this is that all data input will be then routed only through data forms (all scenarios)