Prompt Data Filter it's not safe

Question

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?

Andrew Fomin. · Answer

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?

327788734 · Answer

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,

Gianni Ceresa · Answer

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?)