Hello All,
I have a Business Unit dimension to which element level security is applied and logic is applied in such a way if for any consolidation all the child element are accessible then only consolidation level would be available to user.
Now the issue in report level whenever i run the report to generate report each dimension should have a at least one default element to create a cube view. and here user don't have access to group level or Total Level element to be applied in slicer if this dimension is not required in report layout. without this report is giving blank output.
Anyone have idea what could be the alternate solution to resolve this issue. Let me know if issue is not clear enough.
Thanks,
Sumeet
------------------------------
sumeet yadav
------------------------------