Analytics Software

Hi All,

I'm having a hard time to figure out the way of diabling Distinct values in Answers.

I have 2 tables Dim and a Fact. The Sql generated in Answers is perfect. I executed this query in SQL database and it gave proper results(30400 rows). But the same query in Answers gives me only 22700 rows.

The proper rows should be 30400 rows.

Here is the query from Answers.

WITH
SAWITH0 AS (select T171."Sales_Amt_OMR" as c1,
T171."Postage_DT" as c2,

T104."DAY_DATE" as c3
from

"FACT_PD_CUS_CTY_DAY_Sales" T171 left outer join
"Lk_Time" T104 On T104."DAY_DATE" = T171."Postage_DT")
select SAWITH0.c3 as c1,
SAWITH0.c2 as c2,
SAWITH0.c1 as c3
from
SAWITH0


1.I Unchecked the box in Advance tab of Answers.
2.I gave 'None' as values for the 'default aggreagation rule'.
3.I Unchecked the 'Distinct_supported' in Features tab of rpd file.


Please help.

Thanks in Advance
Jaan