Custom Radio buttons in obiee — Oracle Analytics

Oracle Analytics Cloud and Server

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

Custom Radio buttons in obiee

81
Views
14
Comments
s234
s234 Rank 3 - Community Apprentice

Hi All,

I have a graph and two radio buttons, one is Month-To-Date and another one is Year-To-Date. Based on user specific selection the graph should change in same page.

pastedImage_0.png

Thanks in advance.

«1

Comments

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi,

    you can do this with standard functionality using the column selectors or view selectors, depending on your exact requirement.

  • In addition to what Robert posted (which is the right answer) : you bought OBIEE, so at some point you do things in a OBIEE way and not what somebody put on a paper with no idea of the available tool.

    You can the same functionality but it is a drop down menu and not a radio button ...

    If you really need a radio button (like if your life is in danger if you don't deliver radio buttons), you can also use a dashboard prompt setting a variable and in the column formula you use the variable to switch between the 2 columns with a CASE WHEN.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Gianni Ceresa wrote:you bought OBIEE, so at some point you do things in a OBIEE way and not what somebody put on a paper with no idea of the available tool.

    Which kind of sums up most "requirements" nicely. It's like buying a Ferrari and then start saying "Ok but now I want it to look like a Lamborghini, make the sound of a Maserati and while we're at it microwave my food"

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    If it looks like a duck, walks like a duck and quacks like a duck it may just be an over-engineered swan...

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Only someone who has actually used the tool for years should be vetting requirements ... else there's no balance between "just do what the user asks" and "foist my will on the user".

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    I have alluded to this issue in previous posts on the forum where I expressed reservations about using jscript to deliver user requirements.

    My reasons for this as I believe leaving the user with a solution that can be supported by those with core OBIEE skills is preferable to building a solution which is essentially not OBIEE and which the end user will find expensive and time consuming to maintain and which will probably require heavy rewrites come the next upgrade.

    In the case where there is no graph type to fulfil the requirement without resorting to jscript the argument for this kind of customisation seems justifiable, if the business is willing to pay for the extra time to deliver.

    In the case where the same functionality can be achieved through subtly different use of the end user tool, as in this case, or the requirement is trivial / cosmetic then I would say the customisation is not justifiable.

    I am also a big fan of 'keep it simple stupid'...

    I am sure others will disagree with my position on this.

    Stupid not specifically aimed at anyone, though there was once a client who wanted all months to have 31 days for ago functionality.... and this was a client with a long history with OBIEE / Siebel analytics, so experience does obviously not necessarily equal wisdom.

    So it goes.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Never underestimate the genius of simple.

    ^ quote me on it! 

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Robert Angel wrote:Stupid not specifically aimed at anyone, though there was once a client who wanted all months to have 31 days for ago functionality.... and this was a client with a long history with OBIEE / Siebel analytics, so experience does obviously not necessarily equal wisdom.

    There is actually a whole data modeling subculture centered around "a year has 31 x 12 = 372 days so we can have nice AGO keys" !

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    So stupid formed a group, what else is new?!

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

    It was presented at KScope in an own slot once?