Ok, with no access to MOS the option you have is to create the data yourself. In the end it's all around dates, so using a normal query and the functions Oracle provides to work with dates (to_char etc.) you can generate the same kind of data, it will maybe takes you half an hour but you can do it column after column. As a…

Hi, Do you have access to MOS ? If yes you can download it from there, if no then nobody can post it as it would be illegal ... If you have access to MOS, 1034454 posted the links few answers ago.

Hi, As OBIEE already generate queries using WITH when the code of your view will be injected into the generated query it makes an invalid SQL. What OBIEE does is it takes the code of your view and put it in its own query as a subquery, so it's why the WITH doesn't work. I don't really think it can works because of the way…

Hi, Did you try ... Google? For example just one of the first results: http://stackoverflow.com/questions/3847745/systrace-for-windows

Use the Catalog Manager to find the agent (the file defining it) and there you can see the source of the file, the XML code. There is also probably a webservice to get it, but can't remember right now ....

Mmmhhh, your original solution wasn't in OBIEE but was at the database level (as said EVALUATE and EVALUATE_AGGR bypass the logical SQL layer in OBIEE and is sent to your physical database). So you must solve it "at the database level" to get the right syntax you can then use in OBIEE ....

Hi, LISTAGG is an Oracle DB function, and when you use EVALUATE or EVALUATE_AGGR you are bypassing the OBIEE logical SQL layer and OBIEE will send your piece of code directly to your physical database, so it's up to you to make sure you are going to use a piece of code in these 2 functions that your DB can understand (so…

Recipients, named users or manually entered emails, aren't in S_NQ_JOB_PARAM at least on 11.1.1.7, and the OP don't really say which version he is talking about. But they are coded in the XML of the agent itself, so not really the best place where to get them, but still better than, like Christian says, if based on a…

Hi, That's something you better manage at a webserver/proxy level in front of OBIEE. Weblogic is an app server and can probably also manage that in a way or another but it will probably not be really easy, so doing that in a web server in front of OBIEE is the better place. Not sure how your IIS is setup but maybe you…

It's important to note that you can't get 11.1.1.9 in Windows 32bit as the support for the 32bit has been dropped. So for the OBIEE install on a Windows 32bit you must stay on the older 11.1.1.7.

Which version of OBIEE (11.1.1.x ... x can be 4 different numbers) are you trying to download and for which OS exactly? (32bits doesn't mean anything in the end without the OS ...)

Hi, Can't you just enable "Limit values by" and let OBIEE care about it? If the both come from the same table (you say presentation but I guess it's also the same logical table) OBIEE will filter the list of fiscal periods based on the value selected in the fiscal year prompt.

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) ....