Post reply

Member was not found in the cube when the string

  • November 12, 2025 at 9:30 am

    #4684080

    Hey, I've not done a Cube for many years but a colleague of mine has requested some help.

    We're processing a Cube called "Timesheet" and it's failing with the following message:

    The '[2025-11-11 09:00:00]' member was not found in the cube when the string, [Instruction Date].[By Calendar].[Date].[2025-11-11 09:00:00], was parsed.

    On the face of it I expected the member to be missing from the Date dimension but it is there and the dimension processed successfully.

    A few nuances:

    • This is a Test environment and the Production environment works fine.
    • The database used as the warehouse has just been replaced.
    • When I processed the Timesheet Cube today (12th November) the missing member was the 11th November, but yesterday the missing member was the 10th, it's always the previous day.
    • There is a Previous Day dimension based on a Fact table, but it's not used in the Timesheet cube.
    • All the cubes in the project fail with this same issue.

    If there are more details that I could provide to help address this issue then please let me know and I'll add them to the Topic.

    Many thanks

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply