Cube totals

  • Hello all.

    I have a financial cube. All is fine now, but as the cube has been making popular here at the company, more "unprivileged" users want/need to see it.

    Since I've seen the options to able/disable dimensions in Role Managemet screen in AS Manager; i've tested it.

    It works fine, dimensions disallowed aren't displayed... but cube totals are the same. For example if the total cube has $1,000,000 and the only dimension allowed for this user has $20,000. His cube navigation will display only that $20,000, but the last line (total summary) still displays $1,000,000

    I don't want they to be able to see that number, and not using totals is not an option.

    Do you know why this happens, and how to fix it? I'm using web Pivot Tables (OWC) as frontend

    Thanks

  • You should be able to do this, try the following:

    1. go to the custom dimension settings in your role, there should be 3 tabs

    2. go to the 'Common' tab

    3. Set the Visual Totals radio button set to 'Show Visual Totals'

    Steve

    Steve.

  • Sensei Steve!

    Is exactly what I needed... Thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply