SAP Analytics Cloud Active/Inactive Versions

[MichaelWilk]

Hi, we are using the SAC Content Model VERSION_STATISTICS_BASE to monitor current Public Edit Versions.

There is a Dimension called "Current State" and we do not understand the difference between the following states

- active

- invactive

Can someone explain it?

Thank you!

[PRAT280]

Hi,

When you have an public version which is in "Edit Mode" or unpublished data sitting in your public version is categorized as "Inactive Version". Once the data is published, it moves to "Active"

I hope this helps

[MichaelWilk]

Hi Pratyush,

Thank you for your response, but it is incorrect. I tested it just a few moments ago:

When the user begins editing the data, a Public Edit Version with the "Active" status is generated within the VERSION_STATISTICS_BASE Model. Publishing the changes will eliminate the Public Edit Version from the VERSION_STATISTICS_BASE Model. However, if the version is not published, the Public Edit Version's status will change to "Inactive" after a certain period of time. The question is why and when this change occurs!

Appreciate your attention to this matter.

Best regards,

Michael

[poornasac]

Hi

I understand that you're still unsure about how and when the system decides to change the status from "active" to "inactive" in SAP Analytics Cloud. When it comes to editing the data again, here's what happens:

When you start making changes after a version becomes inactive, the system usually creates a new active version. This means that you'll have a fresh version to work with while keeping the inactive version as a reference. The changes you make will be recorded in the new active version, allowing you to compare and analyze the data between different versions.

However, it's important to note that the exact behavior can vary depending on how your system is set up. To get a clear understanding of what will happen in your specific case, I recommend reaching out to your system administrator or documentation. They will be able to provide you information on whether a new active version will be created or if the inactive version will become active again based on the system's configuration.

Thank you

[MichaelWilk]

Hi Poorna,

Thank you again for your response. Actually we are administrating a SAC instance for a customer, and since there is no documentation available regarding the version status, we thought it would be best to inquire here. The first part of the previous question, which remains unclear, is actually important for us: When does an active version transition to an inactive state?

Additionally, we have been unable to locate any system configuration settings related to the active/inactive status.

Thank you for your assistance.

Best regards,

Michael

[MichaelWilk]

Hi Poorna,

we are still unclear about how or when the system decides to change the status from "active" to "inactive". Do you have any documentation regarding this topic?

Thank you in advance!

Br,

Michael

[MichaelWilk]

...so nobody in the SAP World/Community is able to answert this question?

[poornasac]

Hi

In the SAP Analytics Cloud Content Model, the "Current State" dimension helps you understand the different statuses of versions. Here's a explanation

"Current State" dimension provides information about the state or status of each version of your content. When a version is labeled as "active," it means it is currently in use and represents the most up-to-date version. It's like the version you're currently working on, where you can make changes and updates.

On the other hand, an "inactive" version is not the most recent one. It represents a previous state or a snapshot of your content that you saved or published earlier. Inactive versions are read-only, meaning you can't directly modify them. They serve as reference points to see how the content looked at a specific point in time.

To summarize, the "Current State" dimension helps you distinguish between the active version (the one you're currently working on) and the inactive versions (previous versions saved for reference). It tells you whether a version is the latest or represents a previous state of your content.

Thanks

Poorna

[MichaelWilk]

Hi Poorna,

Thank you very much for the detailed answer! We now understand that when a user starts editing data, a Public Edit Version with the status "active" is created.

However, we are still unclear about how or when the system decides to change the status from "active" to "inactive." Additionally, we are curious about what happens when the user starts editing the data again. Will another active version be created and the inactive version remains, or will the inactive version become active again?

Thank you in advance for your clarification.

Best regards,

Michael

[mfoeken]

Dear community members,

I'm having a slightly different but related question: how can you delete inactive versions? At a particular customer I have a model that has 3 inactive versions, from 3 different users. They date back to March, April and May 2024 and contain up to 1.9 billion rows of data according to the 'Private Versions Statistics and Analysis' story.

Thanks for your replies in advance!

Kind regards,
Martijn van Foeken | Interdobs

[JefB]

Hi Martijn, I'm afraid only on model level (settings > delete private versions) you can delete (all) other user's private versions that are still not published/deleted by themselves. These are labelled 'inactive' once they are unloaded from RAM memory during a SAC background process at night.

[mfoeken]

Thanks Jef! What I have noticed is that these inactive versions can't be managed via the versions panel. If the user adds the model to a table and checks the versions, they don't display as private versions. I have submitted an incident on the SAP Support Portal as well to get some more clarity. If anything useful comes out of that, I will share it here as well.