How to put a variable in a title - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

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

How to put a variable in a title

Received Response
1056
Views
22
Comments
2

Answers

  • If you expand the prompt properties in the bottom you see the option to save the value in a variable.

    A condition can simply be a CASE WHEN (if you check in the formula editor of your analysis you have the CASE WHEN example, you reference the variable by '@{variable}{default value}' .

    Now I'm not going to say that asking on the forum is a bad practice, but at some point you better have a chat with your employer because being in a role you can't manage to cover isn't really interesting both on your side as it's frustrating as en your employer side because things will not be done as expected.

    So you can definitely find yourself an OBIEE training (a class to attend) or a book or at least read the full documentation covering things.

    Plan B: get somebody knowing the tool in as for some time so you can get up to speed or in a part-time way to review what has been done and give advises.

  • John305
    John305 Rank 5 - Community Champion

    haha , i moved from consulting to another company , and they already have this solution :d ,

    i am working in a big BI project that will start during this year , but i am trying to master it before the Oracle formation ! (because its already booked l:p ) so i  just want to show them some reports before we start the work !

    Thank youuu for your advices Gianni

  • John305
    John305 Rank 5 - Community Champion

    Okay , i saved the value as a variable , and i wrote this formula . But even when i choose a value for the variable during the execution , i got nothing . it still empty

    pastedImage_0.png

  • The CASE WHEN isn't right ...

    When calling a variable the @{variable name} is the value if the variable, the following {default value} is the value in case the variable isn't set. So the variable isn't null (because checking nulls doesn't always work...

    CASE WHEN '@{Nomenclature}{##XX##Impossible-Value##XX##}' not like '##XX##Impossible-Value##XX##' THEN "D05 - Nomenclature douaniere"."Parent nomenclature douanière" ELSE '' END

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

    You booked directly with Oracle University? When and where? I might be the trainer :-P

  • Oh no ...

    I would be tempted to suggest to cancel and rebook with another guy ... I know one who can do it (and I actually also already delivered OBIEE training in French, was a weird feeling )

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

    Muppet

  • John305
    John305 Rank 5 - Community Champion

    Thank you gianni it works , you are the best ! ( dont worry i am a fast learner )

  • John305
    John305 Rank 5 - Community Champion

    I am in morocco now, i booked with "OmniAcademy" its a learning center in Casablanca , its an oracle partner. we did the ODI part , now we just need to complete it with OBIEE.

    http://www.omniacademy.ma/

    But i am sure it will be better if one of you (or both ) can give us the formation .

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

    Ah ok I thought OU since you said "the Oracle formation". Then it won't be me.