Non cumulative measure in Datasphere

[murali_balreddy2]

Working with non cumulative measure in an analytic model. Stock movements by itself shows correctly in the date hierarchy.  

But the non cumulative stock level does not show up correctly. It just shows the latest value for all nodes of the date period. Expectation is to show the stock level at node level by period (movement doesn't show up when both measures are displayed)

Here is the definition of the non-cumulative measure, Stock Level

Sample data used =>

Date	Product	Movement	Record Type
2022-12-07	BX-1011	-16	2
2022-12-10	BX-1011	12	2
2022-12-14	BX-1011	19	2
2022-12-31	BX-1011	390	1
2023-01-09	BX-1011	-8	0
2023-01-14	BX-1011	-13	0
2023-01-15	BX-1011	-16	0
2023-01-18	BX-1011	17	0
2023-01-22	BX-1011	-10	0
2023-02-03	BX-1011	11	0
2023-02-06	BX-1011	25	0
2023-02-07	BX-1011	-20	0
2023-02-08	BX-1011	-9	0
2023-02-12	BX-1011	20	0
2023-02-15	BX-1011	9	0
2023-02-17	BX-1011	11	0
2023-02-20	BX-1011	25	0
2023-02-25	BX-1011	-20	0
2023-02-28	BX-1011	4	0
2023-03-04	BX-1011	7	0
2023-03-14	BX-1011	-5	0
2023-03-15	BX-1011	10	0
2023-03-21	BX-1011	20	0
2023-03-22	BX-1011	23	0
2023-03-25	BX-1011	9	0
2023-03-29	BX-1011	-11	0
2023-03-30	BX-1011	-13	0

What am I doing wrong here?

Thanks.

[alexander_john_berlin]

Hello, I am working on a new analytic model that uses Non-Cumulative Measures. I noticed that it does not work with the SAC Excel Addin. A colleague of mine could replicate this issue with a separate model. Is this a known issue?

[Roberth_Reyes]

Hello,

I'm wondering with approach did you use to load the stock data from S4 to Datasphere? 

Thanks and regards.

[tmeyer · Accepted solution]

Hi,

I tested it with your example data and it works fine. I only had to adjust the time frame because it is different with your data vs. Screenshots

[murali_balreddy2 · Accepted solution]

Thanks for pointing it out. My bad, I had the wrong reporting period than the data.