Trade Management: Budget Dashboard - DFF from different tables - OZF_FUND_TABLES / QP_LIST_HEADERS_B
Hi all,
EBS Information Discovery 12.2.6 (V7) for Trade Management
My client wants to customize the Budget Dashboard in Trade Management by adding some new DFF filters. The base view behind the Dashboards extracts all the attributes from the table OZF_FUNDS_ALL but I would like to add new DFF filter coming from the QP_LIST_HEADERS_B. My issue is that the SQL behind looks like this:
SELECT SUM(AMOUNT), ATRIBUTE1, ATTRIBUTE2,....ATTRIBUTEn
FROM OZF_FUNDS_ALL
GROUP BY ACCOUNT_ID
Being new to EBS Trade Maangement I would like to know if it is doable? How can I look for some new DFF attributes using a different table in the base view when there is already a set of DFF attibutes?