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

Prompt Data Filter it's not safe

Received Response
12
Views
6
Comments
327788734
327788734 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

Dear Experts,

In my application bi.

When the user selects the option (prompt data filter, if check 'all values'), the BIEE shows a value.Ex: $200,00

But!.

The same user selecting one by one each of the options of the same prompt data filter value is different. Ex: $135,00

This is the least confusing.

Any sugestion?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Well, probably a inner join filtering ....

    Selecting "all values" I imagine remove the filter completely => maybe that dimension isn't used at all => no inner join implicit filtering.

    Selecting all the values one by one will change the query => different data.

    Can also be because of a different set of tables used if you have many facts with different content levels / logical joins.

    Can also be because you set the column as not NULL but actually contains null values ....

    As you see there are tons of reasons all related to something you are the only one able to check.

    So take the physical query of both cases and look at it, what is different and then go down to the data to find out why you see different figures.

  • 327788734
    327788734 Rank 3 - Community Apprentice

    in this case:

    The user user5016 which is the grp_sec_5016 security group.

    In this group, there is a filter date:

    (

    admintoll> manager> identity> select the group (grp_sec_5016)> permissions> DATE FILTER

    > Type Mapping and Business Model

    > Selected dimension in the business model (not the presentation layer)> Filter Dimension.Id_code = 5016

    )

    This filter works for all reports, charts and queries in BI perfectly.

    Just does not work when the user selects 'All Values' in a report / graphics filter prompt.

    When you select the 'All Values' option value is, eg $ 300.

    When you select all the items (which are filtered by the filter data) the value is eg $ 235.

    Detail the filter promto is exactly Dimension.Name (brother attribute the Id_code).

    I hope to have better explained the situation.

    I'm taking the physical queries but not sure if the data filter will contain them.

  • 327788734
    327788734 Rank 3 - Community Apprentice

    For my analysis so far.

    the filter prompt when it is set to 'All Values', does not respect the Data Filter defined in the repository.

    This interpretation may be correct?

    There are other cases where this can occur?

    Thank you

  • Gianni Ceresa
    Gianni Ceresa Mod

    Do you really see that in the physical query?

    Because that doesn't sound like the normal behaviour ....

    A data filter set in the RPD is always applied and must not be overwritten by "all values" (what's the point to set it if you can get rid of it so easily?)

  • 327788734
    327788734 Rank 3 - Community Apprentice

    Not in the filter data in fisical query SAWITH0.

    Test querying/report in semantic layer returns values respect the data filter.

    Really strange case is when you select 'all values' of a filter prompt.

    By the way: this is BIEE 12.2.1.1.0 (Build-BIPS 20,160,604,082,456 64-bit)

    Tomorrow will return at this point.

    Thanks,

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead 
    327788734 wrote:The user user5016 which is the grp_sec_5016 security group.In this group, there is a filter date:(admintoll> manager> identity> select the group (grp_sec_5016)> permissions> DATE FILTER> Type Mapping and Business Model> Selected dimension in the business model (not the presentation layer)> Filter Dimension.Id_code = 5016)

    Does that mean that you have a filter defined for a dimension, not for a fact?