Focal Point
[solved] edit owner access

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

April 15, 2009, 08:58 AM
Demanda
[solved] edit owner access
Is it possible to have to make or the drop down list box more dynamic in the edit owner access screen or replace the list box with a new feature. Example, as soon as you start typing in the box, the list box is narrowed down to your final selection. Something similar to what we find on many search engine sites or even in the address bar of windows explorer.

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


Business Analyst - Specialist in Business Intelligence
April 15, 2009, 09:32 AM
Bob Jude Ferrante
The first letter you type does work this way. However if the list of possible values is waaaaay long it's probably not enough. This is a good suggestion and we'll consider it.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

April 15, 2009, 09:37 AM
Demanda
Thank you Bob. As a matter of fact our list is waaaaaaaaay long, so I'm hoping that pm team can come up with something.

Amanda


Business Analyst - Specialist in Business Intelligence
April 15, 2009, 09:57 AM
Moogle
Hi Bob,

Is it possible to only show two or three dimension levels in the edit owner access screen's comboboxes? Our security model only makes use of the first, second and maybe someday third level of our dimension. The fourth level is the one that balloons the record count from about 150 to almost 30,000.

Even if you could just tell me what fex / html form builds those comboboxes, I'd be able to play around to make this happen in our Sandbox environment.

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
April 15, 2009, 10:43 AM
Michael Paul
Hi Moogle,

We do not have a built in way to only populate the top X number of dimension levels on the edit owner access screen.

In the future we hope to re-organize the dimension comboboxes to only pull the dimension levels used. This will allow handling large dimensions better and it will be more intuitive as all options won't be displayed at once.

That being said, if this is an issue that is pertinent enough that you would like to customize this. These comboboxes are controlled via a_list_dimensions.fex within the form row_lvl_sec_form.fex. Be very careful when modifying this or any programs in PMF for that matter. Place this within a separate pmf_custom folder when doing this work. I would probably clone off a_list_dimensions.fex and call this custom program from row_lvl_sec_form.fex as a_list_dimensions.fex is reused throughout PMF.

Cheers,
Mike
April 15, 2009, 04:21 PM
Moogle
Hi Mike,

Thank you so much, this is exactly what I needed. I now have my "edit owner access" screen displaying only the first two levels of my dimension.

Here's what I did:

-made a copy of a_list_dimensions.fex called gd_a_list_dimensions.fex, which I stored in pmf_custom
-copied row_lvl_sec_form.fex into pmf_custom and renamed the one in mainstreet, so pmf will only find the one in pmf_custom
-edited row_lvl_sec_form.fex (the new one in pmf_custom) to INCLUDE gd_a_list_dimensions instead of a_list_dimensions
-edited gd_a_list_dimensions as follows:

-**************
-:S03_OTH_LD

-*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
-* CCCCCCCCCCCCCCCCCCCCCCCCCCC
-* Restrict the Edit Owner Access Screen to not show style code in the comboboxes:
-SET &NUM_DIM_LVLS = 2;
-* CCCCCCCCCCCCCCCCCCCCCCCCCCC
-REPEAT :S03_LP2_LD FOR &LEVELS FROM 1 TO &NUM_DIM_LVLS

That's it, that's all. I'm very happy.

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
April 28, 2009, 04:31 PM
Moogle
Update: I realized the code that I added would cause the edit owner access screen to error if there is a dimension that only has one level. I know this is an unrealistic scenario, but I fixed it anyway. Now I only restrict specific dimensions to 2 levels, and let the other ones do what they will.

Here is the new code:

-*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
-* CCCCCCCCCCCCCCCCCCCCCCCCCCC
-* start of pmf customization
-* Restrict the Edit Owner Access Screen to not show style code in the comboboxes:
-*
-TYPE &THIS_DIM_ID
-SET &NUM_DIM_LVLS = IF &THIS_DIM_ID EQ HUB_1_ID THEN 2 ELSE &NUM_DIM_LVLS;
-SET &NUM_DIM_LVLS = IF &THIS_DIM_ID EQ HUB_2_ID THEN 2 ELSE &NUM_DIM_LVLS;
-SET &NUM_DIM_LVLS = IF &THIS_DIM_ID EQ HUB_ROLES_ID THEN 2 ELSE &NUM_DIM_LVLS;
-*
-* end of pmf customization
-* CCCCCCCCCCCCCCCCCCCCCCCCCCC



-&THIS_DIM_ID will return a value of '{Dimension_Name}_ID'
-I have three dimensions to filter, named HUB_1, HUB_2, and HUB_ROLES
-&NUM_DIM_LVLS is populated by a count of levels for the dimension that is currently being loaded
-My logic is that if I'm not dealing with one of my three filter dimensions, let PMF do what it wants

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows