Skip to Content
avatar image
Former Member

How to ensure sheet options are tied to file and not user?

Hi All,

I'm brand new to BPC.

I recently constructed a report (multiple reports on multiple sheets) that will be shared amongst and used by several users on different machines. It seems like the Sheet Options is dependent on the individual person, and not the report. For example, I had a custom expansion defined, but on someone else's machine there was a different expansion option selected for the same file. The report expanded correctly on my machine, but not theirs.

Is there a way I can tie the sheet options/user options to the report so that it remains consistent for all users?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 29, 2016 at 12:25 PM

    There are 3 types of options:

    Report options - for the particular report (can be inherited from sheet options) (saved with file)

    Sheet options - for the particular sheet (saved with file)

    User options - not saved in the file, user specific!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2016 at 12:46 PM

    Sorry, but "inherit sheet options" has no relation to you case!

    If you are talking about:

    Then it's a sheet option - affecting all reports on the particular sheet. It is saved with the file - just test :)

    Add comment
    10|10000 characters needed characters exceeded