cancel
Showing results for 
Search instead for 
Did you mean: 

Copying calculated measure to measure

ahfadoo
Participant
0 Kudos

Hello, I am trying to copy a calculated measure into another measure using data actions and when I attempt to the values are not coming in correctly. 

ahfadoo_0-1707132111145.png

this is the error we are getting and I believe this is what is causing the issue. Is there any solution to this or perhaps any other method to bring a calculated measure into a measure? 

Any help at all would be great! Thank you.

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor

ahfadoo

may be first you should try this on a limited data scope. For e.g. try to copy for 1 entity/ 1 period to see if the copy works for smaller data set. If yes may be you can split this copy steps into multiple steps by either years or entity or any dimension which logically makes sense for splitting the data set. From 2024 Q2 once the infrastructure of the tenant migrates to HANA cloud , you will get the ability to copy calculated measures in Data Action advanced formula itself by enabling a config statement. But for time being you can only use copy step and try restricting the data set.

Hope this helps !!

Br.

Nikhil

ahfadoo
Participant
0 Kudos
Hi nikhil, Thank you so much for your input. We have already tried to limit the data scope to a singular measure while adding filters to place the values. And we still are not getting the correct values. So by Q2 this year we will have the ability to copy calculated measures and it isnt feasible as of this moment? I really appreciate all the help, Thank you!