Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Row Duplication in Output from CDA

  1. #1
    Join Date
    Jun 2017
    Posts
    5

    Angry 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.

    Name:  Error.jpg
Views: 43
Size:  21.4 KB

  2. #2
    Join Date
    Jun 2017
    Posts
    5

    Default Duplication of records in pentaho CDA ouput.

    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

    Name:  Error.jpg
Views: 43
Size:  21.4 KB

  3. #3
    Join Date
    Jun 2017
    Posts
    5

    Default Duplication of records in pentaho CDA ouput.

    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

    Name:  Error.jpg
Views: 49
Size:  21.4 KB

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.