The dimension [Time] was not found in the cube when the string [Time]. [Year] has been pulled

Question

[Time]. [Year] attribute defaultMember has a value

tail(FILTER( [Date].[Year].members, not ISEMPTY( [Date].currentmember )), 1).item(0) 

When I try to view the cube, I get an error:

DefaultMember (Date, Year) (1,14) The dimension "[Time]" was not found in the cube when the string [Time]. [Year], was analyzed

Answer 1

That the odd post considering the expression you are showing has a Date dimension, not a specified time. If this is true, here is what I would do to track the problem. Locate the solution folder in the file system, open the project folder and open the bin folder. You must have a file with the extension ASDATABASE. If you don’t see the file extension but see a type column, open it with the Analysis Services database deployment content type. Open it with Notepad or your favorite text or XML editor. Find the file for [Time]. [Year], and then navigate your way back through the nodes to find out which property belongs to him. Then you can go to SSDT and fix the problem.