Hi @Tiang , You can't extend the existing domain. You have to create a new one, and select both Oracle Analytics Server, and Oracle Analytics Publisher.

Hi @Saroj Kumar Behera , Do the EMPLOYEE_ID column and the USER session variable have the same data type? Also note that the comparison is case-sensitive. Does your username have corresponding rows in EDQ_FINANCE_ADMIN? If it works with a pre-defined value, it should work also with the session variable.

Hi @Saroj Kumar Behera , I would replace 'VALUEOF(NQ_SESSION.USER)' with ':USER' in your query.

Hi @SaurabhJaiswal-Oracle , Did you use the same user who created the dataset and the connection to export the workbook from the old instance, and import it into the new one? If you use a different user, then this issues are expected since the original owner name is part of the "true" object name. I recommend to…

Hi @Tiang , AFAIK it's not possible to include additional components into an existing domain (e.g. Oracle Analytics Server in your case). You have to create and configure a new domain with all the components that you need.

Hi @Saroj Kumar Behera , You have to use row-wise initialization: It assumes that the first column in your query is a string with the name of the variable: SELECT DISTINCT 'TOPDEPARMENT_SV', TOPDEPARMENT FROM etc. You must also edit the data target and tick the row-wise checkbox.

Hi @Joanne Mc , Could you please share more details about the datasets which are not performing as expected? Are they based on a database connection? Are you mixing different sources (e.g. database, files, subject areas)? How many tables do they contain? Are BI Server and XSA cache enabled? I'd highly recommend to enable…

Hi @User_801US , You mentioned Admin Server, so I'm assuming you are on Oracle Analytics Server. Is this error preventing your OAS environment to start? Did the RCU schemas password expire? Did you recently change it? If so, you may need to set a password properly, eventually unlock any locked RCU user, and update the…

Hi @PeakIndicators_Alastair, I don't know how to do it using the Advanced tab. But you can achieve the desired result by adding a dummy column to the Criteria tab, which is not present in the LTS that you want to exclude. Of course, you have to define the dummy columns for each LTS that you want to keep in the RPD, and…

Hi @Stijn Bormans , Database Storage for User Group Memberships is not supported in OAC. The feature has been deprecated and might be desupported in (a future version of) OAS as well. You have to import users, groups and memberships from your database to your OCI identity domain.

Hi @User_VMJII , You have to add the BY clause to the AVG function, otherwise it will return the same value for all rows (e.g. the total avg): AVG(expression BY Time)

Hi @Abhilash K - Deloitte USI , Your screenshots refers to data sources for the metadata repository (RPD), not Publisher data models.

Hi @Abhilash K - Deloitte USI , According to the documentation, the Web Service option to create a data set in a Publisher data model is not deprecated and planned for desupport. https://docs.oracle.com/en/middleware/bi/analytics-server/whats-different-oas/index.html Where did you read/hear about it?

Hi @Dom Lichte-Oracle , Where would like to display that custom infographic? Analytics Classic, Publisher, or Data Visualization? AFAIK there isn't any ootb or easy way to do it. In Data Visualization, you could create a standard bar chart and overlay an image on it (having one transparent silhouette for each bar and a…

@Gabriele Boccassini No. It refers to the number of rows in the result set (logical rows), which is always in plain tabular format. The pivot is created AFTER the result set has been generated and returned to your web browser. In your case, the number of logical rows is probably the same as your physical rows (380000). To…

Hi @Gabriele Boccassini , There appears to be a limit on the maximum number of cells (number of rows * number of columns) that a pivot table can have in OAC. This limit is not documented, users/administrators can't update it, and only Oracle knows if the value is going to change according to the number of OCPUs. If you…

Hi @Sonu agarwal , Can you still access the Snapshots section in the Console page? If so, I would proceed as follows: Restore a vanilla OAS 2024 snapshot Use the datamodel uploadrpd utility to upload the RPD: https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/upload-repository-command.html Import the…

Hi @mohammad-rafi-ansari-Accenture , AFAIK the OAC REST APIs do not allow yet to move catalog objects from a source environment to a target one. To migrate catalog objects (and have full control on which specific objects to migrate), you can use the archive/unarchive features, or the Catalog Manager command line interface…

Hi @User_6WRYU , If the solution provided in the support note does not work, I would create a SR. Please note that according to the documentation, Oracle Marketing Segmentation is planned for removal in Oracle Analytics Server 2025. I highly suggest to start thinking about alternative/equivalent features to replace it:…

Hi @Monica D , This thread has not been updated in the last 2 years. I suggest you to create a new one for your question, so you can properly manage comments and select the correct answer(s).