nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

What is a functional group in Data Filter?

Sherry J George

OBIEE version 12.2.1.4.0

Hi,

I'm trying to get information on functional group in OBIEE data filter. (In rpd>Manage Identity>App Role>Permissions>Data Filter). Looking for any examples on how it is setup and used. The documentation did not seem to have detailed steps. Doc: https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-15DFA6FC-EDD3-4BE9-BEBA-BCD2E196AD0B.htm

Find more posts tagged with

Accepted answers

Gianni Ceresa

I did a quick test in the OAS 2025 (8.2) Model Administration tool (you said you are using OBIEE 12.2.1.4 but I don't have that Admin tool installed anymore).

It's a bit … weird the way it works…

Starting with no Functional Group at all, when you click on that cell, it does show the drop-down list to select a value. If you click again, it became an blinking cursor to start typing a value.

Once typed the value, for the other rows, you can then select it from the drop-down list.

I must admit that the very first row on that table didn't look like working fine. The drop-down wasn't showing, I could write but not make it stay, then it stayed, than I couldn't remove it. It's possible the very first row has some weirdness because of the coding of it or something.

All comments

Gianni Ceresa

Hi, welcome to the Oracle Analytics community and forum.

The page you link says it all…

When you define security on objects, be default rules are applied with a OR condition. It isn't an issue when you have multiple roles on the same attribute (dimension), but if you have multiple conditions on different dimensions, you often want a AND to combine all the conditions in an exclusive way. The functional group let you define rules to turn the OR into an AND. The examples in the page you linked show you that, with a generic simple example.

Sherry J George

Thank you. Though I did get the concept, I was not able to type in a functional group in rpd and get it to save. How do they appear in dropdown? I did search the internet for a more detailed real life example but could not find any. Is this something you have used? If so would you mind giving some steps and the scenario?

Gianni Ceresa

I did a quick test in the OAS 2025 (8.2) Model Administration tool (you said you are using OBIEE 12.2.1.4 but I don't have that Admin tool installed anymore).

It's a bit … weird the way it works…

Starting with no Functional Group at all, when you click on that cell, it does show the drop-down list to select a value. If you click again, it became an blinking cursor to start typing a value.

Once typed the value, for the other rows, you can then select it from the drop-down list.

Sherry J George

Thank you for taking time to look into this and providing the steps. For some reason I cannot seem to save the changes. I'm able to type the values in but after I save the rpd and open the data filter again the changes are gone. I have to see if it is a problem with the rpd or something else.

Update: I just tested on a new rpd and it works fine.

Gianni Ceresa

If you keep having issues with your RPD, you could save it in the MDS XML format, edit the XML manually as needed to add the functional group values.

I have the impression it isn't the RPD having an issue with it, but it's just the admin tool that is a bit weak on that aspect. If you edit the XML directly, it will be there, you can than save it back as .rpd and they should still be there.