get the current row or column tuples

hi all,
when creating calculated member can use .currentmember take @ data specific member in axis, given before hand know hierarchy need retrieve currentmember from.
lets need create cube calculated member, , don't know how calculated member used, have no idea hierarchy used, how can current tuple row , column?
should looking @ .current function?

hi,

something might grasp concept. google axis() functions:

  with set [iterator] as [date].[day of year].[day of year]  member [context] as 'axis0: ' + generate ( 	head 	([iterator], axis(0).item(0).count) as 	,axis(0).item(0).item(i.current.member_value-1).hierarchy.currentmember.name 	,', ' ) + ' axis1: ' + generate ( 	head 	([iterator], axis(1).item(0).count) as 	,axis(1).item(0).item(i.current.member_value-1).hierarchy.currentmember.name 	,', ' )  select  [product].[product categories].[category] * [sales territory].[sales territory].[group]  on 0, [customer].[customer geography].[country] * [sales channel].[sales channel].[sales channel]  on 1 from [adventure works] where (measures.[context])  

hth,

hrvoje piasevoli

SQL Server  >  SQL Server Analysis Services