Hello,
One of the dimension in my schema is something like this:
<Dimension name="APN">
<Hierarchy hasAll="true" allMemberName="All" primaryKey="ENTITY_KEY" caption="APN">
<Table name="D_ENTITY_APN"/>
<Level name="APN" uniqueMembers="false">
<KeyExpression>
<SQL dialect="oracle">
DECODE(APN,'*','Desconhecido',APN)
</SQL>
</KeyExpression>
</Level>
</Hierarchy>
</Dimension>

With this I want to show the value 'Desconhecido' when the APN column takes the value '*'.
But it does't work... the result query has the value:
SELECT "D_TIME"."YEAR" AS "c0", "D_TIME"."MONTH" AS "c1",
"D_TIME"."DAY_OF_MONTH" AS "c2", "D_ENTITY_SM"."SGSN" AS "c3",
"D_ENTITY_SM"."RNC_BSC" AS "c4",
"D_ENTITY_PROCEDURE"."PROCEDURE" AS "c5",
"D_ENTITY_RELCAUSE"."RELCAUSE" AS "c6",
DECODE (apn, '*', 'Desconhecido', apn) AS "c7",
AVG ("F_SM"."M182072") AS "m0", SUM ("F_SM"."M182070") AS "m1",
SUM ("F_SM"."M182071") AS "m2"
FROM "D_TIME" "D_TIME",
"F_SM" "F_SM",
"D_ENTITY_SM" "D_ENTITY_SM",
"D_ENTITY_PROCEDURE" "D_ENTITY_PROCEDURE",
"D_ENTITY_RELCAUSE" "D_ENTITY_RELCAUSE",
"D_ENTITY_APN" "D_ENTITY_APN"
WHERE "F_SM"."TIME_KEY" = "D_TIME"."TIME_KEY"
AND "D_TIME"."YEAR" = 2007
AND "D_TIME"."MONTH" = 11
AND "D_TIME"."DAY_OF_MONTH" IN (19, 20, 21)
AND "F_SM"."ENTITY_KEY" = "D_ENTITY_SM"."ENTITY_KEY"
AND "D_ENTITY_SM"."SGSN" = 'SGSNBNF1'
GROUP BY "D_TIME"."YEAR",
"D_TIME"."MONTH",
"D_TIME"."DAY_OF_MONTH",
"D_ENTITY_SM"."SGSN",
"D_ENTITY_SM"."RNC_BSC",
"D_ENTITY_PROCEDURE"."PROCEDURE",
"D_ENTITY_RELCAUSE"."RELCAUSE",
DECODE (apn, '*', 'Desconhecido', apn)

But in the JPivot the values with "*" doesn't appear.
What can I do?

Thanks,
CDias