Focal Point
[SOLVED] Different global profile for different groups

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

November 28, 2018, 04:10 PM
Aswin Ravikumar
[SOLVED] Different global profile for different groups
Hi Fellow Focus Members,

Can we assign different global profile for different group ?

For example ,

edaprof.prf for all users

sales.prf for sales users

engineering.prf for engineering users

account.prf for accounting users.


We are trying provide users access to adapter based on their role.(i.e) account.prf will have adapter connections specific for accounting users which cannot be accessed by other users.

I tried looking at server profile documentation but it did not help me much.

Thanks,
Aswin Ravikumar

This message has been edited. Last edited by: FP Mod Chuck,


Webfocus 8.1
Windows x64
Excel
November 28, 2018, 04:14 PM
BabakNYC
This might be a place to start.

https://webfocusinfocenter.inf....htm#d01Intro1051955


WebFOCUS 8206, Unix, Windows
November 28, 2018, 04:16 PM
Waz
Ditto,

Check out Group Profiles


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 28, 2018, 04:46 PM
Aswin Ravikumar
quote:
Originally posted by BabakNYC:
This might be a place to start.

https://webfocusinfocenter.inf....htm#d01Intro1051955


I followed this documentation already but it does not pickup the adapter in other profile except the ones that are defined in edaprof. Is there any settings that i need to enable ?

Thanks,
Aswin Ravikumar


Webfocus 8.1
Windows x64
Excel
November 28, 2018, 04:49 PM
BabakNYC
Could you show us how you are setting the alternative adapters?


WebFOCUS 8206, Unix, Windows
November 28, 2018, 04:57 PM
Aswin Ravikumar
Sure. I have a ldap user account called bus_dev_users. I created a bus_dev_users.prf file in the user/group profiles folder under workspace. In that profile , i added couple of oracle connections. I can see them in adapter list under adapter tab. Now i want to access those adapter connection from client/app studio to do sql passthrough and master file creation.

Thanks,
Aswin Ravikumar


Webfocus 8.1
Windows x64
Excel
November 28, 2018, 05:20 PM
FP Mod Chuck
Aswin

Does bus_dev_users match the WebFOCUS security group name. The name used in the WebFOCUS security center is the name that gets passed. If it doesn't match then it won't work.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 28, 2018, 06:57 PM
Waz
You may have to prepend the security provider to the group name, depending on the setup.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 29, 2018, 10:44 AM
Aswin Ravikumar
quote:
Originally posted by FP Mod Chuck:
Aswin

Does bus_dev_users match the WebFOCUS security group name. The name used in the WebFOCUS security center is the name that gets passed. If it doesn't match then it won't work.


There is where things gets unclear to me . So this means that i should apply the name that i have in security center not the ldap group right ?


Webfocus 8.1
Windows x64
Excel
November 29, 2018, 12:27 PM
FP Mod Chuck
Correct. On the reporting server when you add a group profile you use name in the security center.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 29, 2018, 01:04 PM
Aswin Ravikumar
quote:
Originally posted by FP Mod Chuck:
Correct. On the reporting server when you add a group profile you use name in the security center.


Thanks! That worked. Another question, Can we dynamically switch or call another profile based on the path that they are running ?

i.e if the path contains or ends with std_reports add a new profile which has additional oracle connections.

Thanks,
Aswin Ravikumar


Webfocus 8.1
Windows x64
Excel
November 29, 2018, 01:14 PM
FP Mod Chuck
Aswin

Let me try a couple of things. I will get back to you tomorrow.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 30, 2018, 11:14 AM
FP Mod Chuck
Aswin

I need to clarify where the string std_reports is. Is it part of the APP PATH or part of the security group name?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 04, 2018, 10:23 AM
Aswin Ravikumar
quote:
Originally posted by FP Mod Chuck:
Aswin

I need to clarify where the string std_reports is. Is it part of the APP PATH or part of the security group name?


It is folder in the content. We have several domain such as accounting, marketing etc

For each domain we have std_report folder which is handled by BI developers. We want that folder to have additional adpater connection than the one that are defined in edaprof.

Example file path : IBFS:/WFC/Repository/accounting/std_reports/sales/sales001.fex

Thanks,
Aswin Ravikumar


Webfocus 8.1
Windows x64
Excel
December 04, 2018, 11:32 AM
FP Mod Chuck
Aswin

The method I was going to try will not work because I am not aware of a WebFOCUS system variable that provides the path to the fex being run. If I had that variable then I was going to suggest using a site profile fex that evaluated that variable and if it contained std_reports would create the adapter connection. You might want to open a case with techsupport to see if such a variable does exist.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 04, 2018, 01:17 PM
Aswin Ravikumar
quote:
Originally posted by FP Mod Chuck:
Aswin

The method I was going to try will not work because I am not aware of a WebFOCUS system variable that provides the path to the fex being run. If I had that variable then I was going to suggest using a site profile fex that evaluated that variable and if it contained std_reports would create the adapter connection. You might want to open a case with techsupport to see if such a variable does exist.
\

&IBIMR_fullpath is the variable that will provide you the path to the fex being run.

I will try calling fex in edaprof that would add this.

Thanks,
Aswin Ravikumar


Webfocus 8.1
Windows x64
Excel
December 04, 2018, 02:33 PM
FP Mod Chuck
Well I learn something new every day. Thanks for that info.. That should work for you..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats