Time restricted measures and calculating deltas in SAC Analytic Apps

[former_member784501]

Hi!

Is there a way to have date restricted measures and comparisons (for example market share of product XY in Nov 21 and Nov 20 -> delta comparison) in analytic apps, where the end user is able to select the time period?

In stories, you can create a current date input control (see this blog: Date Calculations in SAP Analytics Cloud using Custom Date | SAP Blogs). This let's you easily calculate custom date-based measures and offset measures. Unfortunately, this seems not to be possible in analytic apps.

Simple date filters unfortunately didn't work, because comparisons over time are not possible then. (for example: User selects Nov 21 -> Nov 20 data is not available).

I also tried to build custom dropdown menus, but unfortunately I didn't find a way/it seems to be impossible to manipulate the date restriction of the restricted measures via scripting.

Does someone have a solution or an idea?

Thanks in advance!

Sincerely,

Dario

[sveabecker]

Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Regards, Svea

SAP Community Global Moderator

[former_member227719]

Hi Dario Martic,

Were you able to find a solution/work around to this? I'm having the same exact problem for creating MTD/YTD features in Analytic apps for custom period.

Thanks and Regards

Prerana

[William_Yu · Accepted solution]

Hi dmrtc,

How you define the offset in story with input control? If the offset is fixed, you can create a restricted measure(s) to do the offset, and a separate measure to calculate the difference.

Best regards, William

[former_member784501 · Accepted solution]

Hi William Yu,

the offset is fixed, but unfortunately I cannot link the offset to the month and year that was selected by the user in analytic apps.

Maybe a concrete example of what I want to achieve:

In the end, I want to have a simple table with products in rows and sales quantity of the selected month and year (f.e. Nov 21) in a column as well as the selected month in the previous year (-> Nov 20) in a second column.

Now, if the user selects January 2022, the table should show January 2022 and January 2021 sales quantity of each product.

In stories, I just created a "current date input control" and set it as Current Date for the restricted measure, so it is always offset by 12 months of the month and year the user has selected.

This isn't possible in analytic apps. Is there another way to mimic this behaviour/achieve my goal?

Thanks!

[William_Yu · Accepted solution]

Hi dmrtc,

Actually the solution to this can be applied to both Analytics designer app and story.

• Instead of using a current date input control, you simply let user select one month from standard input control on time dimension.
• In the table, you display the default measure
• then you create a restricted measure on time dimension by using 'navigation' -> 'previous year'.

So with your example, user select 2021.Nov, and the restricted measure column show automatically 2020.Nov.

Best regards, William

[former_member784501 · Accepted solution]

Hi William,

It seems like I can't follow you on the third point.

Like you said, I created a standard input control and a table with a default measure (in my case, market share).

If I want to create a restricted measure on time dimension, the following happens:

The restricted measure will do all restrictions based on the actual date and not based on the selected month and year. It won't change dynamically if the user selects month and year.

Could you specify the third point, if I didn't understand something correctly?

Thanks a lot!

Sincerely,

Dario

[William_Yu · Accepted solution]

Hi dmrtc,

Not sure what model(acquired or live) you are using, but anyway you should have option under navigation.

Best regards, William

[former_member784501 · Accepted solution]

Hi william.yu,

Yes, apparently live-models in analytic apps are somewhat restricted in my organisation or in some regards also generally.

Do you know if there will be updates regarding the functionality with live models in analytic apps?

I tried it with a flat file-model, now I can see the navigation.

Thank you very much!

Sincerely, Dario

[William_Yu · Accepted solution]

Yeah, there is plan to enhance time based restricted measure calculation. But there is no detail timeline yet.