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
32
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 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 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.