Duplication of records in pentaho CDA ouput.

[rniaz]

Hi,
I am working on pentaho CDA document to fetch data. Problem I am facing is that when I write MDX query in CDA document there is row duplication. When I use same query in Saiku then single row is returned, but in case of CDA there are duplication of row.
Following is my MDX query.

WITH
SET [~Time_Time.Default_Year] AS
Exists({[Time.Default].[Year].Members}, [~Time_Time.Default_Day])
SET [~Time_Time.Default_Month] AS
Exists({[Time.Default].[Month].Members}, [~Time_Time.Default_Day])
SET [~Time_Time.Default_Day] AS
{[Time.Default].[${selectedYear}].[${selectedMonth}].[${selectedDay}]}
SET [~ROWS_Time_Time.Default] AS
Hierarchize({[~Time_Time.Default_Year], [~Time_Time.Default_Month], [~Time_Time.Default_Day]})
SET [~Client_Client_ClientId] AS
{[Client].[${ClientId}]}
SET [~Client_Client_ClientName] AS
Exists({[Client].[ClientName].Members}, [~Client_Client_ClientId])
SET [~ROWS_Client_Client] AS
Hierarchize({[~Client_Client_ClientId], [~Client_Client_ClientName]})
SET [~ROWS_UserStatus_UserStatus] AS
{[UserStatus].[UserStatusName].Members}
SET [~ROWS_UserType_UserType] AS
{[UserType].[UserType].Members}
SELECT
NON EMPTY {[Measures].[NewAddedProfiles], [Measures].[TotalProfileCount], [Measures].[UpdateProfileCount]} ON COLUMNS,
NON EMPTY NonEmptyCrossJoin([~ROWS_Time_Time.Default], NonEmptyCrossJoin([~ROWS_Client_Client], NonEmptyCrossJoin([~ROWS_UserStatus_UserStatus], [~ROWS_UserType_UserType]))) ON ROWS
FROM [UserProfilebyClient]

following is result out put in CDA document

[pamval]

Use BandedMode = compact. Something like:

<DataAccess access="public" connection="mdxQuery" id="mdxQuery" type="mdx"> <Name>mdxQuery</Name> <BandedMode>compact</BandedMode>

[rniaz]

I have also tried this tag compact in connection, but there is no difference in output.

[pamval]

what version of Pentaho are you using? There was a bug like that once, but it has been fixed for years now