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…

I'm totally with you on this Robert! Security being made by humans I would anyway adopt a multi-layer approach: protect everything at the best. DB accounts used by OBIEE are without content (so just the accounts) and are granted read only access to the required objects (ideally table/view level, worst case schema level if…

Conditional formatting do not apply to grand total, so if you wanted to format the total itself it will not work. If you want to apply conditional formatting on the detail (not total values) based on the value of the total you can do it by calculating in a hidden column a "flag" value (1/0, true/false) using formulas to…

Hi, What version of OBIEE are you talking about? Assuming you talk about an OBIEE analysis and not a BI Publisher report, right?

Yes, on this one you are just a pain ... EVALUTE functions are disabled by default and need to be enabled explicitly in your OBIEE BI Server config file I wrote the same in the end And still didn't find a single OBIEE where the NQSconfig.ini edited itself enabling EVALUATE without a human interaction, therefor PEBCAK is…

RosyCross wrote:Is it possible to attack the databases that OBIEE is connected to via sql injection attacks? Not by default ... EVALUTE functions are disabled by default and need to be enabled explicitly in your OBIEE BI Server config file. Add this on top of the fact that your user need the required privileges to use it…