Focal Point
MR Groups for a MR User [Solved]

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3597076476

February 11, 2015, 11:49 AM
gweller
MR Groups for a MR User [Solved]
Is there anyway to report on the MR groups which the current user is a member of? (I am on 7.7.5)

This message has been edited. Last edited by: gweller,


WebFOCUS 8201M/Windows Platform
February 11, 2015, 12:08 PM
eric.woerle
gweller,

Are you looking to know what the user is a part of when the user logs in? If so you can use the IBIMR_memberof variable. You will have to add it to your custom settings on the client to make it available to use.

Are you looking to interrogate a group and create a list of all the users that are a part of it? Then this would depend on how you handle your security. Do you use a External or Internal security? If you are using a RDBMS to hold your security information you could write a query off of the security tables. If you are using internal security, I believe there is a way to create a master file to read the internal files, but I'm not sure how to do that.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
February 11, 2015, 12:19 PM
gweller
Option 1....

I attempted to look up the IBIMR_member of variable and cant seem to find any documentation. Can you point me in the right direction?


WebFOCUS 8201M/Windows Platform
February 11, 2015, 12:33 PM
gweller
I found this,

https://techsupport.informatio...om/sps/93102553.html

I tried it with no results. Any idea if this is limited to v8 and higher? I am on 775


WebFOCUS 8201M/Windows Platform
February 11, 2015, 01:45 PM
Tom Flynn
Yep, that is version 8 & variable.
Use the MREXTRACT utility...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
February 11, 2015, 03:07 PM
eric.woerle
gweller,

It was my understanding that &IBIMR_memberof was available in 7705, but I could be wrong. I only started using it in 8008. When you say you attempted this, did you add

 <SET>IBIMR_memberof(PASS)
 


To your custom settings on the client, restart your Tomcat, logout and log back in?


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
February 18, 2015, 01:30 PM
gweller
I ended up using the MR Extract utility as the &Variable was unavailable in the version I am using.

Thanks


WebFOCUS 8201M/Windows Platform