Hi @#Mayur , It would be useful to know the values provided by the user and how parameters have been implemented in the data set query, otherwise we can't help you. Does the issue happens always or only with a particular combination of values? Which kind of template are you using?

Hi @Marcelo Finkielsztein , In the Home page, expand the Navigator menu, select Console, then Content (only BIServiceAdministrator members are allowed to access it). The Content Management page will display a list of all objects in Oracle Analytics. You can filter by Owner, object Type, select multiple objects (use the…

Hi @User_0PDV4 , It's not possible to create that join directly. Given a table A in the Join Diagram, you can join as many tables as you want on the right-side, but only one on the left-side. You could either a) drag and drop the CX_RESERVATION_V table one more time to the Join Diagram (with a different name) and join it…

Hi @User_0PDV4 , You could add Table 2 (or Table 4) twice to the Join Diagram with a different name to create the required joins. Can you please share a screenshot of the Join Diagram tab from the Dataset Editor? This will allow us to provide better recommendations.

Hi @User_SXVU3 , Can you please share a screenshot of how the analyses look in the dashboard and another one with the issue in Excel?

Hi @Riya_Maithani-Oracle , In this case, I would update the source query to include the calculation as a new column (e.g. SUBDESCR) directly in the data model, so you no longer need to calculate it in the template. Then in your template you can do something like that: <?if: SUBDESCR != '3'?> do things <?end if?>

Hi @User_SXVU3 , You're welcome! If you are happy with the proposed solutions, would you mind to mark my comment and @RanaAshutosh-Oracle's one as the answers? In this way other people with the same issue can easily find them.

Hi @Riya_Maithani-Oracle , You should update your conditional formatting as follows: <?xdofx: if SUBSTR(DESCR,19,1) != '3' then 'print this content' end if?>

Hi @User_SXVU3 , If you don't need to use native Excel features, I recommend to use a RTF template to create your pivot table, and then export it in Excel format. Otherwise, if you need to use the native Excel features available in Excel template, you can follow this approach: Add a "Source" sheet in your Excel template.…

Hi @User_SXVU3 , Unfortunately, this is the expected behaviour. As an alternative, you can a) replace Publisher reports with analyses, or b) add a link near each Publisher report, so users can click on it to download the report in the desired format. Please refer to this page to create the links to your Publisher reports…

Hi @Kaden B , Instead of using the Branch step in your data flow, you should add your input dataset twice. In this way there will be no errors when you add a Join step.

Hi @Manu R-Oracle , Please use the following columns in your analysis: Supplier Name: "Supplier"."Supplier Name" Supplier Name New: CASE WHEN ATTRIBUTE(RANK("Financials - AP Transactions"."Facts"."AP Cleared Invoice Amount (Document Currency)") BY "Supplier"."Supplier Name") <= 10 THEN "Supplier"."Supplier Name" ELSE…

Hi @Jelly , BI Publisher 12.2.1.4 requires Oracle Fusion Middleware 12.2.1.3. You should use Oracle Analytics Publisher 12.2.5.9.0+ with Oracle Fusion Middleware 12.2.1.4.

Hi @Manu R-Oracle , Can you please share all column expressions used in the analysis? As an alternative, you can combine results based on Union All set operation (e.g. one criteria to get the top 10 products with related metrics, and another criteria to get all other products not in the top 10)

Hi @Munish Kumar-Oracle , Oracle BI Publisher 12.2.1.3.0 and 12.2.1.4.0 are not interoperable with OIG 12.2.1.4.0. You have to upgrade to Oracle Analytics Publisher 12.2.5.9.0+.

Hi @Jelly , You should use a UNC path since you are on Windows: https://learn.microsoft.com/en-us/dotnet/standard/io/file-path-formats#unc-paths Please note that the path should be accessible from all bi publisher nodes.

Hi @Jelly , I'm going to ask one more time: is your BI Publisher running in a cluster environment? This issue is quite common when BI Publisher is running in a cluster environment, but the "Shared Directory" setting is null (default). If this is the case, you can update the "Shared Directory" setting as follows: Login to…

Hi @Munish Kumar-Oracle , OIG 12.2.1.4 is certified with Oracle Analytics Publisher 5.9.0+: https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/intop/interoperability-and-compatibility.html#GUID-3F157305-D405-4569-9B56-16A4690E1575

Hi @Jelly , Is BI Publisher running in a cluster environment?

Hi @User_R3CQA , Which type of report template are you currently using? When displaying datetime values, BI Publisher takes into consideration the time zone of the user running the report, but the report template must be either RTF or XSL. Moreover, the datetime element in the XML file must include the UTC offset. In…