General OBIEE

Get Involved. Join the Conversation.

    Pivot table in analysis - aging buckets
    Topic posted May 4, 2017 by new.biRed Ribbon: 250+ Points, tagged Analyses, OTBI 
    138 Views, 1 Comment
    Pivot table in analysis - aging buckets
    how to create a pivot table with columns as calculated field

    i am trying to create date buckets of 0-30 days, 30-60 days in OTBI. I was able to add a calculated column. however when i create a pivot table with the calculated column i get a blank. Is that a bug in OTBI or is that how is it working as designed. I could not get the bucket on the column - the data just show as blank.



    • JF Carpentier



      There is not enough information in your request to assist you, I strongly recommend adding detail about the objects being used in your pivot structure and perhaps a screenshot of the layout being implemented.   By your comment alone, there is no technical information that can be used to try and evaluate why your report is not functioning as intended.


      The data being blank or missing could be due to an invalid measure, or clause-resulting-in-null for the objects in your table layout.   More information is needed in order to obtain any value-added assistance.


      Thank you, and have a great morning!


      -JF Carpentier
      Senior Business Intelligence Consultant