Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    User Entered Measure DB access
Go
New
Search
Notify
Tools
Reply
  
User Entered Measure DB access
 Login/Join
 
Guru
posted
Hi,
When using the PMF User Entered screen for a measure, I get a message 'You do not have access to type in Actuals or Targets'.
The userid on the pmf_datamart database which the mainstreet connection is pointing to (the same userid in the connection definition), has dbo and sysadmin privileges.
I can read the database fine.
What privileges do I need to add Actuals and Targets for a User Entered Measure?
Note: 'pmfadmin' is the owner of the Scorecard where this measure is used.
Thanks.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 287 | Location: Boston/New England | Registered: February 12, 2006Reply With QuoteReport This Post
Master
posted Hide Post
This is PMF security, not DB security.

You need to make sure the Functional Role you are using has ability to update these.

If you don't have access to the Manage tab, have your admin do it.

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
Ok. Thanks, Bob.
I have access to the Manage tab.
'pmfadmin' has Administrator privileges and has the Functional Role of 'Admin' on all settings.
What else does this user need to save data?
Thanks.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 287 | Location: Boston/New England | Registered: February 12, 2006Reply With QuoteReport This Post
Master
posted Hide Post
Is that user logging in as pmfadmin which is associated with the Functional Role of Administrator? Or are they logging on as a different user with a different Functional Role?

In all Functional Roles there is a setting for each type of Measure Data for entry. Actuals, Targets, Benchmarks, etc. You'll find these settings at the bottom. Check the user's login against the Functional Role and make sure the user has Editor or Administrator access to the data. And remember you have Admin (if owner) else Editor and Admin (if owner) else Viewer. If it's Viewer, the user can see the data but cannot edit it. If they are not the Owner of the Measure in question, and it's "else Viewer," they are Viewer unless their ID is the Owner of the Measure.

Hope this helps.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
Thanks, Bob.

The user is logged in as pmfadmin and the Functional Role is Administrator. They are, also, assigned Admin to all settings the Functional Role panel.

Thanks.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 287 | Location: Boston/New England | Registered: February 12, 2006Reply With QuoteReport This Post
Master
posted Hide Post
This is odd - I just tested this to make sure in PMF 5.2.3HF2, which is what you have, and it's working fine. It also gets tested before we ship - but one always retests to make sure one isn't losing one's mind.

You probably need to open a case and have customer support have a look at this & help you out.

Do you have Row Level Security active for the measure in question, and perhaps have pmfadmin blocked out of some area of dimensionality? It doesn't seem likely that you'd get this error in that situation, but I can't think of another reason it'd happen.

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
Ok. Thanks, Bob.
I check your suggestions and then if there is no change, I'll follow with the help desk.
Thanks.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 287 | Location: Boston/New England | Registered: February 12, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    User Entered Measure DB access

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.