Does not show value in the measure column — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Does not show value in the measure column

Received Response
1
Views
1
Comments
Sory
Sory Rank 1 - Community Starter

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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?