Hi, Yes it's possible ... As you are trying to do it just go till the end and you will see it working (If you can't get it working you will need to post details on what you did and how you did it to have a "real" answer)

+1'000'000 for what Christian said Kalpana: do you mean you want to remove the view selector from your analysis and just keep the view itself? Drop the "view selector" view and place the correct view where you want it ...

That's actually the simple solution Can you maybe close the thread? Right now it's still This question is Not Answered.

What you do? You install a Windows XP - 7 virtual machine and you install the 11.1.1.7 client into the vm. Read the certification matrix, the 11.1.1.7 client tool isn't certified for Windows 8, 8.1 and 10, it stops at 7. Some were able to install it on Windows 8 but it then took like 1h to open and didn't really work ...…

In case come back here and open a thread for the AD issues, in 11.1.1.7 it generally works fine (assuming your AD has a structure at least a bit OBIEE-friendly)

Why do you want to make something complicated when the simple solution exists? It's how Christian said: you are setting a default value in your prompt or your analysis and you are doing it in the wrong way. Check what are you setting and where and fix it, using the right format. If you say that by applying the prompts…

Hi, Gianni Ceresa wrote:....nothing exist, so it's up to you code that... The answer is still the same: nothing exists and it's up to you to code everything by hand if you really want it. So if you aren't comfortable with customizing OBIEE, writing JS and are not ready to manage that in the future (at each update / upgrade…

Hi, Never heard of such kind of settings and the system is done in a way to allow to save as many customization as you want. So out of the box I don't think there is a setting for that. You can maybe think about something done in javascript if you really really (but really) want to limit that to 5 ... (nothing exist, so…

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.