InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 16:01:09 GMT20http://www.sqlservercentral.com/Forums/Topic850345-147-1.aspxNot sure how you have this setup or what tool you are using to return these results, but if you are just querying the database you could do something like this:SELECT Measures.[% Tasks Completed] on 0,{Ancestor([Organisation].[Hierarchy Name].[Employee Name],[Organisation].[Hierarchy Name].[Team]),[Organisation].[Hierarchy Name].[Employee Name]} on 1FROM [Cube Name]You would need to replace the hierarchy name, the employee name, and the cube name. Also, this is referencing the name of the member and not the unique name, so it might look like this with the unique member (or key) reference:SELECT Measures.[% Tasks Completed] on 0,{Ancestor([Organisation].[Hierarchy Name].&[Employee Number],[Organisation].[Hierarchy Name].[Team]),[Organisation].[Hierarchy Name].&[Employee Number]} on 1FROM [Cube Name]By using the Ancestor function you can grab a related dimension member at a specified level in the hierarchy.[u][url=http://msdn.microsoft.com/en-us/library/ms145616(SQL.90).aspx]Ancestor (MDX)[/url][/u]Sat, 23 Jan 2010 19:21:34 GMTdenglishbihttp://www.sqlservercentral.com/Forums/Topic850345-147-1.aspxIt looks like you should create another calculated measure on the cube, which would go one level up (.parent) and calculate the currentmember against its parent.What are the facts on the cube?What soes the Task Completed % calculated measure do (code)?Fri, 22 Jan 2010 06:09:46 GMTVALEKhttp://www.sqlservercentral.com/Forums/Topic850345-147-1.aspxHi,I am new to ssas and I have a specific requirement, In cube I have[b]Measures: [/b]1. "% Tasks Completed" (Calculated Measure)[b]Dimensions:[/b]1. Date, with (Year - Quarter - Month) hierarchy.2. Organisation, with (Unit - Team - Employee) hierarchy.user want slice the measure "% Tasks Completed" by date and want to filter data by "Employee" level in "Organisation" dimension, BUT....Also [b]at the same time [/b]want to see "% Tasks Completed" related to the "Team" employee belongs to (the level above "Employee" as you cans see in dimension 2)how to accomplish this?any help would be very much appreciatedJadWed, 20 Jan 2010 03:26:28 GMTRaj-115466