Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to achieve not to display place holders and formula columns which are not part of a group

Received Response
31
Views
3
Comments

Summary

how to achieve not to display place holders and formula columns which are not part of a group

Content

Based on some input parameter i need to print out put or no output(zero bites) using XML publisher report(xml source is RDF file)

using lexicals i have achieved this by concatenating 1=1 or 1=2 based on input parameter.i am facing the problem to control place holders which are defined at report level(not part of any groups),based on input parameter i dont want to generate the xml tags for those place holders.any inputs are very helpfull.

Thanks in Advance

Ripendra

Answers

  • R Kumar Durgam
    R Kumar Durgam Rank 2 - Community Beginner

    HI Brajesh,

    i am expecting not to assign blank or null values to the place holders ,i am expecting place holders should not come in xml output file.

    in the below screen shot ,ieven i dont want to get all place holders columns(source is RDF file)

    image

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics & AI Coach

    In the after report trigger based on the parameter value you can assign those place holder column as blank. so that it will not generate.

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics & AI Coach

    Hi,

    These columns will appear with blank value...add plsql code to these place holders and return false based on your logic so that it will not appear in XML.