Column Heading properties in Analysis — Oracle Analytics

Oracle Analytics Cloud and Server

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

Column Heading properties in Analysis

Received Response
101
Views
13
Comments
Rajagopal R-Oracle
Rajagopal R-Oracle Rank 5 - Community Champion

hi.,

I want to display only one Column heading for two columns  in table as the Column heading name is same.

Ex:

Column Heading1   Column Heading1

-----------------------  -----------------------

Value1                   Value 2

have to display like below

     Column  Heading1

----------------------------------

  Value 1       Value2

Thanks

Raj

«1

Answers

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    In criteria:

    pastedImage_0.png

    In table properties:

    pastedImage_1.png

    END:

    pastedImage_0.png

  • Rajagopal R-Oracle
    Rajagopal R-Oracle Rank 5 - Community Champion

    thanks for the response , here i don't want to display amount and basement column heading., if I make Column Heading blank and display folder heading , there is blank space below folder heading

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Amount and Base Amount is for example only...

    Hmm, can you attach some screen what you do in obiee?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @3357027 Please don't go and change your original post if you expressed wrongly what yo are trying to do. It makes people responding to your question look like muppets even if the error was on your side and your problem description!

  • Rajagopal R-Oracle
    Rajagopal R-Oracle Rank 5 - Community Champion

    in the below table, getting blank space(column heading) below the folder heading

    Capture.PNG

  • Rajagopal R-Oracle
    Rajagopal R-Oracle Rank 5 - Community Champion

    thanks for the suggestion, will correct myself., is there any solution for my requirement.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @choracy69 He wants the equivalent of Excel's "Merge Cells" forgetting that we're in a dynamically rendering web front-end and not an XLS file and that things will just stop working and making any sense at all as soon as he does this:

    pastedImage_0.png

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    Will concatenating the two columns be fit for purpose? Did you try?

    Regards.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Please don't start concatenating measures as strings...let's try to keep at least a semblance of "we're doing analytics here" instead of "we're tricking ridiculous things on the GUI"

    ...cause I'd love to see an aggregate of

    "1234 6789"

    "7282 7393"

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    Valid point. That's why I said "fit for purpose".