Locking the cube

­­General Discussions
1

Hi All,

There is 3 Global Administrator in our Prophix team. I’m having question how I can restrict one of the Global Administrator from accessing the selected cubs. Is there some option which can restrict the Global administrator not to change in identified cubes.

Second question, How I can insert the Total function in Prophix report. (As per attached image)

Regards

Prophix image

2

Hi Imran,

You can take away access for a cube in Security manager, but the better way would be give him Advance user access with all functionality and remove access for the desired cube.

Regarding the Total, there are two ways.

  1. Add a ALL line after the blank space, which will total the lines
    e.g.

Revenue.LeafDescendents
Blank
Revenue

other way would be use Excel Sum but for that you should include a blank space above and below the lines you want total, so it will calculate correctly.

e.g. lets assume your numbers are on column d5
make sure D4 and D6 are blank line
on D7 use formula Sum(D4:D6)

Hope that helps.

Regards,

Ali Arsalan

3

Thanks Arsalan,

Your feedback is really helpful. Can you tell me what is the different between Administrator and Advance user. I mean with setup as Advance user, which function is restricted?

4

Hi,

By default if click role as Advance, following/similar functions would be taken out.

image

This will take away Security Manager access where you assign cubes(read/write access).

You can give selective option to his User if needed to give him more access. if you want to give him Admin rights on certain cube, you can select following Model access, which will give him Model Manager access to cube.

image

I hope this is helpful.

Regards,

5

Thanks Arsalan,

Much appreciated. Regards

6

@ali.arsalan.1 , you’re amazing! Thanks for always helping others out :heart: