Hi, Yyou can use your prompt to set the value of a variable that you will first define in your RPD and use that variable in your RPD column ... Do you really need the value in the RPD or you just want to have a formula in the front-end using the column formula editor in an analysis?

Hi, the style is more about a dashboard level property, so the analysis added to a dashboard page will inherit the style defined for the dashboard. This is why in the preview of the analysis you can choose the style, so you can make sure your analysis looks great based on the dashboard page where you plan to use it. You…

Hi, these are level based measures, like for example "Yearly total sales". Because they are fixed at the year level means the value will be always be the yearly total even at the quarter, month and day level. It will replicate the value of the year level at all the lower levels.

Hi, Had a look at the certification matrix? OBIEE 12c isn't certified for Windows Server 2008 R2... Instead of trying to do something that Oracle doesn't certify as "must work" why don't you use a certified OS instead? At least in case of issues you can also raise a SR and use Oracle Support.

Hi Matt, The +1 is because the prior year is last year, so "year" = @{var_year} - 1 is the same as "year" + 1 =@{var_year} (not sure how to call that in English but it's just a transformation of the "equation" doing +1 on both sides of the = ).

Hi, Yes, you can ... Did you try it? What is the issue you get with it? What did you try exactly? (screenshots are worth more than hundreds of words)

Hi, In general it's more software nowadays, the easiest solution is to use an online SMS gateway where you send an email and the content is sent by SMS or things like that ...

Hi, In a IN() you can't do calculation, so why don't you turn it the other way? "Date"."Year" IN (@{var_year}) OR "Date"."Year"+1 IN (@{var_year}) PS: if your "Date"."Year" isn't a number you must CAST it as INTEGER before to do the +1

Hi, Good that you manage to fix your issue. Can you post more details about what you had to check and fix so that other with same issue will find more details than something related to a path?

It's crazy what Google can do, and it's even crazier what the search of the forum can do .... INST:08058 A LOOKUP OF THE ADDRESS FOR THIS MACHINE And please set thread titles related to your issue / question because if everybody open a thread named "Pleaase find this" it will get difficult to find useful things on here.

Hi, You don't really do anything to allow others to help you .... So you have a picture for each customer? And you want to display it on your reports next to each customer ID and data? Where are the pictures? How is the link between a customer ID and the picture? "images are already available for all customers" is a bit…

Ok, I guess I see what you try to do and you try to do it in the wrong place .... You can't filter your data in a column formula, because the column formula isn't a filter and you have a real filter area in the criteria tab of your analysis. So first of all you must add this as a filter if you want it to work. What I…

Hi, Do you just want to filter the column based on multiple variables (multiple prompts) or do you want to do what your code was trying to do? (it's something else, a bit more precise than just what you say) "is not working" = ? What does it mean? No data? Too many data? Something else?

Hi, Obviously you have a syntax error as your CASE WHEN doesn't really mean anything ... CASE WHEN <condition> THEN <value> ELSE <value> END So what do you expect from your "table2."column" LIKE '%~ABC' as <value> after the THEN ? The <condition> can be as complex as you want using multiple columns like: "table1"."column1"…

Try at least to respect the syntax a bit .... '<a href="' || "Table name"."Column name" || '" target="_blank">this is is a URL</a>' EDIT: Christian, same reaction in the same time

Hi, First the "stupid" question ... is your Essbase process running, right?

Hi, This as already been answered at least once (this exact same need) on here ... First: why don't you use a column format instead of writing HTML in the formula? When you say "This doesn't work" what do you mean? What happen? The link doesn't work or it just doesn't open in a new window? Why don't you have anything…

It didn't change and you can have multiple DB schemas in the same data source (as long as all the schemas are from the same server / instance). Nothing new there ...

Ok, the simple way is: set open permissions on all the folders from the top shared one till the one with your analysis and on your analysis as well, in OBIEE privileges make sure your app role can access the catalog.

You say you saved few reports in a shared folder, how do you expect your users to open them? Will they open a dashboard containing the reports or do they have to go in the catalog and navigate to the folder containing the reports? Before to start setting random permissions it's better if you start by making sure you…