In 12c there is a checkbox at the dashboard page level which tell the system the page will not load the analysis till the prompt aren't submit. So just check that checkbox and put the analysis in the same page as the prompt and it's done!

Hi, I'm quite sure in 11g there is a javascript file where you can write validation for prompts etc. I just can't get my hands on it anymore (I guess I saw it in a blog post), so can't give you any valid link or hint right now. But there was something like that in 11g and let's be optimistic the same (or similar) will…

Not helping you Gerd, but the title of the thread is priceless I was curious to find out what the "WTF theme" was

3612030 wrote:Back in to my question then - I didnt find any examples of how to use AGO function in combination with dynamic variable of Quarter. That is why Im just asking for any code example, I could handle myself from that point. AGO couldn't care less about your variable quarter You use your variable to filter in the…

3612030 wrote:Robert - again didnt worked, still no results. For example, using your suggestion about AGO function, this didnt work for me because of "Unresolved level" error - AGO("Historical Pipeline Facts"."Closed Opportunity Revenue", "@{QUARTER}", 1)In fact everything that I include in this function throws me this…

With an action of type "navigate to a web page", the action options provided (defining the name, the default value etc.) work for the query part of the URL, so yes: changing your service to understand a url like jersey?year=2009 would work. You can try it directly yourself: add a parameter and try to save: OBIEE doesn't…

Well, in actions parameters when navigating to URL are accepted only as part of the query part of the URL, which means after a ? . In your case you want to use it to build the URL itself, this is where the action will not allow you to use the parameter as currently implemented. So, depending on the final usage of your…

Where is this action set? Where does the year come from? You mean you have that in an analysis which also contains the year column? You want to use a presentation variable? (I maybe missed the details but it's easier if you give the whole context )

Hi, The download you are expecting from your call is in the browser itself? Because I have the impression you expect something which isn't supposed to happen ... I imagine you used a "invoke an HTTP request" action, right? This one is supposed to execute the call in the background as most webservices are supposed to be…

aPsikus wrote:Top page exists as single object, that's true. And you can't rename it. You can only change label in dashboard setup, but it will not change name in catalog for this page. Not really right ... Top pages exists as single objects in the catalog only when they don't have any subpage. They are just normal pages…

aPsikus wrote:All the pages exists as a dashboard page (except this automatically created). You can check in Catalog. Sorry but no, it's not like that, and if you check in Catalog Manager you see that it isn't like that. As I said the "top page" isn't a page, as soon as you have subpages it is just a label. The page which…

Not sure how you try to do things, but apparently you aren't doing it right .... Subpages have independent names, by default it's named as the "top" page it comes from, but you can freely rename it as the "top page" is just a label and don't exist as page itself.

Your solution is just what I wrote ... Never mentioned any ETL, OBIEE is about modelling and all the things I talked about where in BMM layer: pure modelling things. PS: as it isn't Publisher the name is "analysis", so call it analysis or people will keep thinking you talk about a BI Publisher report (OBIEE Answer =…

Hi, First you need to fix a problem: your fact tables are for facts, not attributes. I'm quite sure "run_error" is not a fact but an attribute, so model it as it's supposed to be, as a dimension and not a fact table column. Once you did that set the content level correctly and your analysis (in OBIEE Answers it's called…

You can also have a look at Job Manager (installed with the Admin tool) if you prefer to not have to find things in the tables.

Hi, If the admin want to know who received the email it isn't by being in CC that he will knows. Receiving the CC copy doesn't mean the mail server lost the copy for the real user. So for that kind of "analysis", getting a list of people receiving it, you maybe want to look at the jobs logs as they will list the receivers.

Hi, It's probably an issue with the font (not all fonts have the EUR symbol). Have a look at https://support.oracle.com/epmos/faces/DocContentDisplay?id=2097276.1

Hi, You took "all column values" a bit too literally ... Look at the query your analysis execute, you will see it doesn't contain a WHERE yourColumn IN ( the list of all the values ). It doesn't work nor mean that. You will need a different logical approach for the filter you look for. Add the filter of 2 years in the past…

I was hoping the Java client generated from the WSDL would give me the direct answer, but it doesn't (it even lack a method to set it ). Then I remembered the doc gives extra hints and not just a structure for this parameter : https://docs.oracle.com/middleware/1221/biee/BIEIT/structures.htm#i1019665 Look at "Table 2-73…

What did you try so far? I generally used executeSQLQuery as it gave me more options, while the executeXMLQuery is "like" when you run an analysis on screen, so the filters depends on the filters you defined in the analysis itself (as the doc says).