Hello Community
We have created custom metrics using Logical Star in Oracle FDI and added them to the GL – Balance Sheet subject area.
However, the metric is returning zero values when used as a custom metric in the semantic model, while the exact same formula works correctly when created as a calculated column in the subject area.
IFNULL(
FILTER(
"Core"."Fact - Fins - GL Balance"."Balance Amount in Analytics Currency - Base"
USING "Core"."Dim - GL Account"."Financial Category Code" = 'LEASE LIAB'
) * (-1),
0
)
Has anyone faced a similar issue with FILTER / dimensional context or custom metrics behavior in FDI semantic models?
Any guidance or best practices would be greatly appreciated.
Thanks in advance for your support.
Regards
Saptadip
