Oracle Transactional Business Intelligence

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

Pivot table in analysis - aging buckets

44
Views
1
Comments

Summary

how to create a pivot table with columns as calculated field

Content

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.

Tagged:

Comments

  • Rank 2 - Community Beginner

    Hello new.bi!

     

    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
    jfcarpentier@modulusdata.com

     

Welcome!

It looks like you're new here. Sign in or register to get started.