Hi, In your screenshot I see authenticated-role is member of your HR_SAL_ROLE, is it the same for your other "consumer" roles? Because "authenticated-role" represent every single user with a values login/password, so if your other "consumer" roles are similar to your HR_SAL_ROLE having authenticated-role as member ...…

ae6888f0-bbbc-49f3-ba0b-8a06d5f6301f wrote: should be able to find "Hudson square 5", if they enter "hudson 5" or "5 hudson".For this I would need to take the value from the STREET variable, split it into several parts, and then run several OR filters with the various combinations, I think. Hi, This one isn't really…

If you read the answers to the thread you find it! An OBIEE formula giving you the fiscal year start from any given date is posted on the 6th answer... And again: it's all about math how to get it, not really an OBIEE issue as the tool gives you the functions to add/subtract periods to a date etc.

Well, I'm sure the Oracle doc (or even just Google) have the answer for that... In any case there are many Database forums next to this one focused on OBIEE where you can for sure have all the answers on how to upgrade your database. For the relation with OBIEE as said it's all about how do you plan your upgrade...

So, summarizing what Thomas And Joel are saying : adapt your time dimensions by adding the fiscal year informations and then model an alternate hierarchy in your OBIEE for the fiscal year and ... done ! Just use the standard OBIEE aggregations and time series functions

OBIEE 11g to 12c is an out of place upgrade, so you have to install OBIEE 12c from scratch and at some point you will be able to migrate your content. The documentation cover that. For your DB upgrade you can decide when you do it: upgrade the DB on your current OBIEE 11g and once done start the OBIEE 12c upgrade? Keep…

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?