[SAC] Values ​​using the formula RESTRICT cannot be displayed in the nodes of the value driver tree.

[keita]

The following formula is not displayed in the nodes of the SAC value driver tree, so I would like to display it. ↓Formula that shows the value of R300000 (net assets) for the previous month
[RESTRICT([R300000], [d/YearMonth]=Previous("Month", 1))]
This formula is defined in the account dimension table of the model.

Set the above account in the Account section of the story

No value appears in the node (- is displayed) and it cannot be used for calculations, so If anyone knows, please let me know. Thank you in advance.

[thomas_beck]

Hi @keita 
This should work however the VDT has to show the proper granularity (in your case month). In case the VDT does lead to an unexpected result it sometimes helps to create the same layout using a Table.
If you configure your VDT as follows, you should be able to see the values of your restricted account on month granularity as well:

This might be unexpected as it does not show on quarter or year level any values for your restricted account. Please check the Table in the sample above which shows similar results.

[keita]

Thank you for your answer, Tomas. I'm very happy to know that it's possible. However, I can't set it up as shown in the image. I'd like to know more about VDT settings. 〇I was successful in displaying it in a table. 〇How did you set the Restrict A node in the lower left of the image? I'd like to know more about it. Did you set the formula you defined in the modeler in the story build tab? Or is it possible to create a VDT from a table?

[thomas_beck]

You can add a new VDT-Widget to the story and then simply use the Auto-Create feature and select the relevant accounts. This should also bring in your restricted account. More info on VDT creation is available here: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/f6189755175940f3a4e00...