Hi @User_F707D , To downgrade the RPD you can use the nqgenoldverrpd.exe utility of the Model Administration Tool: nqgenoldverrpd.exe -P RepositoryPassword -I PathToInputRepository -O PathToOutputRepository -V DesiredVersionNumber The utility can be found in the following location: %OA_CLIENT_HOME%\domains\bi\bitools\bin

Hi @User_F707D , BVT is not supposed to work against OAS 2023. Moreover, according to Doc ID 2831659.1 it has been deprecated, removed from the download sites and is no longer supported.

Hi @Harriet Huang-Oracle , You could apply the ATTRIBUTE function to your calculated measure to treat it as an attribute (in this way Oracle Analytics will not calculate a grand total for it). The syntax is as follows: ATTRIBUTE(YourMeasure BY YourAttribute1, YourAttribute2, etc.) It's fundamental to include all the…

Hi @Raluca Balan-Oracle , Are you sure that you are using exactly the same expression for the filter? It could be that in your analysis the column has a different/custom expression, but the same name/header as another column. However, I would transform 'Doe,John' to 'John Doe' as follows (assuming that there is only 1…

Hi @User_JGSZC , Please refer to this page: https://www.oracle.com/middleware/technologies/convertto-bip-downloads.html

Hi @Jean-Pierre Hoedenaeken , I would create a materialized view in the datawarehouse. You could calculate it with something like TIMESTAMPDIFF(SQL_TSI_DAY, MIN(Date by Id Contenu), Date), but it requires to have both Date and Id Contenu columns in your analysis/visualization/query to preserve the correct granularity. In…

Hi @La_Berry91 , Please refer to Doc ID 2479928.1

Hi @La_Berry91 , I didn't know that idea, but voting for it is the best way to have it implemented in a future release!

Hi @La_Berry91 , Unfortunately, it's not possible to do it.

Hi @Daniel Vornicu , I'm sorry I didn't read properly your first post. This is the expected behaviour. You can export to Excel only table or pivot visualizations. The option is not available when you try to export the entire workbook, or visualizations other than table or pivot.

Hi @Daniel Vornicu , Could it be that an administrator already enabled it in your OAC instance? The feature must be enabled only once, not every time that you want to export to Excel.

Hi @User_DCJG6 , The Model Administration tool in OAS 2023 works slightly different compared to OBIEE 12c. When you add a hierarchical column to the presentation layer, then it must also contains all columns used as display columns in hierarchal levels. Otherwise the tool will raise an error. If you delete column4, and…

Hi @User_DCJG6 , If you are working in offline mode, then you also have to save your RPD and upload it to OAS. Once uploaded, I also recommend to navigate to the Administration page in Classic, and click on the "Reload Files and Metadata" option. This ensures that all the latest changes applied to the RPD will be available…

Hi @User_DCJG6 , I don't understand what you are trying to achieve. Can you please share a screenshot of your RPD and highlight the object that you need to delete? Are you working in online or offline mode?

Hi @Ruchi Shivhare , As an alternative, you can setup a presentation variable for each prompt, and then replace the Filters view with a Static Text one. This allows you to display only selected values in prompts.

Hi @User_NCHVR , Can you please provide more details? What should happen when the transaction date satisfies the condition? What about when the condition is false?

Hi @User_RS68A , If I understood it correctly, you would like your calendar table to be able to play multiple roles (e.g. order date, payment date, invoice date, etc.). This is not possible since there could be at most one join/link between 2 given objects (eventually the join/link can be based on multiple columns). You…

Hi @User_RS68A , You can do it, but I highly recommend to model the calendar table directly in the RPD (you can use a sql query directly in the physical layer to do it). If you want to use Data Visualization then: Create a new dataset with your calendar data Grant users/roles access to the dataset Create a dummy workbook…

Hi @User_BSR5K , You can use the following calculation to achieve your goal: LEFT(ColumnName, LOCATE(':', ColumnName) - 1) The LOCATE function returns the position of the first occurent of ':' character for each ColumnName value. The LEFT function returns a specified number of characters from the left of a string. Used in…

Hi @DeepaliG-Oracle , I meant the full curl command (or equivalent) that you are using to invoke the API (of course, you can mask sensitive information). This error usually happens when you do not specify the protocol or the method is not supported. Are you using it to reload a dataset created from a subject area/database…