Yeah, that's what happened with 11.1.1.7 as well, there were few "exotic" version number around but the patchs were not public, so they probably just forgot to set security on it

Hi, The one in the doc must be a typo as it's the only one referencing 12.2.1.2.0 and it's linked as the doc for 12.2.1.1.0, so just probably a typo. For the patch can also be a typo or also a special kind of patch (looking at patching and some other documents there were references to unexisting version of 11.1.1.7 etc. so…

Well, of course there is a formula to get it ... It's all about math! A possible way to do it: to_datetime('01/10/'||CAST(YEAR("Time"."T00 Calendar Date") + CASE WHEN MONTH("Time"."T00 Calendar Date") < 10 THEN -1 ELSE 0 END as VARCHAR(4)), 'dd/mm/yyyy') You can of course also use TIMESTAMPADD to go back to the first day…

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…