The goal of this blog is to explain how to keep the private version of a planning model to which predictive forecasts were generated. Predictive forecasts are generated from historical data contained in the planning model, and are written back to a private version of this planning model. To retrieve those forecasts in a public version, the planner must publish the private version. A side effect of the publication is the deletion of the private version once it is copied to a public version. So, if planners want to revisit the predictive settings to get better forecasts, they have to restart from the beginning. There is a simple way to avoid this rework, as you can see from the figure below.
Private Version}
There is a new step before the publication of the private version. It involves the creation of a copy of the private version. It is this duplicated private version that will be published as a public version, and then deleted. The original private version is then still available to store new forecasts. So, the planner could go back to the first private version if needed.
Hi Thierry, upon publishing a private version to a public version, how does SAC decide which data range to override? And how can we influence that? For example: not to override any manually planned forecast data in public version.
When publishing a private version back to the public version it was copied from, the system only updates values that were actually changed in the private version. If nothing was changed in the private version then nothing will be updated in the public version. It is with this mechanism that predictive forecasts saved in the private version have been published to the public version which at the end contains historical data and predicted values for 2020. This is the default behavior.
Now there is a way to have more control. It is to enable Data Access Control for a dimension in the planning model. It restricts in the public version the data you can change by assigning read/write or only read permission. In your private version you can do any change you want, but changes on dimensions which have only read access in the public version will not be reported during the publication. You will find more details in the help about how to set Data Access Control.
The answer depends on where you do human-driven forecasts. Suppose you have historical data until 2018 and you do human-driven forecasts for 2019, but request help for the forecasts of 2020. The attached document explains how to preserve in your public version your human-driven forecasts for 2019 and get the forecasts for 2020 coming from Predictive Planning.
Analytics\\nApplication Designer provides standard widgets to fulfil your requirement. You can place the button on the left of the story (if needed).Use version management API-Hope this helps.Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).Thanks,Debjit\",\"author\":\"username\":\"debjit.singha\",\"displayName\":\"Debjit Singha\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":13195259,\"posted\":1605797938000,\"votes\":7,\"isAccepted\":true,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":7,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"accepted\":true,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[\"id\":1866499,\"fileName\":\"1.jpg\",\"size\":\"31.4 kB\",\"url\":\"/storage/attachments/1866499-1.jpg\",\"isImage\":true,\"id\":1866500,\"fileName\":\"2.jpg\",\"size\":\"28.5 kB\",\"url\":\"/storage/attachments/1866500-2.jpg\",\"isImage\":true,\"id\":1866501,\"fileName\":\"3.jpg\",\"size\":\"25.9 kB\",\"url\":\"/storage/attachments/1866501-3.jpg\",\"isImage\":true,\"id\":1866502,\"fileName\":\"4.jpg\",\"size\":\"27.2 kB\",\"url\":\"/storage/attachments/1866502-4.jpg\",\"isImage\":true,\"id\":1866503,\"fileName\":\"5.jpg\",\"size\":\"43.6 kB\",\"url\":\"/storage/attachments/1866503-5.jpg\",\"isImage\":true]},\"body\":\"Hi Badri Narayana Bhaskaruni, If you planning on an implicit private version, you can publish data automatically after data action is executed. Youn can set the check box in 'Follow up action' in the data action trigger panel as below. Best regards, William \",\"author\":\"username\":\"william.yu\",\"displayName\":\"William Yu\",\"groupIcons\":[\"name\":\"topic-expert\",\"title\":\"This user is a Topic Expert\",\"priority\":19,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":13195220,\"posted\":1605791289000,\"votes\":2,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":2,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[\"id\":1866494,\"fileName\":\"data-action.jpg\",\"size\":\"7.3 kB\",\"url\":\"/storage/attachments/1866494-data-action.jpg\",\"isImage\":true]]"), answerForm: formAction: "/answers/13192193/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/13192193/answers.rss', answersAndComments: '/feed/13192193/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true }) })(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Badri Narayana Bhaskaruni Nov 19, 2020 at 07:30 AM Publishing a Private version to a Public version through Data Action Advanced formulas 586 Views Follow RSS Feed Hello Team,
I am working on SAC planning story where I would need to publish the data from a Private version to a Public version. I know there is a way to do this manually through an option "Version Management" with in the story. I would like to know if this is possible dynamically by clicking a button: data action trigger (through data action / advanced formula written in the data action) in the story.
I did not see any possibility to use Prompt for Version for an Advance Formula Data Action.\\nIt is very tricky to handle the Version in Advanced formula Data Action. It is not possible to use Version in Memberset , Data , Foreach statements.\",\"author\":\"username\":\"kp_a\",\"displayName\":\"KRISHNA PRASAD ALLA\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"suvendu.maharana\",\"displayName\":\"Suvendu Maharana\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":13552338,\"creationDate\":1639750556000,\"activeRevisionId\":14022360,\"lastActivity\":1639750556000,\"parentId\":13512442,\"originalParentId\":13065010,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]}}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 13065010, plug: "copying-data-from-a-private-version-to-a-public-ve", votes: 0, questionTitle: "Copying data from a private version to a public version", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: false , childToViewInfo: id: "" , comments: JSON.parse("\"13512442\":\"rootParentId\":13512442,\"commentsCount\":1,\"comments\":[\"body\":\"I did not see any possibility to use Prompt for Version for an Advance Formula Data Action.\\nIt is very tricky to handle the Version in Advanced formula Data Action. It is not possible to use Version in Memberset , Data , Foreach statements.\",\"author\":\"username\":\"kp_a\",\"displayName\":\"KRISHNA PRASAD ALLA\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"suvendu.maharana\",\"displayName\":\"Suvendu Maharana\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":13552338,\"creationDate\":1639750556000,\"activeRevisionId\":14022360,\"lastActivity\":1639750556000,\"parentId\":13512442,\"originalParentId\":13065010,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 3, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"thought the same... but got disappointed when I couldn't see it in the menu...\",\"author\":\"username\":\"saringler\",\"displayName\":\"Aron Ringler\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":13065050,\"posted\":1591795207000,\"votes\":2,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":2,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"I think it should be possible to select private version as source version for copy action. \",\"author\":\"username\":\"william.yu\",\"displayName\":\"William Yu\",\"groupIcons\":[\"name\":\"topic-expert\",\"title\":\"This user is a Topic Expert\",\"priority\":19,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":13069125,\"posted\":1591787834000,\"votes\":1,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hello Aron, \\nJust go with the Advance Formula Scripts. Write the copy logic with proper scoping using "MEMBERSET". Take the "Private Version" as an input using "parameter". Then assign (=) the private version, to the public version.\\nE.g. \\n1. Scope all the dimensions in the MEMBERSET\\n2. Take the private version in input using "Parameter" - eg : %Private_Version%\\n3. Script for copying private version to Public Version \\nDATA ( [d/account], [d/units].....Other Dimension members) = RESULTLOOKUP ( [d/version] = %Private_Version%,[d/account], [d/unit]..........)\\nThanks,Suvendu\",\"author\":\"username\":\"suvendu.maharana\",\"displayName\":\"Suvendu Maharana\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":13512442,\"posted\":1635418803000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/13065010/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/13065010/answers.rss', answersAndComments: '/feed/13065010/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Aron Ringler Jun 10, 2020 at 09:20 AM Copying data from a private version to a public version 298 Views Follow RSS Feed Is it possible to copy data from a private version to a public version, without the need to delete the public version first and then publish the private version with the same name as the deleted public version? 2ff7e9595c