5 Replies Latest reply on Apr 12, 2016 3:43 PM by 2886698

    When creating Custom FDMEE Report custom columns not displayed

    2886698

      I am in the process of creating a custom FDMEE  report but when generated is missing data in fields from a query. steps to create the report were:

      1. generated the query

      2. created the RTF template and converted to XLF in BIP desktop.

      3. uploaded and tested the query in sqldeveloper and query definition

      4. In report definition i created the standard report parameters for POVLOC, POVCAT, POVPERIOD and POVRULE. and pointed to uploaded XLF template and previous query

      5. When executing the report only the parameters specified are populated in the generated report.

      I'm not sure what the issues could be as everything seems to be correct.

      Here is my query:

      select distinct

      t.loadid,

      p.partname,

      p.partdesc,

      c.catname,

      per.perioddesc,

      r.rule_name,

      r.file_path,

      a.execution_start_time,

      a.execution_end_time,

      a.records_processed,

      a.status,

      a.last_updated_by

      FROM tdataseg t

      INNER JOIN aif_process_details a ON t.loadid = a.process_id

      INNER JOIN TPOVPARTITION p ON t.partitionkey = p.partitionkey

      INNER JOIN TPOVCATEGORY c ON t.catkey = c.catkey

      INNER JOIN AIF_BALANCE_RULES r ON t.RULE_ID = r.RULE_ID

      INNER JOIN TPOVPERIOD per ON t.PERIODKEY = per.PERIODKEY

      WHERE   (~POVRULE~ IS NULL OR r.RULE_ID = ~POVRULE~)

      AND

      ((t.PERIODKEY)=~POVPERIOD~ )

          AND ((t.CATKEY)=~POVCAT~)

          AND ((t.PARTITIONKEY)=~POVLOC~ )

       

      I am using FDMEE version 11.1.2.4.0