AnsweredAssumed Answered

Dynamic Consultation for Portlets

Question asked by Vitor.Rebello on Aug 16, 2012
Latest reply on Aug 16, 2012 by shalinee
Hi,

I try to create a dynamic consultation. After that I will add this consultation in a portlet. When I execute some problems are presented.
The consultation is below:

SELECT

@SELECT:DIM:USER_DEF:IMPLIED:PRJ:P.ID:PROJECTID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PARTITION_CODE:CODIGOPARTICAO@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PMDF_OBJ_ESCPREPRO:ESCOPOPROJETO@,

FROM ODF_CA_PROJECT P
WHERE PARTITION_CODE IS NOT NULL
AND @FILTER@

What is the diference between DIM and DIM_PROP? I don't understand this methods.

Outcomes