Hide xml tags without data in transformed xml using xsl template in Fusion BIP reports

User_CFV13 · Apr 12, 2024 1:29PM

We are using xsl template in Fusion BIP report to create the output in xml format. Can you let us know if there is a way in xsl template to not display the tags in transformed xml when there is no data. There are multiple xml tags and we don't want to add <xsl:if> for each of the tags in xsl template. Is there any better approach to handle it.

Any response and solution is appreciated.

Mallikarjuna Kuppauru-Oracle · Apr 15, 2024 4:11PM

Hi @User_CFV13

You need to use the Conditional formatting only .No in-build option.

Regards,

Arjun

Abhilash K - Deloitte USI · Apr 16, 2024 12:08PM

Hi @User_CFV13 ,

Can you try using the test option?

Like this for example, to hide a description field when its null.

<xsl:if test="DESCRIPTION and string-length(DESCRIPTION) &gt; 0">

						<xsl:element name="description">

							<xsl:value-of select="DESCRIPTION"/>

						</xsl:element>

					</xsl:if>

MFA for Oracle Community

Oracle Analytics Publisher

Categories

Hide xml tags without data in transformed xml using xsl template in Fusion BIP reports

Answers