Row Duplication in Output from CDA

Hi,
I am using cda document to fetch data from Mondrain.
My query is MDX based, I create a report in Saiku and copy that MDX then use that in my CDA file. In Saiku its shows 1 record, but in CDA file out put it return 10 row with few NULL values.
Here is my 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]

It return 1 record in saiku but 10 rows in CDA output.
Following is the out put of CDA.

Attachment 18450

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

Attachment 18455

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

Attachment 18456