08-02-2023 07:00 AM - edited 08-02-2023 07:23 AM
hi ,
Am getting mutiple values from the databuffer for the same intersection. Database has Status1 ,Value1 then up to ...Status 12 ,Value 12... I beleive that only the Staus 12 and Value 12 combination alone has to be used but am not sure how it can be pulled in the rule , others are the past values which are stored for that particular intersection..Based on this value further calculation of % on UD 8 needs to be made.
Rule:
Thanks
08-02-2023 08:23 AM
In a monthly scenario, Value 1-12 represents the months. Value 1 would be M1, Value2 is M2, and so on. In order to only pull Value 12, you would need to specify a time period in your Data Buffer. An example of this would be "T#" & api.Time.GetYearFromId(api.Pov.Time.MemberId) & "M12", but there are multiple ways to do so.
08-02-2023 09:25 AM
Thanks Eric ..Can we get the YTD value of those intersection . I tried the below but still getting all the 12 months data for YTD using databuffer .Quick view am getting only one column which has M12 value aggregated.
QV:
08-03-2023 04:41 AM - edited 08-03-2023 04:44 AM
OneStream stores every number as YTD in the database, even if you load Periodic values. What you see in that CV is the YTD value for V12, i.e. the last month of the year. Looks correct to me. If you want some other value (periodic, QTD etc), change the View member and the system will calculate it for you on the fly.