Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 10G - Line Bar Combo: Unable to apply two lines

Closed
41
Views
5
Comments
Jaspal D
Jaspal D Rank 2 - Community Beginner
edited Sep 16, 2024 10:53AM in Oracle Analytics Cloud and Server

Hi,

Looking at guides and other sources for 10G charts it appears there is a way to apply two lines on a bar chart combo. However, I am unable to see options on what to select as a bar and what to select as a line. It appears the first measure is automatically selected as a line and any other measure after that are selected as bars.

Can anyone please advise (with screenshots if possible) on how to specify the bars and lines? Thank you in advance!

Line Bar Combo

A line bar combination graph plots two sets of data with different ranges, one set as bars, and one set as lines overlaid on the bars.

Line bar combination charts are useful for showing trend relationships between data sets.

TIP:  You can specify any mix of bars and columns, but there must be one of each. Specifying all columns as lines works, but if you want only bars, use a bar chart. (When only bars are selected for this chart type, some column selections may be drawn as lines.)

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod 
    fb8da0c4-a7f8-49c0-83e9-d33f4d535ae4 wrote: (with screenshots if possible)

    Do you have a time machine ?

    11g has been released in 2010, so not a single chance to still have a 10g around ...

    In 11g it's an attribute in the XML of the analysis, isn't the same in 10g? If there is a way to decide what is bar and what is line (or even both lines or bars) it's there inside.

  • Jaspal D
    Jaspal D Rank 2 - Community Beginner

    Hi,

    The company is migrating to 12C next  month

    If the feature is available in 12C then I can wait to make the improvements in the dashboard then!

    I am not involved in the setup of the database and behind the scenes, I'm more focused on creating reports in Answers.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Yes, you will be able to select yourself which measure will be lines or bars.

    Capture.PNG

    fb8da0c4-a7f8-49c0-83e9-d33f4d535ae4 wrote:The company is migrating to 12C next month

    Was about time

  • Jorge Olmeda
    Jorge Olmeda Rank 5 - Community Champion

    Hello @Gianni Ceresa,

    Please, could you explain how to do that in the latest OAS version? Thanks.

    Best regards,

    Jorge

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi @Jorge Olmeda ,

    Would you mind to post a new question for this? This one has been imported from a different forum (after having been migrated across at least another forum). Pictures have been lost and it was about OBIEE 10g.

    In your question, can you also make sure to say which part of OAS you are working with: DV, "classic" analysis or Publisher.

    Thanks

This discussion has been closed.