[SOLVED] Access the Groups and Subgroup names for the Current logged in User
Hi All. I need to get the group and subgroup names for the currently logged in user.
Currently i am using &IBIMR_memberof to get the groups and usergroups.
When i run - -TYPE &IBIMR_memberof in my domain then this variables gives me the corresponding names of the groups and sub groups.
But when i run the same fex in my edaserver it prompts me the parameter value for &IBIMR_memberof variable.
I have set the value in the Client Custom setting. IBIMR_memberof(pass)
Not sure why this is not working in the Edaserver? How we can get the Groups information for the currently logged in user in Edaserver?This message has been edited. Last edited by: FP Mod Chuck,
Webfocus 8.x Windows PDF,HTML,XLSX
September 19, 2018, 05:48 PM
Waz
Hi Rajesh,
Welcome to the forum.
Are you executing the code directly on the reporting server ?
IF so, then this is the issue, as the &IBIMR_memberof variable is created via the web client and passed to the reporting server.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 20, 2018, 05:32 AM
Rajesh Singh Negi
Hi Waz,
Basicallly i need to apply the DBA security. after creating mdf profile and doing all the stuff required for it and then i run my master file ideally it should filter the data but when i do that i am getting error where i have used &IBIMR_memberof variable. So i guess the server is not recognising the variable. Also i have passed the users and the groups from client to the erver in administrative console settings.
Webfocus 8.x Windows PDF,HTML,XLSX
September 20, 2018, 04:58 PM
Waz
Whats the error ? Can you post the Master and MFD Profile ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 24, 2018, 04:23 PM
TobyMills
Hi Raj
In general, it sounds like you want to rely on how a Users's Security is set up in the Client (via Security center groups).
The catch is that if you're running straight off the WF Reporting Server, it doesn't know much of anything about the client Security setup. It only knows how the security is set up on the WFRS (WebFOCUS Reporting Server). You can create users and groups on the WFRS to function sort of like what you see over in the Security Center of the client.
You're not really stuck if you're using External Security (like Active Directory for example) to know what Groups a person belongs to. If you use AD on the Client side and "MAP" an external Group to a WF Group, you can use that same concept on the WFRS directly. It's a little extra work.
Let me ask a question though. Are you really going to let users run directly from the WFRS (as we used to do with "self service" applications pretty often)?
If you're always going to come from the client, or new enough report caster, the client variables &FOCSECUSER and &FOCSECGROUP are something you could use.
My guess is that you're using site.wfs on the client to populate the missing value you're seeing on the WFRS.
There's an older paper that is really geared toward making Software as a Service applications and how you'd handle security there, but it talks about the relationship between the Client Security Center and the WFRS groups / users. Might be worth a look: