Hierarchy security permissions to read ant write cube

hello,

i have problematic situation - need allow of writing cube in detailed level members, see hierarchy members. f.e. use read-write mdx script "isleaf([dimensionx].[hierarchyofx]) ant enables read-write persission detailed members of hierachy. problem cant see subtotals of hierarchy levels...

what expression should use resolve problem?

 

thanks,

paulius

 

 

 

hi paulius,

if want enable cubewriteback, have use cell security.

you can enter following mdx expressions different sections

"allow reading of cube content": 1

"allow reading , writing of cube content": isleaf([product].[product categories].currentmember),1,0)

please keep datamember in mind if dimension parent/child dimension.

 

hope helps

tom

SQL Server  >  SQL Server Analysis Services