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.

Your users are allowed to use their "my folder" ? Because that's where the favorites are stored, so they need to be able to save in it.

When you do an upgrade, once the domain is "linked" to the new version the old home become useless, nothing is used anymore there as the new home is the one providing all the binaries etc. Luckily you adopted the right folder structure moving the domain outside the original home, which allow you to keep updating without…

If you just call datamodel.cmd with -H you still see the " -D " listed? The doc ... is maybe not really up to date

I saw that once or twice, but it was a while ago and I guess I also just had it as some "caching" side effect. So all is good. If not wrong I guess that doing those operations directly with Catalog Manager doesn't generate the issue as you don't get the cache in the browser.

Hi, Isn't it some caching / ghosting issue? Like if you logout, clear the cache and temp files of your browser and login you still see the 2 "copies" of the folde?

Yeah, it's more a lack of trust in the human beings doing the setup

Ram, you forgot the most critical information ... what version of OBIEE? (exact version, including bundle patch) If you have conditions to display and hide sections of your dashboard page the hidden analysis aren't executed. Are you sure that all the 6 are really executed and it isn't just the 6 analysis used by the…