This requirement is made in OBIEE 11g. I am creating a Analysis. In the criteria tag I put a dimension field and measure filed and in the result tag the measure column doesn’t show any value.
There is a join between dimension table(dimension_d) and fact table(fact_table) in the repository.
Is the query pulling back NULLs from the data source?
Are the content levels wrongly configured and hence you get NULLs?
Is it really NULLs you're getting back or does "doesn't show any value means something different?
Have you made any checks yourself?
Have you looked at the query log?