Oracle Transactional Business Intelligence

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

Running into a problem using Pivot tables in Release 12

52
Views
2
Comments

Summary

Running into a problem using Pivot tables in Release 12

Content

We upgraded to Release 12 on September 25, 2017.  Prior to the upgrade, I was able to create pivot tables in OTBI ("Analysis" report) with more than one measure summarized. It will allow me to add one with no problem, but not more than one.  Is there something I am not doing correctly? 

Comments

  • Robin Friedberg O'Connor
    Robin Friedberg O'Connor Rank 3 - Community Apprentice

    I figured out the problem on my own.  The Workforce Goals - Status Overview subject area no longer contains an actual measure.  Something must have changed from REL 11 to 12 with this subject area because this was working.   I joined to a subject area that contains measures and the pivot table now will hold multiple measures. 

  • Sudheer amilineni
    Sudheer amilineni Rank 1 - Community Starter

    Thanks for the post .. I was searching for this