In SAP Analytics Cloud (SAC) users can choose to maintain versions of their data if desired. To get the most out of the versioning capability, one should be familiar with the concept of public and private versions in SAC. Hence here, in a 2-part series blog, is a list of FAQs to help clarify some of the uncertainties.
In this part 1 the FAQs will answer the following common basic questions:
Q: How do I create public and private versions?
A: A public version comes as a default upon creation of a SAC model. Upon import from a data source user can also specify the nature of the version to be public.
Additional versions, regardless public or private, cannot be created in the model but via the version management panel instead.
To create a private version, simply copy an existing version. It is possible to constraint the scope of the copy by limiting the data to a desired filtered context, the defined planning area, or only visible data in the table. You could also copy the entire version or no data at all, but usually a filtered private version is a good starting point.
Creating a new public version follows the same procedure, meaning you basically create first a private copy of an existing public version. The only difference is that at the end you click on “publish as” to create a new public version with the data.
Q: How do I start editing a public version? And what is meant with the public edit mode?
A: There is no special preparation needed for simple data entry in a public version – you just go ahead and click on the desired cell to do your entry. You will automatically be led into the public edit mode. (Alternatively, you can also trigger the edit mode in the version management panel for the desired version). When done, there are several ways to exit the edit mode and publish your results, depending on how your IT has configured your interface for you – here the instructions from the IT should serve as guidance (see also question below, “Do I need to save my changes?”).
Technically, the public edit mode is a snapshot of the data and lock state from the public version to enable planning. This ensures that multiple users working simultaneously on the same public version do not face the problem of cross interference in their data entry or the subsequent calculations/data copy. This is also the reason why triggering a data action will also activate the edit mode – for undisturbed operation within the individual snapshot before publishing.
If the version name is present in your table headers, you can see a “*” next to the name of your version, signifying that you are working within your own snapshot, i.e. in the edit mode.
Q: If I make a private copy from the public version, how can I see which data is locked?
The lock state information will also appear in your private version.
Q: Do I need to save my data changes? I’m afraid that I will lose them when I log out.
If you are working with the public version, your changes are stored in an edit mode until you choose to publish them. Publishing will merge your changes with the public version and remove the edit mode you have been working with. This is similar to working with private versions, except that you can share private versions with colleagues, but not your edit mode changes.
Note that only valid changes (according to data access control, data locks and validation rules) will be published. Invalid changes will be discarded along with the private version/public edit mode. More details on how this works together with data action can be found in part 2 of the FAQ series.
Q: Is every change immediately visible for everyone in the public version?
As mentioned above, your changes are stored in an edit mode until you choose to publish them.
It is an isolated snapshot of the public version created for you to enable your planning.
Q: Wouldn’t everyone be overwriting each other’s public edit mode changes?
Your public edit mode changes are your own, visible and editable only by you.
Q: Sometimes a cell appears input-enabled in a public version for me, but when I try to edit it, it changes into non-editable state. Why?
A: One of the reasons could be that a recommended planning area for the model has been setup, which only kicks in when you start planning, with the aim to optimize the size of your public edit mode snapshot. The boundary of the planning area will determine what is plannable, what not, and display the corresponding data as such. Hence, sometimes you might notice a difference in the editability of certain data before and after you have started your edit.
Q: Do I see my colleagues changes immediately in the public version?
Even after your colleagues have published their results, the latest data changes in the public version are only visible if you (a) refresh your browser, or (b) trigger a data refresh from the toolbar.
Some planning interactions, such as publishing data or submit a calendar task will also automate a refresh and display the latest numbers. Your IT could also configure certain data actions or use an analytic application to trigger implicit refresh behind the buttons.
As a rule of thumb – simply trigger the data refresh in toolbar to view the latest public numbers, if uncertain about the actuality. Doing so will not overwrite the unpublished changes you have done for the same version, as your changes are stored in the edit mode.
Q: How do I know which data has been changed in my version?
A: Data changes are visible in three areas:
- Cell Highlight:
- Single data entry mode: After each data entry, the affected cells are highlighted, but only changes between the latest entry and the one before.
- Fluid data entry mode: During quick succession of data entries, affected cells are not immediately visible. Only when an entry pause is detected, all entries are batch processed and highlighted.
- Mass data entry mode: Changes are only highlighted when “process data” is triggered
- Version History Panel:
- Data entries within a private version are visible within a version history and could be rolled back to a desired point. All entries between the creation and publishing of the version are listed. Once published, this list will be discarded along with the private version. This holds true also for the public version edit mode.
- Data Audit/changes:
- Once enabled under the model preferences, all data changes within a model will be logged in the data audit, with the corresponding delta value.
Q: How do I know the size of my versions? Or any other details?
A: Go to the version management panel and select “Details” from the dropdown menu of your selected version.
The version detail panel will open and display overview information such as version size, access rights and creation date.
Q: Can everyone publish everything into a public version?
When you trigger a version publish, several security checks will kick in and only data that has passed all criteria will be merged into the public version. These checks include data locks and validation rules, among others.
Note that even though while planning you could choose to ignore data locks, this is only to enable simulation and private planning. Once publish is triggered, invalid data made to locked slices will be discarded. More details on publishing will be given in part 2 of this blog, which will also answer questions relevant for administrators and power user scenarios, including how versions work regarding security checks, data action processing, and size monitoring.