Skip to Content
1

SAP SAC Planning Features

Apr 04 at 01:37 PM

141

avatar image

I had few questions as below on the Planning side in - SAP SAC release. Would be great if I could get some light on that.

1) Can we write data between multiple planning models. as I heard that calculations are on the fly and cannot be saved to the database.

For example I would want to calculate some custom calculations like local member calculations / Calculated Measure and then save the Calculated measure output in model "A". Now I want to use that saved value in another Model B and build another Calculated Measure using the previous Calculated measure stored a get a new Column and write the output of the new Calculated measure in Model B.

2) Can we create input templates into the model, like blank templates to input data when there is no data in the model for SAC?

3) What is the Maximum GB size of data a Planning Model can hold in SAP SAC?

4) Can we call ABAP BADI / Write any calculations like Script logic ( using Loops , do else while etc... in SAP SAC)

5) Do we have any Data Archiving Mechanism in SAP SAC?

10 |10000 characters needed characters left characters exceeded

Here is good example of the formula linking feature:

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/c921b1cb94d146e6abd996286d0e0bf7.html

We can also blend data from different models as well.

See Link models in a story based on a shared dimension:

https://www.youtube.com/watch?v=oVfkZR7Zl7c&feature=youtu.be

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Daniel Spokoinyi Apr 04 at 03:39 PM
2

Hi Shankar,

I guess you need to look at SAC more as a Cloud tool, which works different to on premise tools. it is based on a HANA database, where you can either load data (for planning models this is what you do), and you could then also push data down into BPC if you want to.

To answer some of the questions from my experience.

1. I believe that the only way you could do it is by using linked models, and then do this. Alternatively, this would work when working with a Grid page.

2. yes, this is possible.

3. I believe the limitation is the space availlable for you in SAC (according to your subsciption). you do have some data volume constraints, a good overview you can find here: https://wiki.scn.sap.com/wiki/display/BOC/SAP+Analytics+Cloud+Connectivity+Guidelines

4. This has to be done in the back end, not the frond end, and then imported into SAC.

5. It's a HANA database tool, so the whole concept of archiving is different.


I hope this helps. Daniel

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Daniel,

Again some clarifications on the questions -

1 - Are you sure if we can write data to different cubes..?? because we have tried doing the model linking and what we could do is only to lookup the values of another model. Like reporting the actual data from another model into the planning report. Can you confirm we can write the data into a linked model report..?

Moreover, is there is a way of moving the data between the models? E.g - Doing allocations, driver calculation in a separate model and pulling in the final numbers to the finance model.

3 - The link given given here says that for planning model the capacity of data acquiring is - 250,000 dimension members. Is just a limit of acquiring the data in a run or the capacity of the planning cube..??

4 - Thanks, but we are more of evaluating SAC as a standalone planning tool. :-)

Thanks,

0

Hi Daniel. Hope you are well.

Could you please elaborate your answer for question 2?

I tried to use tables and grids to create an input layout.

Without data I was impossible even to create a table layout. After loading draft data, I was able to create the table but it does not allow to append new lines. For example, I didn't find a way to insert May,17 on this table:

Regarding grids, it is not ease to grasp how can I connect a layout there with my model.

Hope you can elucidate this doubt.

Thanks and regards.

Paulo.

1
Shankar Goutam Ayapilla Apr 16 at 12:01 PM
0

Thank you for the responses Dan and John. I was able to link dimensions from various models , but I think you will not be able to save data to the database , in case you are using any calculation using the Cross calculation ( calculated measure).

For example I want to get a variance of Actual vs plan in a Grid view . (I understand the variance is now possible as a chart in when taken as a Responsive page.) But i am not able to build the same comparison as we used to do in BPC (using local member calculation). The local member calculation was then referenced to another member and sent to DB using EPM send functionality .

I was looking for some similar functionality like that.

One other challenge I noticed is the comments feature. The comments are wonderful in SAP SAC when we use the members, how ever they get disabled when any calculations or any Restricted measure are in place. Also if we export the data to the system, we are not able to see where the comments are stored.

Share
10 |10000 characters needed characters left characters exceeded