locked
The dimension '[Current Date]' was not found in the cube when the string, [Current Date], was parsed RRS feed

  • Question

  • I have a large cube with multiple Order, Invoices, Quote and goal information that I process everyday.   On the average, I get the following error about once a week.   Once the error occurs, I resubmit the processing and the cube completes successfully but it puts me hours behind schedule. 

    MdxScript(Sales Customer Performance) (4330, 5) The dimension '[Current Date]' was not found in the cube when the string, [Current Date], was parsed.

    and Current date is defined as

    CREATE SET CURRENTCUBE.[Current Date]
    AS
        TAIL( FILTER( [Transaction Date].[Transaction Date Hierarchy].[US Working Date].Members, NOT ISEMPTY( ( [Transaction Date].[US Working Date].CurrentMember, Measures.[Gross Sales $] ) ) ), 1 ).Item(0);   


    Werner

    Thursday, December 6, 2012 2:37 PM

Answers

  • Hi Werner,

    Thanks for your question.

    Could you please post the detail log information when you process your cube? We can collect the log files via the following path:
    <Drive>:\Program Files\Microsoft SQL Server\MSAS10.<InstanceID>\OLAP\Log\

    - OR -

    <Drive>:\Program Files\Microsoft SQL Server\MSAS10_50.PowerPivot\OLAP\Log\

    You can also try to use SQL Server Profiler to capture the events for analyzing. Please see:
    http://msdn.microsoft.com/en-us/library/ms174946.aspx

    If there is an emergency, you can opening a case with Microsoft Customer Support Services (CSS) (http://support.microsoft.com), so that a dedicated Support Professional can assist you in a more efficient manner.

    If you have any feedback on our support, please click here.

    Regards,


    Elvis Long
    TechNet Community Support

    • Proposed as answer by Elvis Long Monday, December 17, 2012 1:28 AM
    • Marked as answer by Elvis Long Wednesday, December 26, 2012 1:26 AM
    Monday, December 10, 2012 3:20 AM