Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Pivot table not displaying column heading for my measurement

Received Response
31
Views
1
Comments
KevinjLayton
KevinjLayton Rank 3 - Community Apprentice
edited Aug 13, 2024 5:38PM in Oracle Analytics Forum

Hello,

I'm currently running Oracle 11.1.1.9.0 and I'm experiencing a problem with the column heading of a measurement on my analysis.

pastedImage_2.png

The measurement is just a distinct count of the employee ID's joined with to the select locations. I have tried editing all the properties that deal with names to what I want but it hasn't seemed to work. I even went through the XML to make sure it was being the column heading was in there which it was.

"

                  <saw:text># Count</saw:text></saw:caption></saw:columnHeading></saw:column>

"

I'm not to sure whats going on right now, any input would be great!

Thanks,

Kevin

Answers

  • KevinjLayton
    KevinjLayton Rank 3 - Community Apprentice

    Figured it out,

    For some reason it wasn't doing it if I modified the properties aggregation rule via the drop down menu.

    So I just created a new measurement and did COUNT(DISTINCT "employeeid") and the column name I made showed up on that one. Still not sure why it did this though.