Cannot save results using DATA ()

[MasterBudget]

Hello,

Strangely, I cannot save data in the model using advanced formula.

In Tracing panel, there are Lookup results for Variable Member, but nothing for the first DATA().

CONFIG.TIME_HIERARCHY = CALENDARYEAR

CONFIG.GENERATE_UNBOOKED_DATA = ON

MEMBERSET [d/Measures] = "Plan"

MEMBERSET [d/RED_WBS3] = %WBS3member%

MEMBERSET [d/Date] = %DateFrom% TO %DateTo%

VARIABLEMEMBER #TRACING0 OF [d/Measures]

// Does not work

DATA([d/Measures] = "Plan",

[d/RED_ContractSituation] = [d/RED_WBS3].[p/ContractSituation],

[d/RED_Account] = [d/RED_WBS3].[p/Account],

[d/RED_Audit] = "Input") = 1

// Works fine

DATA([d/Measures] = #TRACING0,

[d/RED_ContractSituation] = [d/RED_WBS3].[p/ContractSituation],

[d/RED_Account] = [d/RED_WBS3].[p/Account],

[d/RED_Audit] = "Input") = 1

Why is it fine on the second tracepoint, but does not work at the first DATA() function?

I will appreciate your answers.

Best regards,

Oleksandr

[N1kh1l · Accepted solution]

Oleksandr

The tracing in SAC works differently for #Variable members and actual members. Variable members are temporary and vanish after script execution. The trace shows variable members in DATA() under the lookup area but the Actual members in DATA() can be visualized by creating a table to see the results. So #variable members provide a easy and better way to visualize the trace records generated by DATA(). Your first set of DATA() statements is also working fine and is posting the results in a private trace version which you can set up the table and see results but variable members is quicker as its handled in LOOKUP area. Refer to the below blog to understand the difference. Refer to the section Variable member tracing and navigating Trace results in below blog.

https://community.sap.com/t5/technology-blogs-by-sap/introduction-to-data-action-tracing/ba-p/135650...

Br.

Nikhil

[MasterBudget · Accepted solution]

Thank you Nikhil!