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