Write Access and Submit Access for Two hierarchy in an app
Posted: Mon Oct 06, 2014 8:10 pm
Hello All
In our responsibility application, we have 3 cubes. 2 cubes have metro level (metrohierarchy) which is a approval dimension.
in cube 3, the city level hierarchy is being used along with metros (detail level hierarchy)
Issue:
When user submit for the node, User wont be able to take ownership in first 2 cube. This behaviour is normal. In 3rd cube, users are able to write which is also as expected but they are not able to submit their data at city level. it (cube 3) doesn't have approval dimension. We want user to do their forecast at city level all time eventhough the metro level submission is locked.
Does it have possible solution? What is it, if any?
What i tried:
As user couldn't able to submit or commit the data once they have submitted the data after we locked those from top node. I tried to reset the application and write a rule in cell security cube to make that cube read for most of the metro (not all) user. These action had made 2 cubes read only but in third cube what we write is not going to submit or commit eventhough option for same availble on above option panel
I am still looking in to it. If anyone has experienced it this or similar of this issue, it would help a lot with your directions.
Thanks
Dharav Patel
In our responsibility application, we have 3 cubes. 2 cubes have metro level (metrohierarchy) which is a approval dimension.
in cube 3, the city level hierarchy is being used along with metros (detail level hierarchy)
Issue:
When user submit for the node, User wont be able to take ownership in first 2 cube. This behaviour is normal. In 3rd cube, users are able to write which is also as expected but they are not able to submit their data at city level. it (cube 3) doesn't have approval dimension. We want user to do their forecast at city level all time eventhough the metro level submission is locked.
Does it have possible solution? What is it, if any?
What i tried:
As user couldn't able to submit or commit the data once they have submitted the data after we locked those from top node. I tried to reset the application and write a rule in cell security cube to make that cube read for most of the metro (not all) user. These action had made 2 cubes read only but in third cube what we write is not going to submit or commit eventhough option for same availble on above option panel
I am still looking in to it. If anyone has experienced it this or similar of this issue, it would help a lot with your directions.
Thanks
Dharav Patel