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

LOWER

Received Response
231
Views
28
Comments
2

Answers

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

    Can't agree more with Gianni!

    a) That search spec makes no sense. The easiest way to verify this is: Try saying it out aloud as a sentence when sitting in front of it. Literally. If that sentence doesn't make sense, then the search spec doesn't make any sense.

    b) You're standing at the very first, very simplest step of your journey into the world of analytics it seems. You will have reporting, dashboarding, analytics and then Data Science, Machine Learning and AI ahead of you. They are all part of the same family and all build on the same principles.

    Yes, even AI and Machine Learning require an understanding of what a search specification is in order to constrain the data you're working with.

    Understanding and comprehending the basics is crucial. Not merely "essential". In German there's the word "verschlimmbessern" which means "making things worse by trying to make them better". You're going at it with good intentions, but are penalized with bad outcomes (and bad numbers and bad performance and bad acceptance and bad user experience).

    Think about it this way for a positive spin on it: In order to enjoy flying a jet you first need to understand the basics of flying and then prove you understood it by flying a Cesna :)

  • User_I0GH4
    User_I0GH4 Rank 3 - Community Apprentice

    Thank you very much for your answer


    I followed Jerry's steps again.

    I changed the filter to:

    UPPER('@{varNameSearch}{smith}') = UPPER("Review".."Review Title")


    What is the meaning of smith? I get an error.





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


    Took longer to screenshot than to build :)

  • Gianni Ceresa
    Gianni Ceresa Mod

    What is the meaning of smith? I get an error.

    It is a default value if the variable isn't set. If the variable isn't set, your condition would be an error because the value will be missing. "smith" will be used in this case instead of the variable. You don't have to use "smith", you should use a value that you are sure it will never ever exist as a real value, because this will return no data (the message you get for now) but the analysis will not give an error.

  • User_I0GH4
    User_I0GH4 Rank 3 - Community Apprentice 
    I did a search with the word health

However, there are review titles that have the word Health and it gives me an error
What did I do wrong?
I followed all the steps


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

    Why is there a blank space after the @ in your formula?

    Did you look at my screenshots?

  • User_I0GH4
    User_I0GH4 Rank 3 - Community Apprentice 
    I removed the space and it works.

But it only takes reviews with the title Furniture. If there are any that have Furniture and other words in the title, he doesn't take them.

Can research get us a list of everyone who has the furniture?



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

    UPPER("Products"."P4 Brand") like UPPER('%@{vText}{fUnPoD}%')



  • User_I0GH4
    User_I0GH4 Rank 3 - Community Apprentice 
    Perfect, it works.

If we put a word with an accent (example: é), it displays the results with the words only with the accent.
Is there a way it doesn't distinguish between accents?


  • User_I0GH4
    User_I0GH4 Rank 3 - Community Apprentice 
    I have a question

If a user writes two words, is it possible for the search to find both words regardless of their order in the title?