So like this;
SELECT @SELECT:DIM:USER_DEF:IMPLIED:***:my_sql.my_unique_id:uq_id@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.ODF_Parent_ID:ODF_Parent_ID@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.nna_ll_type:nna_ll_type@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.nna_ll_cat:nna_ll_cat@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.nna_ll_ph:nna_ll_ph@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.nna_ll_ven:nna_ll_ven@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.nna_ll_com:nna_ll_com@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.nna_ll_fu:nna_ll_fu@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.CODE:CODE@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.MANAGER_ID:MANAGER_ID@
, @SELECT:DIM_PROP:USER_DEF:IMPLIED:***:my_sql.Fin_OBS:Fin_OBS@
FROM
(
Select
i.ID||o.ID my_unique_id, /* Note this is a GUESS for a unique identifier within your data */
o.ODF_Parent_ID,
o.nna_ll_type,
o.nna_ll_cat,
o.nna_ll_ph,
o.nna_ll_ven,
o.nna_ll_com,
0.nna_ll_fu,
i.CODE,
i.MANAGER_ID,
P.Fin_OBS from ODF_CA_NNA_LL o,INV_INVESTMENTS i,odf_ca_project P
where I.ID=o.ODF_Parent_ID AND P.ID=I.ID
) my_sql
WHERE @FILTER@