Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Fahad Cader
    Some columns have null values for certain records and record...
    Topic posted November 6, 2019 by Fahad CaderRed Ribbon: 250+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI, Reports 
    17 Views
    Title:
    Some columns have null values for certain records and record is not retrieved when the column is selected
    Summary:
    Some columns have null values for certain records and record is not retrieved when the column is selected
    Content:

    I am using "Fixed Assets - Asset Depreciation Real Time" subject area, and for some Records, the "Time"."Asset Calendar Period Name" is null. 

    In this case when I include the column "Time"."Asset Calendar Period Name" , the null records are dropped. 

    If I remove, the records are shown. How can I handle this scenario, as I need this column in the report