Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to put a variable in a title
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.
0 -
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
0 -
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
0 -
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
0 -
You booked directly with Oracle University? When and where? I might be the trainer :-P
0 -
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 )
0 -
Muppet
0 -
Thank you gianni it works , you are the best ! ( dont worry i am a fast learner )
0 -
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.
But i am sure it will be better if one of you (or both ) can give us the formation .
0 -
Ah ok I thought OU since you said "the Oracle formation". Then it won't be me.
0