Customizing legend names in OBIEE charts

Question

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

Helan Kumar · Answer

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

Gianni Ceresa · Answer

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 · Answer

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