none
"The member was not found when the string was parsed - SSAS 2008/PivotTable

    Question

  • Hello,

        I have defined an Additional Action to show me some detailed records when I'm using a PivotTable against an SSAS 2008 cube.  However, the problem is intermittent.  It seems to be complaining about a datetime field - yet this datetime field isn't even being requested as one of the drillthrough columns. 

        The full message is "Query (187,1319) The member '&[2010-07-30T15:31:44:263333] was not found in the cube when the string [Final Criminal Count Charge].[Load Datetime].[All].&[2010-07-30T15:31:44.263333], was parsed."

       Any assistance would be gratefully accepted!!

    Pete

    Monday, September 20, 2010 8:21 PM

All replies

  • As suggested, the query formed is wrong here 

    [Final Criminal Count Charge].[Load Datetime].[All].&[2010-07-30T15:31:44.263333]

    All is also a member. So should have comes something like this [Final Criminal Count Charge].[Load Datetime].&[2010-07-30T15:31:44.263333]


    vinu
    Tuesday, September 21, 2010 3:23 AM
  • Hi Pete,

    Could you run below query in SSMS to check if the member is there:

    select {} on 0,

    [Final Criminal Count Charge].[Load Datetime].[All].&[2010-07-30T15:31:44.263333] on 1

    from [You cube name]

     

    I guess there is no such member in your cube. You need to format the string “2010-07-30T15:31:44.263333” before using it.

     

    Hope this helps,

    Raymond
    Raymond Li - MSFT
    Wednesday, September 22, 2010 8:57 AM
  • The member must be in the cube since it works sometimes i.e. pulls the correct data via the Additional Action.  I haven't modified the cube or changed the data.

    Thoughts?

    Pete

     

    Thursday, September 23, 2010 3:58 AM
  • Raymond,

    I ran the query you recommended.  It didn't return any results, but gave the following message when I ran the query in SSMS.

     

    Executing the query ...
    Obtained object of type: Microsoft.AnalysisServices.AdomdClient.CellSet
    Formatting.
    Cell set consists of 0 rows and 0 columns.
    Done formatting.
    Execution complete

     

    I'm not sure how I'm supposed to format the datetime value.  In the Dimension Attribute property, its Key Column is defined as a Date but its Name Column is defined as  WCHAR.  I'm very new to SSAS so I'm not sure how I should format it for the query.

    However:  the drillthrough action now seems to be working - the data is there (I haven't changed the data or the cube structure).  It seems like it works intermittently.

     

    Thanks in advance,

     

    Pete

    Thursday, September 23, 2010 3:09 PM
  • Executing the query ...
    Obtained object of type: Microsoft.AnalysisServices.AdomdClient.CellSet
    Formatting.
    Cell set consists of 0 rows and 0 columns.
    Done formatting.
    Execution complete


    The message means there is no such member in your cube. For example, in my sample cube:

    select {} on 0,

    [Date].[Calendar Year].&[2001] on 1

    from [Adventure Works]

    -------output

    CY 2001

     

    However, if I run below query 0 rows and 0 columns return:

    select {} on 0,

    [Date].[Calendar Year].&[2001sdfasdfasdf] on 1

    from [Adventure Works]

    Executing the query ...

    Obtained object of type: Microsoft.AnalysisServices.AdomdClient.CellSet

    Formatting.

    Cell set consists of 0 rows and 0 columns.

    Done formatting.

    Execution complete

     

    In SSMS, drop a member into the grid, check the keycolumn format whether it’s &[2010-07-30T15:31:44.263333]. Anyway, you have to ensure the string can be found in your cube. You can also check the members in that attribute with below query:

     

    with member measures.x as

    [Final Criminal Count Charge].[Load Datetime].currentmember.uniquename

    select {measures.x } on 0,

    [Final Criminal Count Charge].[Load Datetime].[Load Datetime] on 1

    from [your cube name]

     

    Hope this helps,

    Raymond
    Raymond Li - MSFT
    Friday, September 24, 2010 2:32 AM
  • Raymond,

        I ran the query you specified and got the following results.


    2010-07-30 15:31:44.263    [Final Criminal Count Charge].[Load Datetime].&[2010-07-30T15:31:44.263333]

     

       I'm not sure what you mean by "drop a member into the grid". 

       FYI - all  the records in this dimension have the same load datetime value as I'm truncating the table and then loading.  Don't know if that makes any difference.

    Thank you,

    Pete

     

    Monday, September 27, 2010 6:30 PM
  • Pete,

    Based on your message "The full message is "Query (187,1319) The member '&[2010-07-30T15:31:44:263333] was not found in the cube when the string [Final Criminal Count Charge].[Load Datetime].[All].&[2010-07-30T15:31:44.263333], was parsed."

    Try passing the "[Final Criminal Count Charge].[Load Datetime].[All].&[2010-07-30T15:31:44.263]" value in your MDX script and check if you get any measure against this dimension. If you get then problem is with the datetime member which is passing more than 3 digits for seconds.

     

     


    Thanks, Manish
    Thursday, January 20, 2011 1:04 PM