Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

What is a functional group in Data Filter?

Accepted answer
53
Views
5
Comments
sgeorge_otn
sgeorge_otn Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

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

Best Answer

  • Gianni Ceresa
    Gianni Ceresa Mod
    Answer ✓

    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…

    image.png

    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.

    image.png

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

    image.png

    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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.

  • sgeorge_otn
    sgeorge_otn Rank 2 - Community Beginner

    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?

  • sgeorge_otn
    sgeorge_otn Rank 2 - Community Beginner
    edited May 2

    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
    Gianni Ceresa Mod

    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.