Forum Discussion

Rohit_Malani's avatar
Rohit_Malani
New Contributor
3 years ago

How to clear data on specific intersection?

Hello, We need to clear data on the specific intersections of Account, Entity, UD2, UD3, and UD5 members (all members from the remaining dimensions). The data is copied from the Actual to the Forec...
Finance
  • Henning's avatar
    Henning
    3 years ago

    Hi, did you try using IntelliSense and follow as indicated? In your case it would look something like this:

    api.Data.ClearCalculatedData(True,False,False,False,"A#7041","F#Base","O#Import",,,"U2#13056","U3#327",,"U5#01973")

    You put all your dimension filters into the account filter, which is why it only recognizes the account in your case. Also, since you are only looking to clear calculated data, I set the other parameters to False (clear translated data, clear consolidated data, clear durable calculated data).

Henning's avatar
Henning
Valued Contributor II

Hi, did you try using IntelliSense and follow as indicated? In your case it would look something like this:

api.Data.ClearCalculatedData(True,False,False,False,"A#7041","F#Base","O#Import",,,"U2#13056","U3#327",,"U5#01973")

You put all your dimension filters into the account filter, which is why it only recognizes the account in your case. Also, since you are only looking to clear calculated data, I set the other parameters to False (clear translated data, clear consolidated data, clear durable calculated data).

Rohit_Malani's avatar
Rohit_Malani
New Contributor
3 years ago

This worked. Thank you, Henning!