Analysis does not show data if one measure is null

cesar.advincula.o

Hello,

1. SOLUTION 1:

Please, this is a workaround, it is not the best solution, however OBIEE as a enterprise BI platform has a mechanism to your requirment.

Create an UNION in Oracle BI Answers, check this example of how to create it:

For your PIVOT TABLE

-Criteria 1:

CENTRO FORMACION.REGIONAL_NOMBRE

CENTRO FORMACION.REGIONAL_CODIGO

FACT - METAS(MEDIDAS).VALOR META

TYPE COLUMN(this column it would be whatever name that you want) and put in the formula of your column in hardcode (' VALOR META')

-Criteria 2:

CENTRO FORMACION.REGIONAL_NOMBRE

CENTRO FORMACION.REGIONAL_CODIGO

FACT - METAS(MEDIDAS).APRENDICES ANTIGUOS

TYPE COLUMN(this column it would be whatever name that you want) and put in the formula of your column in hardcode (' APRENDICES ANTIGUOS')

-Criteria 3:

CENTRO FORMACION.REGIONAL_NOMBRE

CENTRO FORMACION.REGIONAL_CODIGO

FACT - METAS(MEDIDAS).APRENDICES NUEVOS

TYPE COLUMN(this column it would be whatever name that you want) and put in the formula of your columnin hardcode ('APRENDICES NUEVOS')

The layour of your PIVOT TABLE

-Rows:

  CENTRO FORMACION.REGIONAL_NOMBRE

  CENTRO FORMACION.REGIONAL_CODIGO

-Column:

  TYPE COLUMN(this column it would be whatever name that you want) and put in the formula of your column in hardcode (' VALOR META')

-Measure:

  the column agregate of your measure

For your titles:

Lets create three reports for each title, and in your dashboard you could put each report with your title in your layout.

2. SOLUTION 2:

2.1 Create a opaque view to join and compare your two fact table, and mapping it in your RPD.

Kind regards,