vistana wrote:Hi All,
Just wondering if anyone has any idea on how i can still have the element security in dimension but still be able to use the roll up functions.
1. I have a Department dimension and user has specific access to certain department. (used element security to define user access)
2. In viewing the cube, I would like to use the Roll up function to create sub-totals for selected department which I have access.
3. When I click the roll up button, TM1 removes the list of the department i selected from the subset editor. So I think it is because of the element security defined.
Appreciate if anyone can give suggestion or alternative on how I can manage both security and roll up feature.
I doubt it has anything to do with security; it's normal behaviour. When you click on the [Rollup] button the elements that you have selected will vanish and be replaced by a rollup consolidation named something like
}ROLLUP_ELEM_001. That will have a [+] sign next to it indicating that you can click to expand it into the individual elements.
I think that there may be a slight bug in 9.5.1, though it doesn't affect what I've described above. If you re-enter the Subset Editor, you can click on the [+] to expand the rollup into the individual elements
but it refuses to show the element aliases. It's fine if you click on the [+] next to the roll-up in Cube Viewer, it's only Subset Editor that's affected. (Tested with Plan_Report in Planning Sample, "LY 2004 Actuals" view, plan_business_unit dimension.) Can anyone else confirm this? I rarely use roll-ups so I don't know how long this potential bug might have been around for.
