Skip to Content
0

BPC Reporting advise

Feb 16, 2017 at 02:08 AM

41

avatar image

Hi,

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.

Regards,

10 |10000 characters needed characters left characters exceeded

Can you share your report screenshot?

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers