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

You can look at the queries generated in the logs as it will contains both the logical query and the physical one, so there you see exactly what values are used instead of "is prompted". It isn't in javascript as logs are in log files, but still give you a good idea. I guess there is still a view in the analysis which also…

If you remove the "Period" columns which are useless you can with a table view. Sales TY, Rank TY, Sales LY, Rank LY and Variance will be measure columns. You don't need a pivot table but a simple table. You use AGO or FILTER to get the last year values and use those values in the calculation of both the RANK and Variance.…

Hi, You have an OBIEE analysis, right? (And not a BI Publisher report: analysis = OBIEE Answers, report = BI Publisher) You can do what you look for by creating an agent, select the analysis you want to deliver, select the users to whom you want to send the analysis and you set the agent to be run as recipient. By…

The same way you did the backup, there is an unarchive command. EDIT: apparently Christian already finished his sausage and so he is quicker in replying

The number of rows exported in Excel is defined by a system wide setting, so this one can't be user based. The Excel export will contains not more than the export limits defined in the system, but not more than the rows the users is allowed to query. So if you limit rows on the users that limit will apply both to the…

And, by the way, 3d bar charts? Really? I imagine it isn't your personal choice but more a requirement, but still ... time to tell the manager asking it that we are in 2018 and a "flat" 2d bar is as good (and better) than a 3d bar chart What about just not showing any value in the bars and add a small pivot right below the…

Hi, You can't change the Y-axis labels to actual values, just because you would need an axis for each bar .... Look at the first 2: the blue part of the first is 349K, but it is bigger than the blue of the second which is 400K. So there is no way that your Y-axis could be something else than a % as 349K can't be bigger…

3051139 wrote:He has bi-consumer role. This doesn't mean anything as the security model is totally flexible and your bi-consumer role can be everything or nothing based on your setup.