How to get the value from the source without time dimension

DMManalili
Frequent Contributor

How to get the value from the source without time dimension

Hi, question please. I am doing a test variance module between line items of IC Run, Actual and Forecast using LIS, Versions and Project as my dimensions. I need to get the value of IC run, however, the module does not have time dimension in compare with my module data for the actuals and latest budget (forecast). I used the collect however, all the months are getting the values of 784M and sums all the periods that is why I am getting 6B. I just need the value of 784 as the totals for all the periods.

 

Test variance module

DMManalili_3-1607689693891.png

 

DMManalili_2-1607689668591.png

 

IC Run data - no time dimension

DMManalili_1-1607689640406.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
nikolay_denisov
Certified Master Anaplanner

Re: How to get the value from the source without time dimension

I could suggest following few options:

1) Define current month where you need to map this data. Like define a boolean line item in SYS time module and calculate latest reporting month. Then in reporting module you could push values to this month with IF..THEN..ELSE

2) Use a different summary method: Closing balance or Formula

 

View solution in original post

2 REPLIES 2
Misbah
Moderator

Re: How to get the value from the source without time dimension

@DMManalili 

 

Create a SYS TIME module (Lowest Granularity) with one line item called Count and hard code it to 1. Use that count to derive the number of months & use the aggregated number as the denominator in your 6B Value

 

Misbah

nikolay_denisov
Certified Master Anaplanner

Re: How to get the value from the source without time dimension

I could suggest following few options:

1) Define current month where you need to map this data. Like define a boolean line item in SYS time module and calculate latest reporting month. Then in reporting module you could push values to this month with IF..THEN..ELSE

2) Use a different summary method: Closing balance or Formula

 

View solution in original post