Analysis does not show data if one measure is null

1128728

Hello,

I have one analysis with 3 measures,when i run it says "no data". Reviewing the logs and executing the sqls over the database two measures returns rows but the other one don't.

How can i say to obiee that returns data in the analysis when one measure is null??

Thanks a lot.

SriniVEERAVALLI

you make sure all dims got a record with row_wid=0 or  check joins

1128728

Thanks Srini but how can i get a record with row_wid= 0??

The joins are perfect in each measure, the problem is that the analysis does not return data when one measure is null, i need that the analysis shows all measures, something like this:

Measure 1 = x

Measure 2 = y

Measure 3 = null

SriniVEERAVALLI

Try to get the BI Physical query and run in the database if you see data as expected then I would check rpd database properties for Null or config file if any.

1128728

The physical querys and the joins are fine for each measure as well as the result data, but when one of them is null my analysis doesn't show results.

Could you explain me where and how making a full outer join between the measures??

Thanks.

SriniVEERAVALLI

Assuming everything is up there suggested above.

Now doubting your model and data. Without looking your model and data granularity its hard to tell.

If Post got more info then anybody can suggest something.

cesar.advincula.o

I agree with @Srini, i could guess that you have these three measure in differents physical tables,

that's the reason why when you choose the another measure doesnt show any data, please, could you put some screemshoots to check, how do you model your RPD.

.

Kind Regards,

1128728

Cesar, thanks for your help.

In fact i have two facts, one with 2 measures and other with the measure that doesn´t return data for my query. These are the RPD measures screenshots.

cesar.advincula.o

Yes, OK, i got your scenario

 

Now, is more clearly, at this point, however, I want to ask you about the layout of your report, because the real solution for your requirement, it depends on of the layout/model of your report and the model of your RPD.

As a quick workaround , you can use the UNION in Oracle BI Answers, create your report with the measure that shows you data, and with the button add another criteria for the use of NULL measure, and use a pivot table to show your measure, however it is just a workaround, please, could you give me the layout of your report and tell me your physical/BMM diagram.

Kind Regards,

1128728

The problem is just there (the pivot table).

I just realized that my analysis returns results only if exists a pivot table, but if i have only my performance tiles (one per measure) doesn't work.

Thanks

1128728

The Business Model Diagram: