I have a situation where I would like to run benchmark reports for a number of individuals in the database. Each individual needs to see their own performance against all the others, but only their own performance should be labelled - the user should not know which data applies to which other individuals. The simple solution is to anonymise everything with a code and tell each user their own code. Ideally I would like the report to recognise the current user and highlight their data, on a bar chart/histogram highlight their bar, this has the benefit that they cannot deduce others by comparing performance against different benchmarks for the same code.
BO 5.0.1 Oracle 8.
I could manage this in Supervisor, Designer or Reporter and could incorporate additional tables in the underlying database to support this.
My SQL skills are OK, I have used VB against Excel but not BO and my skills are still very poor.
Jonathan Bliss, Product Consultant
McKessonHBOC Computer Centre,
Harold Wood Hospital site, Gubbins Lane, Romford, RM3 0NE mobile:0498 668084, tel 01708 336135 (direct line with voicemail), fax 01708 376270
This may not be of any use, but what about using the grouping function? I do not know how to automate this, but there may be a way. You would have one group of just the one code, and group the rest together under the anonymous code.
Simon
Thanks Brent
I think this is almost it. I could define the name object to only show the name dependant on the current user and some sort of null/missing otherwise. The only problem with this is the results would sum the other users. I still need to see all 100 users as it is the rank within the user community that is important. An added complexity is that department managers want to see all their users but not the named users in other departments. This feels like the right lines though.
I could manage department heads by testing against the appropriate table which has the manager - employee relationships in the name object. Now all I need is to differentiate each user instead of a standard null. I may be able to allocate a rank value where the name isn’t present, this would work in pre-written reports. Could I set this as a Universe Object? I think I’m almost there, this is a wake up at 3am with the solution problem now.
Jonathan
Brent wrote:
What about using a calculated field for name, something like if name=bouser(),name, ‘----’
Depending on your sql, you could use case here, maybe IIF?
I have a situation where I would like to run benchmark reports for a number of individuals in the database. Each individual needs to see their own performance against all the others, but only their own performance should be labelled