Multiple Selection in SAC Account Input Control

[former_member1333328]

Dear SAC Expert,

I created a SAC planning model in "New Model" which has account dimension and measure.

Need your help on the below:

1. Can we have multiple selection in account input control? My requirement is user wanted to have flexibility to select drivers available in the model in their widget. I have account dimension called driver that has 30 members and users don't want to show all the drivers in story. I tried to create account input control, but it only allow me to select single driver only.

2. I can't add cross calculation into my story. the option to select cross calculation is missing. Is this a limitation for new model with account dimension can't have cross calculation?

Thank you.

Regards,

Jack

[moshenaveh]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[PRAT280]

Hello,

With Optimized Designed Experience( with Q12023 Rel), you can now combine the classic and analytical features in SAC. For your requirement, you can create a checkbox group for Account members and add a logic to filter the table as per checkbox selection. For scripting logic, please refer below blog

How to use Checkbox and Dropdown features in Analytic Designer | SAP Blogs

I hope this helps.

[N1kh1l]

teljack

teljackYes you can select multiple values as possible selection in Account control but user selection will be restricted to one value. For Example I can have Net Income, Balance Sheet, KPI etc. as possible values and user can select one of it. Group your KPI's under one or more hierarchy nodes if you want them to select more KPI's. User can select the node and expand the KPI selection. In below example Balance Sheet is selected and all accounts below Balance Sheet Nodes are available. Account Input control does not allow multiple selection.

Cross Calculations are not possible in New Measure Model.

Hope this helps !!

Please upvote/accept if this helps you

Nikhil

[sandip_kumar003]

Hi,

You can do multiple selections, you just need to add a checkbox group and have to write a script for that.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/a17ef3c8fa6c406a969d1...

Best Regards,

Sandip Kumar.

[William_Yu]

you may vote this customer influence item: https://influence.sap.com/sap/ino/#/idea/278748

[UmaArjunan]

Hi William, We have already voted for having this customer influence feature , May i know when is the plan date of having this feature in SAC?

Thanks in Advance

[William_Yu]

I don't have a timeline yet, but we are working on it.