Agree. This is a significant issue for my customer and it is crucial that Oracle makes a statement on when the key pair capability will be available for Snowflake connections. Customer is on OAS and will need this for the RPD connection pools.

9 —- Been using OBIEE/OAC/OAS since Oracle purchased Siebel Analytics in 2005 — 20 years! — when I worked for Oracle. Went to a bootcamp in Orlando in 2006 and have been working with it continuously since then. As an independent consultant, I purchased a single license myself for BICS, the long forgotten grandfather of…

This is a requirement at a current customer.

Thanks!

Any update on the availability of passphrase credentials for OAC to Snowflake? We have multiple customers who will need this when Snowflake transitions away from password based service accounts.

Thanks! Do I get a prize for getting a request implemented? :-)

currently this missing functionality forces us to use classic obiee instead

Great to hear this is being developed. Readability and not having to modify referenced calcs would be great.

A frequently requested feature for our business users. They still like to export to Excel with repeating values.

Yes. Absolutely!

Revisiting this request again three years later... every time we deploy a data model we get the message about a virus scanner not being configured... either provide one by default or else allow for a system setting to ignore the virus scanner check

Would you expect this to be set on a subject area basis? some of our subject areas have multi hundred million row fact tables which wouldn't seem to be good candidates.

That is great if you work in an environment where you edit the RPD in online mode and deploy to production. Most of the customers I have worked for have change control processes that take days or weeks to move an RPD through development to test to prod. So the 30 minute fix to the RPD sometimes takes a week to see the…

"A hack with formula can never ever do this for you. Also, if you use code that whole logic will have to be parse for every single result row every single time you query. It's extremely inefficient and costly." Thanks for labeling my suggestion a hack. I find it amusing that using built-in OBIEE functions n a…

So what it is saying is if the date is a Friday (dayofweek value 6) then to add 3 workings days, you would add 5 to skip Sat, Sun and give the result of the next Wednesday. If it is Saturday (7) , then add 4 to skip Sunday and return Wednesday also. So Friday, Saturday, and Sunday all return Wednesday if you add 3 days.

You can probably start with a formula like this.. which adds 3 working days to a date column: case DAYOFWEEK("Dim - Period"."Start Date") when 1 then TIMESTAMPADD(SQL_TSI_DAY, 3, "Dim - Period"."Start Date") when 2 then TIMESTAMPADD(SQL_TSI_DAY, 3, "Dim - Period"."Start Date") when 3 then TIMESTAMPADD(SQL_TSI_DAY, 3, "Dim…

And I am assuming you don't need to account for holidays? Otherwise that becomes a more difficult process that would likely involve loading a table with working dates.

Can you define "working date"? For example, are you saying that adding 1 day to a date this is on a Friday, you want to skip Saturday and Sunday and return Monday's date?

Where will the data be stored? In a dataset? Probably not possible then. If it's in a database, do you have a table that maps a user id to a customer id?

Well, the starting point is the Academy link in DV. That will take you to the tutorials and documentation. There are also a lot of videos on the Oracle Analytics Youtube channel. But as someone who "grew up" on hardcopy, well-written documentation, I don't think the OAC documentation provides enough detail or enough…