We have a requirement to dynamically hide a column in the excel report based on what input parameter the user selects. . I am guessing it should be done using <xsl: if test…?> clause, but not sure of. Need some inputs on this.
Hi @Reena Agrawal
Thanks for using Oracle Communities.
Yes, you can use the if condition to hide the same . Refer below MOS doc -
Display or hide columns depending on the parameter selected (Doc ID 2539753.1)
Regards,
Arjun
Thank you for replying @Mallikarjuna Kuppauru-Oracle. This looks like the code to be used in rtf template. My requirement is in an Excel template.
Conditional formatting is not supported in excel templates as its done for RTF. You will have to go via RTF route for conditional formatting requirements.
Thanks for your response @Abhilash K - Deloitte USI .
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…
Hello Team, I am generating a BI Publisher report scheduled through an ESS Job with the output format as CSV. When the report returns no data, I need the output file to contain only the column headers. However, the generated CSV contains the headers followed by an additional first data line with delimiters only, which is…
Anyone facing issue with calling the https://xxxanalytics-[tenant]-ia.analytics.ocp.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?wsdl with runReport operation with WSS-Username Token after recent upgrade with OAC ? The Basic Authenticaiton works from SOAPUI , however the WSS-Username Token does not work and…
