Home › Discussions › Questions & Answers › Converting Period Offset Definitions in Column Sets
Customer · · Questions & Answers · 7 replies
When converting an Oracle FSG Column Set, how are the defined period offsets represented in the Blitz FSG template?
The Offset definition from the Column Set maps to Row 12 (Periods) in the Excel template. This row handles the calculation of periods for the column.
Which Blitz FSG function is used if the original Column Set defined a period offset?
If an Offset is defined in the Column Set, the formula `br_period_offset` is used in accordance with that defined offset.
What happens if the Column Set had no offset defined?
If the Offset is not defined, this row is equated to the Period Name LOV Cell.
Does the conversion process also handle the mapping of the Amount Type from the Column Set?
Yes, the Column Set’s Amount Type maps to Row 10 and Row 11, where the appropriate balance type (like PTD, YTD) is calculated based on the original Amount type.
Sign in with LinkedIn or Google to take part.
