locked
Unable to retrieve records through Proclarity..no results for MDX query RRS feed

  • Question

  • I am able to execute the following query in MDX sample application and results are returned on time.but the same query when executed on Proclarity gives no output and no errors.It neither hangs.I am using As 2000.

     

    Please help.

     

    SELECT { [Measure Type].[Primary Name].&[10010965] } ON COLUMNS , NON EMPTY { { { DESCENDANTS( [Customer].[Citizenship].[All Customers], [Customer].[Citizenship].[Customer] ) } * { DESCENDANTS( [PCAM Product Group].&[500003125], [PCAM Product Group].[Local Product] ) } * { [Balance Currency].[Primary Name].&[10011364], [Balance Currency].[Primary Name].&[10011388], [Balance Currency].[Primary Name].&[10011542], [Balance Currency].[Primary Name].&[145], [Balance Currency].[Primary Name].&[10011430], [Balance Currency].[Primary Name].&[500004056], [Balance Currency].[Primary Name].&[500004057], [Balance Currency].[Primary Name].&[10011546], [Balance Currency].[Primary Name].&[1006], [Balance Currency].[Primary Name].&[500004065], [Balance Currency].[Primary Name].&[10011480], [Balance Currency].[Primary Name].&[10011547], [Balance Currency].[Primary Name].&[10011530], [Balance Currency].[Primary Name].&[10011548], [Balance Currency].[Primary Name].&[10011550], [Balance Currency].[Primary Name].&[500004098], [Balance Currency].[Primary Name].&[10011357], [Balance Currency].[Primary Name].&[149], [Balance Currency].[Primary Name].&[144], [Balance Currency].[Primary Name].&[500004120], [Balance Currency].[Primary Name].&[148], [Balance Currency].[Primary Name].&[143] } } } ON ROWS FROM [Matrix] WHERE ( [Measures].[Balance], [Time].&[61000093] )

     

     

    Tuesday, November 27, 2007 8:04 AM

Answers

  • Note this was ultimately resolved with the use of the NECJ function, which can be enabled in ProClarity by navigating to File|Options, and is saved on a per view basis.

     

    Tuesday, January 8, 2008 9:22 PM

All replies

  •  

    Was the query created in ProClarity?  If not, it may not be formatted in such a way that ProClarity can render the results.  You should be able to build the same query using the Professional client and have it complete successfully.
    Tuesday, November 27, 2007 4:47 PM
  • Note this was ultimately resolved with the use of the NECJ function, which can be enabled in ProClarity by navigating to File|Options, and is saved on a per view basis.

     

    Tuesday, January 8, 2008 9:22 PM