There probably exist other ways to do this (not sure) but one that comes to my mind is using a prompt to set a presentation variable (vanilla option in the prompt definition) : your prompt has two text choices for the user : include or exclude. These choices get passed on by the prompt to a pres variable 'PX' that you…

Also, if you are planning to use Count(*) with breakdowns analysis, I recommend you add an extra column in your dataset (prepare tab) with a dummy 1 value column, and sum it. Just prudent practice. Philippe

Robert, it's likely that a sorting may be the issue here. Can you please try this and confirm : run the same report, but without body-part in rows. Confirm the MSUM november value is correct in this case. Then, filter for a single body part, and confirm that the msum is working fine as well. This is not yet the answer to…

Second screenshot

Hi Robert, yes, it's pretty easy to export and exchange projects via dva files, between OAC environments, from desktop to OAC or vice versa, with or without including data, etc. You can export DVA files from within the project or from the OAC project page, see the two screenshots below. let me know if not your question…

Hello Data Viz in Answers (OBIEE), when designing dashboards prompts you have the option to let the end-user choose the operator. See attached picture. That shows the prompt with two fields, one to let the user pick the operator he wants, another with the member values to pick from like regular prompts. hope this helps…

Hi Robert, DV Desktop is meant to have similar features as DV so the first answer to your question is no, nothing different. Technically this is very largely true, but some web/destkop constraints create slight feature differences : - some limitations : some collaboration features, security features are obviously different…

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…