Groups and User info can be accessed through SA System similar to what it used to be in 10g. Application roles can only be exported through WLST. Thanks!

Try this blog Import Microsoft Excel data in to OBIEE on AIX - Toolbox for IT Groups

Are you querying relational and essbase data from two different subject area?

SA System Subject area can help you with the groups assigned to users.

I think you can achieve this by conditional formatting on month column cased on your shop number column.

Add another column for measure and apply RANK to that column and sort it. It worked for me in the past. You can always hide the column.

I have done it through sql and brought it as a view in repository. Not sure if OBIEE functions have this capability. Let me know if you want me to paste the sql code to exclude weekends.