Sacha Tomey's blog - All Comments

re: An unknown server error occurred when submitting User

daman_badesha — Tue, 22 Jul 2008 15:55:06 GMT

Awesome!!! Post really helped.

The Planning Junkies List – Everything you actually need to get started..

BeI - Microsoft Business Intelligence — Sat, 12 Jul 2008 19:18:57 GMT

Hello everyone, My first intention was to write an intensive post about PPS SP1, or to be more accurate

4 The Cause » Blog Archive » PerformancePoint Planning - Data change tracking / audit trail

Thu, 03 Jul 2008 13:16:23 GMT

Pingback from 4 The Cause » Blog Archive » PerformancePoint Planning - Data change tracking / audit trail

re: PerformancePoint Planning - Data change tracking / audit trail

Eric Hewitt — Tue, 01 Jul 2008 15:11:13 GMT

Fantastic! This is definitely going into use. We've been using Triggers for other things (for example, friendly names for Assignments), but this definitely adds business value. Thanks, Sacha!

re: PerformancePoint Planning - Data change tracking / audit trail

Ola — Mon, 30 Jun 2008 21:16:59 GMT

A lot of additional info can be extracted from the assignment change table as well. It's stored as an image data type, but there's a bmo object that it can be cast too.

re: PerformancePoint Suggestion box

sachatomey — Tue, 17 Jun 2008 20:30:09 GMT

Peter,

Yup - I agree but the FDs seem to think that, as with their payroll system (that does prompt them for a password when they open it) that the staff do what they need in one-go and exit the system thus re-protecting data.

I see the authentication only occuring when the assignment is opened up initially.

It's all to do with usage and probably very specific to these payroll type situation.

re: PerformancePoint Suggestion box

Rob Goodman — Tue, 17 Jun 2008 18:46:22 GMT

How about the ability to use a SQL-Server Stored Procedure as a data source in the Dashboard Designer? This would provide a way to take code already written that is used for producing complex reports and enable scorecards to be created based upon the Result Set returned from the procedure.

re: PerformancePoint Suggestion box

Peter Eb. — Mon, 09 Jun 2008 23:31:31 GMT

Hmm...fundamentally the extra password is not more secure. Once you have typed it in you still have the same problem with locking data after it is displayed. Or do you have to type the password everytime you refresh?

Not to mention, by adding another password you are just increasing the liklihood that you cannot remember all your passwords and they may be written down in an easily accessible location.

re: PerformancePoint Suggestion box

sachatomey — Sun, 08 Jun 2008 17:46:16 GMT

Primarily the financial controllers were expecting to be able to set a application (or rather an assignment password) that would re-authenticate prior to the matrix being rendered.

I agree that users should lock their workstations but both financial controllers commented that their HR/finance system did not use single sign on thus providing an extra level or authentication that allowed users to be a little slack on locking workstations - A habit that ought to be broken IMO.

I agree there is nothing you can do if data is copied out of Excel and I presume there is nothing the HR/Finance system software vendors can do to protect the source data either.

In both cases we closed the deal so it wasn't a show stopper rather an expectation.

re: PerformancePoint Suggestion box

Peter Eb. — Fri, 06 Jun 2008 20:25:20 GMT

Aha, I get it. Its really the core workstation physical security that the issue then. I don't know what the PPS product can do to make this more secure.

It seems like you have to train users just like they lock their house/apartment/car doors (if they live in a big city) automatically. Thats the same thing you must do to your workstation. What would the controller's expect PPS to do?

(And then my next followup: what happens when you copy data out of excel and pps where I (pps dev) can't add any code to protect you?)

re: PerformancePoint Suggestion box

sachatomey — Wed, 04 Jun 2008 20:03:28 GMT

Hi Peter,

Yes, all I mean is, with Integrated Security, if someone walks away and does not lock their computer (naughty naughty) then potentially sensitive data can be accessed.

This has been raised by two of our customers (both financial conrollers) hence it's inclusion.

Regards

Sacha

Чего не хватает в PPS 2007?

Блог Войцеховского Максима — Tue, 03 Jun 2008 10:13:48 GMT

Наткнулся вот на такой пост - PerformancePoint Suggestion box . Обсуждение идет в форуме TechNet PerformancePoint

re: PerformancePoint Suggestion box

Peter Eb. — Tue, 03 Jun 2008 00:10:42 GMT

Can you clarify what you mean by "Integrated security is not secure !". Surely windows authentication (kerberos) is secure enough.

Or do you mean something along the lines of: if the workstation a user is logged into is not secured then somebody may come along and use that computer?

re: MDX Stored Procedures (Part 1)

joji — Tue, 06 May 2008 12:06:34 GMT

Thanks

I have already implemented it. But nice to have this class as well :), Thank you so much...

cheerz

joji

re: PEL Business Rule Re-use and Pre-defined What If Scenarios

sachatomey — Thu, 01 May 2008 09:03:53 GMT

Hi Peter,

Yes, you are right, rule parameters are an option – However, one point I failed to mention in my post is that I’m using definition rules; for that ‘instant’ response. If I were to employ rule parameters fed from the Excel Add-In, for example, I could not use a definition rule and this would result in an element of lag before the results are available. Also, it would possibly make comparing the results of two pre-defined what-if’s more difficult.

In my example I only use one member property to provide the factor/variance. In reality this could be a bunch of properties to describe some more complex what-if’s. Parameter entry could then become cumbersome when combined with a variety of different what-if’s.

I agree with your model variable point and relating the factor to the relevant scenario member and I guess that is the crux of the problem, and probably why I decided to go with a member property so I could use the natural relationship.

Thanks for your comments, always most welcome !!