Hello Mark, in OAC 18.3.3 a partial workaround to this feature is to use Explain on any metric on your dataset. This video shows an example (watch the 50s starting at timing 2.17) https://youtu.be/WPfwtTlF6EI?t=137. Explain on Metrics is new in 18.3.3 and will help you gain most of the overall insights that used to be…

Hello John, the obfuscation logical expression is not yet available for pervasive use in calculations, but it will in the future. In the meantime, you may manually combine string functions into data prep, or a dataflow, to obtain something similar. Below in the picture is an example hope that helps Philippe

Hello Abdelrahman, DV content is saved as 'Projects' which can contain many 'Canvases' (bottom page tabs). Just to make sure I understand your question, the word 'Dashboards' is used for dashboards built in legacy OAC (formerly OBIEE and Answers, but now a large component of OAC). - DV canvases can be embedded into OAC…

There will be API to help you do this, yes, was that your question ? Philippe

not 100% sure I understand your question, but if you mean uploading data using API instead of web UI, yes there is/will very soon be the capability of doing this. Can you precise your question, is your data exclusively file based, or do you source from a database as well ? Tx Philippe

Hello Bharat, this video may help you get started https://www.youtube.com/embed/fIwmJopT8Yw?rel=0&autoplay=1 you can also use the workshop video here https://youtu.be/8DaYTlwkBmg to take you a little furhter in DV. hope this helps Philippe

Hi Rai, you can achieve this by defining a Subject Area (OAC Meatadata repository) pointing to PBCS. The Repository can connect directly to PBCS application. Not just the Essbase cubes but the PBCS app directly. This brief video describes the process to achieve this, hope it can help you : https://youtu.be/p2VdfdgwpL4 One…

Hi Abdelrahman, it seems you are trying to connect to Oracle DB right ? Is there a reason why you are not using the existing Oacle DB connection type in DV ? Tks Philippe

Hi Jonathan, even if you have only one spreadsheet, you can upload it twice as two different datasets. That's what my example was about. hope you were able to get there, let me know if not. Philippe

Hello Ofer, from reading your post, a few parameters come to my mind where to influence the way this aggregation will render. One thing you should start with : set a level (by clause) in your viz aggregation. To do this, click on your vizualization and go to properties, in 12.2.1.1 I believe this is a right click. you…

and here is the DVA file incase you can deploy directly on your environment. PWD= Admin123 Hope that helps Philippe

Second picture attached

Hello Jonathan one way to achieve this is to build a canonical time dimension. ie a time dimension that you consider as the reference, to join with other time attributes. - if your source data is into an OAC repository (Subject Area), then you can design the RPD metadata to achieve this. Its one of the modelling…

Hi Abdelrahman, just to confirm, your question was about presentation mode, right ? if your question is about filtering on 'present period' (not presentation mode), please confirm, there are techniques to do this that we can help you with. thanks Philippe

This may not relate directly, but incase it helps : a custom plugin was just posted on Oracle Analytics Library (www.oracle.com/analytics-library) that transforms value-based hierarchy data into level based tabular format. This works up to a certain level of depth but can help in such situations. Look into Extensions Tab…

Hi John, V5 does not allow yet to customize the shapes in Picto Viz. This is on the roadmap for future release but I don't have visibility on when unfortunately. A viz plugin on this can be worked out however. Let us know if you need help with this. Thanks Philipps

Hi Keerthimanu, this old video may also help a bit on the xml structure, start at timing 25s, it briefly browses over the xml structure you need : https://youtu.be/THafsaAU-xQ ignore the introduction of the video as current OAC has new UI for uploading scripts hope it helps Philippe

Hi John, ...live connections to a database source has no impact on data store quota size, even if the source tables loaded are larger than a user's quota. Is that correct? When the datasource from the DB table is set to Automatic Caching (ie not explicitly Live), then if the DB table size is below the limit of single…

Hi John the documentation here https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/adding-spreadsheets-data-sets-acubi.html#GUID-3F17CDCE-B80A-44C7-98EA-F1CEF3220A9F indicates a limit for size of uploaded files (100MB), but this only means file uploads are limited, not datasets. The size of the actual dataset,…

The error seem to indicate that your data may not have the right format. Any chances you can share a smal subset of your data (just the dates field and one column for exp) ?