Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
The Business Model Diagram:
-
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
-
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.
-
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.
-
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