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…

Isn't the system working correctly? You get an error telling you that there was an issue. "an attacker" : this attacker is working in your company, has a valid login and password and permissions to access the system and do things. In that case he will probably uses his access to get valuable data out of the system instead…

First of all, for your case I would still use a real filter to not retrieve from the database all the "machine" for nothing as you will always display them one by one. So using a dashboard prompt with a real filter would solve all your issues and give you a faster analysis. If you want to do master-detail the order in…

Hi, Sure ... as long as you then keep the data in javascript and do some javascript rendering (either JET or D3js or any other JS graphing library or just simple HTML rendering). Once you got the data out from OBIEE into your javascript code you can't send it back into OBIEE for "normal" usage. If you want your data back…

Hi, I don't have a 11.1.1.9 available to try, but the chart inside the pivot table view is quite limited in options. All the things you look for can be achieved with independent views where you have all the settings available. For example using master-detail linking you can change the filter on the chart based on the…

Hi, Isn't it a permission issue in your DB? Are you sure the user you use to connect to the DB is allowed to see the view and use it? You also can create the view yourself by hand in the physical layer directly, it will just be a bit annoying as you will have to create all the columns and set their types accordingly to…

Hi Marco, If you connected to Active Directory to source users (so the users enter their username/password matching Active Directory in OBIEE) this isn't SSO. SSO would mean that users are automatically authenticated thanks to their Windows session or other ways. So in your case you just setup an external provider (AD) to…

Hi, Did you try searching on here in the forum and Google as well? Because this question come at least twice a week, and the answers are always the same ... I'm also quite sure MOS has a document or two about this.

If not wrong they still allowed the old config to work in 11g, that's why your system still works and you can login. But that way of doing things is deprecated even if still there, so you better cleanup your RPD, remove the LDAP from there and do a proper config in Weblogic instead. Users will not see any difference. You…

Being pedant Mr. Berg isn't exactly an English native But details

Avinash Pentyala wrote:I have tried as below in edit formula but not working, troughing a syntax error MAX(Value) KEEP ( DENSE_RANK LAST ORDER BY QTR) Did you read what as been posted above? Where did you see something like the formula you tried? The formula isn't SQL, it isn't something you are writing for your database,…

Is Null really NULL or it's no value at all? Aggregating using LAST (not SUM etc. but LAST) and assuming your NULL is no value you will get your values.

Hi Camilo, Usage tracking will not really give you the number of logins. You can of course define what you consider a new login (when time between 2 executions is over 10-15 minutes for example), but it's just an estimate of the number of logins. For a real official count you would need to parse log files which contains…

I guess it can be a great experience even just attending. For people based in US it's easier to attend than for us from Europe

The user group / meetups Christian posted is the more local one. If you have some budget which can be invested into "training" (attending a conference count as highly intensive training) it's also worth to try to get approval for Kscope. Still US but moving around the country every year (next one is in Seattle in June…

Hi Alex, Honestly I'm not aware of an API / webservice giving you the same as the Admin Tool. And because the Admin Tool goes via ODBC it's encrypted with a custom protocol and never managed to "look" inside to see what it's calling to get the info