Customizing legend names in OBIEE charts — Oracle Analytics

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

Customizing legend names in OBIEE charts

Received Response
201
Views
4
Comments
Helan Kumar
Helan Kumar Rank 4 - Community Specialist
edited Aug 13, 2024 5:25PM in Oracle Analytics Cloud and Server

Requirement is to show an indicator or reference symbol/line to business about the current month or the month selected from the prompt.

A vertical line or any symbol like hand on current month or selected month from prompt.

PPT screenshot

pastedImage_2.png

Achieved below after so many trail and errors but ended with too many legend names which i'm not able to remove either ways(formating/xml)

pastedImage_1.png

I don't wanted to display those legends alone rest should remain, is there a way to remove the same from XML or from formatting options ?

Chart view in edit mode

pastedImage_0.png

Or let me know if there is any option or a way or any work around to show a pointer on selected month from prompt in a chart view that would be be a great help

pastedImage_0.png

Thanks a lot,

Helan

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    What version of which tool? (you have an "oac" and an "obiee" tag, not really helpful in guessing what exact product you are talking about).

    What's behind your analysis? What column do you have in what location of the view and what's behind these columns?

    Helan Kumar wrote:Its a high priority, awaiting inputs at the earliest.

    If it's a high priority and you want a quick answer, that's what consulting companies are for. In a community forum people invest their own free time when they can/want, there can't be an expectation of "inputs at the earliest".

  • Helan Kumar
    Helan Kumar Rank 4 - Community Specialist

    Its Oracle Analytics Cloud 105.1.0-217, i believe front end reports/RPD are OBIEE even if we are in OAC so tagged both. if this not the correct way of tagging i can remove it off.

    regarding inputs, i'll take up my words. Sorry!

    its just a static number using the presentation variable i was able to move the pointer to the selected month, only question i have here is i wanted to remove those un wanted legends keeping the required ones alone. is there way to achieve with XML. i could remove names but not those symbols.

    First snapshot is a ppt, second snapshot is BI report

  • Gianni Ceresa
    Gianni Ceresa Mod

    What are all the "." columns for? It's to display the current period mark at various levels vertically and not just at 0 ?

  • Helan Kumar
    Helan Kumar Rank 4 - Community Specialist

    '.' is a column name basically and column formula is like below

    CASE WHEN "Time"."Month Num" =@{monthnum}{201905} then 105000000 END

    105000000 will change for each '.' column as i'm showing multiple indicators vertically. I'm able to remove dot from column name but not the symbol.

    pastedImage_1.png

    pastedImage_2.png