Customizing legend names in OBIEE charts

Helan Kumar · Jun 28, 2019 7:44AM

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

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)

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

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

Thanks a lot,

Helan

Gianni Ceresa · Jun 28, 2019 8:05AM

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 · Jun 28, 2019 8:29AM

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 · Jun 28, 2019 10:47AM

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 · Jun 28, 2019 11:18AM

'.' 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.

Oracle Analytics Cloud and Server

Categories

Customizing legend names in OBIEE charts

Answers