Oracle AI and Analytics

Marco Zerbini

Hi All,

I have following issue in a report on OBIEE.

I describe the situation, I have 3 fields:

- Field 1 --> Field of Dimension

- Field 2 --> contains this formula (dynamic description)

CASE WHEN COUNT(DISTINCT "Dimension_1."ID_Dimension")>1 THEN 'Multipli'  

ELSE (

CASE MAX("Dimension_1."ID_Dimension") 

WHEN 1 THEN 'VALORE1' 

WHEN 2 THEN 'VALORE2' END) 

END

- Count Distinct ID --> Count Distinct Measure

Below the image1, in this case I have the expected result, but I need to add a new field to calculate other measure.

So, when I add the Field ID (Id that I count distinct), I have following result:

- Image2 --> if I keep the new field ID visibile on report, the rows are dived and the condition on Field 2 COUNT(DISTINCT "Dimension_1."ID_Dimension")>1 THEN 'Multipli' is not work

- Image3 --> if I exclud the new field ID, I get the error. How can I keep this visualization, but without the error?

I need to add the field ID as exclude for other measure and execute the condition on field 2...but without error.

Any Idea?

Thanks,

Marco

[Deleted User]

Hello Marco,

a) Which exact version?

b) Judging from your screenshots I assume you are working on an "analysis" and not a BI Publisher "report"? Those are two completely different technical objects.

c) It all depends on the level of granularity you're looking at. You have to describe your use case and issue more in detail. Are there any dimensional hierarchies involved? Is the attribute you want to count on a lower level of aggregation as the one you want to analyze by? Why is this not handled in the RPD? etc etc.