"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…

See screenshot. First, I changed the Canvas Properties to Freeform so I could re-size and move the visualizations. Then I went to the visualization panel on the left and brought in a text box (twice). Moved them where I wanted to and then added the text with formatting.

Can you be a little more specific about the type / placement of the description? Maybe a sample screen mockup of what your ideal solution would look like?

Agree it would be an attribute except in the specific case Christian mentioned. I would wonder why you would need to expose the column at all in a data set, especially one that might be shared with other less savvy users.

Or, in hindsight, imagine if they had just made obiee do some of the things DV does and make it work in the cloud?

No problem. I wish OAC would remove Open Classic Home as the dropdown choice in DV for what should be called OAC OBIEE. Didn't think it was possible. Will add it to the list of missing "features" in Oracle managed.

This is Oracle Managed OAC... 

If the custom table is referenced by an init block and that custom table is in an on-premise database, then the physical connection used by the init block will need to have the proper Remote Data Connector configuration referencing the Java Data Source in your on-premise Weblogic Server. If the init block is just accessing…

Is this similar to what you are looking for? I created a calculation called RankCnt with a formula of RANK(SUM(Person Count By Assignment Status)) Then I dragged that calculation down into the filter area on the visualization, not to the filter bar. Then in the visualization, set the limit from 1 to 10.

Thanks. The Explain option has a lot of limitations. The simplicity of the Data Tiles was its best feature especially for data profiling. I'm baffled why it would be taken away.

When features like this are removed from the product, there at least should be some mention of it in the What's New section of the documentation. I can't find any mention of it.

This is on OAC, not DV Desktop. It works fine on DV Desktop. I believe the ML and Python components are pre-installed in OAC BI Service.

It is basically unusable with the limited screen resolution, right? There should be some way to control the font size so all of the panels are visible.

Yes, but that doesn't explain why it happens in the first place. What is causing numeric values to become text? No reason for that.