If you run the physical SQL (which looks good so it's already a good point), you also don't have any data (I hope), but do you see what makes the query to not return any data? Maybe you just don't have data for 2016? (or not for that combination of filters and columns?)

Can you maybe close the thread to not leave it open forever? Right now it's still This question is Not Answered.

I first thought it was because of a wrong syntax, OBIEE substring is SUBSTRING(value FROM beginning FRO length) but it looks like the syntax with with (value, from, length) works as well ... Is your Fiscal year a string? Do you have no data or an error? How does the physical generated query looks like? (does it makes…

Hi, So in your analysis the measures columns are empty? Does your cube contain any data? Does the point of view you are looking at have some data? Often the data in Essbase are "somewhere" else than the place you look at, so double check the point of view, test it with SmartView maybe if you can so you can be sure of what…

Ok, so for that kind of customization of course you can ... You create a dashboard which will be your own customized homepage, and then configure OBIEE so that users are sent to that dashboard after login instead of the default home page. The OBIEE home page (which isn't a dashboard) can't be customized ...

Hi, What do you define "OBIEE 12c home page"? What do you mean by "customize"? In the meantime look at what @rmoff posted ...

Hi, What do you see in the logs of the agents? In general you find messages related to SMTP issues there ...

More in general ... any search engine (Google, Bing or anything else) ....

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…