Hi, I guess Thomas answer is related to this : 5856e31e-0817-4b2f-8e87-b60e7d87d636 wrote:... to be able to tell to the CRM to select... So what is that thing with a CRM? Do you want that filter in an analysis in OBIEE or are you trying to do something else?

Yeah, but OBIEE use a direct OCI connection (a lot better than JDBC) ... Did you try googling on how you are supposed to configure an OCI connection to be SSL? Right now I can't remember I saw somewhere all the data connections in SSL, so can't point you directly to a doc link for that. But as you can set OBIEE to be fully…

But no I'm not his assistant or secretary

Yes, to keep it "clean" and maintenable you must create as many app roles as you have of different kind of access requirements. The good thing is that you can create as many roles as you want .... It's actually normal to have many app roles, even more in a case like your with non-additive security rules. Just imagine that…

Are you sure it's as simple as just putting a "s" in your protocol (and changing the port) ? Don't you have to define anything else to make it work? I guess to secure a JDBC connection you also need some settings as system properties or JSBC connection properties, so you maybe need some extra pieces to connect using OCI as…

How SSL can make it on port 80 of a different domain name of the one they installed? I also don't think the default SSL setup for OBIEE is on port 443 but probably something else again, so the issue on that part is still there. And SSL will not help you at all because if your OBIEE expect connections for ABC.comcast.com…

In addition to what Christian said ... It looks like the perfect case for the "My Dashboard" page .... You say that each users has access only to the reports he created. So you don't have anything shared here, nobody has access to all the reports. So why each users don't just add his reports to his "My Dashboard" page? The…

OBIEE 11.1.1.7 is based on Weblogic 10.3.5 You have to update to 10.3.6 if you wanted a supported (per the certification matrix) using Oracle 12c as system DB.

Actually the question is not if OBIEE 12c can do it but more to know if Fusion Cloud GL Essbase cube really act like a "LAN" cube. So are the same services and protocols available? (I assume there is probably a VPN and your cloud cube isn't exposed like that to everyone ....) So if you can connect by command line from your…

And you can also edit the horizontal axis labels to be vertical for your weeks ... (But I'm not going to screenshot a screenshot of a screenshot for that ... just wanted to bother a bit Christian and Andrew )

Too slow Christian Still discovering places for dinner?

Hi Robert, You can manage the case as the presentation variable has a value if "all records" is selected (can't remember exactly if it's "all values" or something else, just display its value and you get it). So by adding a piece of logic you can end up with something like : 1 = 1 (if all values selected) or your condition…

Have a look at the option Andrew posted, it's a good combination with a prompt to set the values faster .... And just open a new thread for your future coming questions

Ok, that's a lot more clear So, the answer is now: sorry, no, the tool doesn't provide that functionality ... You can of course ask Oracle to develop that kind of feature if you want. The options you can try are prompts and use the "is prompted" as Christian posted. If you add it as an inline prompt you will be asked for…

Hi, Take the last backup you did of your catalog and restore the folder by copying it back (also take the .atr file with the same name as the folder located just next to it). If you don't have backups .... why? I guess this is a good motivation to invest 2h of time to setup daily / weekly backups of your OBIEE environment.

Hi, Perm77 wrote:...when creating Analysis from Subject Areas, I like to design one report to serve many purposes. ...one was able to check and uncheck multiple conditions and save in report. For the first one I would just say it can go badly if you end up with a single analysis with 40 columns and trying to make it all…

% is the modulo operation, if you look in the formula editor into the math functions area you find the "mod" function doing the same ... TIMESTAMPADD(SQL_TSI_DAY, MOD(DAYOFWEEK("Time"."T00 Calendar Date"), 7) * -1,"Time"."T00 Calendar Date") DAYOFWEEK return you the day number in the week (1= Sunday, 7 = Saturday). If it…

Hi, Did you try to do it by yourself? Because the post you link give most of the things you will need ... Based on your example, assuming you want to calculate value of Column B based on value of Column A you are looking to get the date of the last Saturday before the date (or the date itself if it's a Saturday).

Well, if you don't change the analysis itself, you don't change OBIEE version and the query change then there aren't 10 places where to look for... 525401 wrote:....I don't believe they changed anything major. ... Never supposed that, mainly if you aren't part of the dev team doing the job Many things can change the way a…

Just to add that the RPD is interesting but the front-end elements are also extremely helpful, many analysis and pieces of code you can just copy/paste. Sample App must be mandatory to have for any OBIEE developer ... And .... it's free!