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

Custom column with a filter that selects a single row

Received Response
63
Views
19
Comments
2»

Answers

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

    Love it :-D

    In the other thread the final statement was "not possible without having the proper tools, rights and setups". @Wolfrm no offense but if someone hands me a car where I don't have the right to turn on the engine I can't fulfill the "business requirement" of "win a formula 1 race".

  • Wolfrm
    Wolfrm Rank 4 - Community Specialist

    Sure, that is all true, but it's not in my hands to change right now. I do appreciate your help and working with me within the limitations I have though.

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

    "working within the limitations" - I point you to the other thread where several options were discussed. If none of those work...tough luck as at some point there is simply no other feasible way anymore. It's technology, not magic. We can't invent new ways of doing things out of thin air.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    You are struggling with the roof of the house ... I'm telling you it doesn't fit because of the lack of a foundation. 

  • Wolfrm
    Wolfrm Rank 4 - Community Specialist

    I really don't understand what the purpose of your posts is, Christian and Berg. I would understand if you posted once to point out this should be fixed elsewhere, but continuing about it in this way doesn't serve any purpose that I can see. I already explained my permissions don't allow me to do much beyond custom columns. What is it that you are trying to accomplish by insisting this is the wrong way? Should I just quit doing my job or what else is the goal of your posts?

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Hi @Wolfrm

    Christian and others are just trying to help you the best they can with the experience they have with Oracle-BI. Don't feel offended if they say you are doing it wrong. Maybe something needs to change in your job or the way your client is organized to get better working solutions.

    On-Topic:

    Michael

  • Wolfrm
    Wolfrm Rank 4 - Community Specialist

    Thanks, Michael. I marked your answer as correct. I had to change the code a little bit, bit worked out in the end. The cool thing about it is that I was then able to also combine multiple rows by doing this:

    min(case when rank("ADDRESS_FIELD) = 1 then "ADDRESS_FIELD" end by "USERNAME")||min(case when rank("ADDRESS_FIELD) = 2 then "ADDRESS_FIELD" end by "USERNAME")||min(case when rank("ADDRESS_FIELD) = 3 then "ADDRESS_FIELD" end by "USERNAME")

    So you actually solved more than I was asking for

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

    @Michael Verzijl was nice enough to already say the most but here goes:

    1.) I continued to say this because if some one asks you to do something but doesn't give you the tools or rights necessary to do the job and all the options we offer you aren't sufficient or impossible due to the mentioned lack of tools and rights...well.

    2.) If your organization/company/setup invalidates all approaches mentioned here then neither the product (OBI) nor our inputs are at fault.

    3.) When I say "your" I don't mean "you" person but as in "the place/structure you work in / the organization / whatever". Believe me we all know way too well just how much damage unadapted rules, policies and tool restrictions can do.

    4.) Taking all the points above together you can

    a) not expect 10 new solutions which we come up with within your limitations when all which normally works or is done in such a situation is impossible due to local (I didn't say "your") rules and setups

    b) not blame us for not coming up with more

    c) also not really blame us for saying out loud that the local rules and setups are at fault for our suggestions not working

    Granted we do this stuff pretty much 24/7 and so probably come to these conclusions immediately when reading about 5 posts of a thread and it isn't as obvious for many others but still.

    We're in here to help.

    In your setup it's not possible to use:

    - EVALUATE

    - a push-back into a DB view

    - any other DB push-back

    - opaque views

    - any other DB- or RPD-based leverage of windowing functions

    You marked Michael's response as correct although that's pretty much just a front-end hack / trick which will work for some very restricted cases. Like knowing precisely how many (a fixed number) children should appear etc and doesn't cover the case of an unknown number (N) of children.

    So happy that Michael's approach worked for you I'm just pointing out the flaws compared to all other "proper" options (proper for lack of a better word) and I know that Michael will fully agree with this assessment.

  • Wolfrm
    Wolfrm Rank 4 - Community Specialist

    Thanks for the clarification, Michael. I just want to add that when I post here, I don't 'expect' anyone to help me. I post in the hope that one of you more knowledgeable folks will be kind enough to offer advice - and I am truly grateful that some of you do.

    I do not believe that I have blamed anyone for anything here, as this isn't the attitude that I have brought to this forum, and certainly not the attitude that I carry in general.

    It's true that the hack that I ended up using is frankly preposterous but this works for me and perhaps someone else, who is in a situation similar to mine, will find it helpful. This is certainly the only place where I have seen combining multiple rows done like this, and it is the only solution that works given the limitations. Thanks again for everyone's help and advice, and apologies if I have stepped on any toes. This certainly was not my intention.