Skip to Content
author's profile photo Former Member
Former Member

BPC Reporting advise


We have came accross one of requirement and need input. We have one dimension "CostCentre" and having property as "Entity". Input schedule is having user selection as costcentre. Entity is in page axis and is being derived from cost center property. When user select cost centre respective entity flow in page axis.

Now we are having Data access profile based on cost centre and entity. Now we have saved the template on a particular costcentre (assume it belongs to entity C1000 so C1000 would be defaulted in page axis while the template is saved.

Now let's assume we have a DAP which has access to entity 1010 only, when he opens the template, it throws an error saying 'Cannot read entity C1000 and will be removed from page axis'.

A possible solution is to create NO_ENTITY and maintain this against NO_COSTCTR member and default all templates on NO_COSTCTR while saving them and let all DAP have read access to NO_ENTITY.

But, we don't want to go that route as entity is also used in consolidation and we don't want to disturb that. Is there any better way of designing the template to cater to this issue or any other alternative solution, please advise.


Add comment
10|10000 characters needed characters exceeded

0 Answers