April 2022 Product Adoption Tip: Row Notes Maintenance

Row Notes are commonly used in Template Studio reports. Users may enter text comments in the Row Notes via Data Entry mode (mostly during the budget cycle) or read the final Row Notes added to the report.

Assuming the next year’s budget cycle uses the same budget template the main layout will remain unchanged. When you roll over the budget template to the next year, the Row Notes column will still show last year’s comments. However, you do not want old comments in the new budget year’s template, so you will need to change the Row Notes to point to the new budget year.

What you Currently See:
Last year 2021 Row Notes are still showing

Rollover last year’s template to the new budget year 2022

Row Notes comments can be reset by updating the Row Notes properties in Template Studio, as follows:

  1. Open the template in Design mode and expand the Data View section on the
    left side section
  2. Under the Cells section on the left side window locate the Row Note object
  3. Click on the Row Note object and:
    Figure 1: Last year template with row notes comments
    a. Click the Properties icon on the lip menu, or
    b. Press right-click on the row note object and choose “Properties”
  4. The Row Notes properties screen will pop up. Locate the Time dimension
    member selector, and change the value from the last year (2021) to the new
    budget year (2022)
  5. Save changes and press OK.

1 Like

Very useful information. Thanks!

3 Likes

Thanks for the information!

2 Likes

I am yet to use Row notes, and this info is very helpful in that regard.

2 Likes

This is great information to know. We haven’t used Row Notes, but it would be helpful for our forecast and budgeting.

2 Likes

Thanks for that tip! I was hoping to incorporate row notes next budget cycle, so this will be very helpful!

2 Likes

Good information. Using the row notes in several of our forecasting and budget cycles. Really like the row notes.

2 Likes

This will save me some time trying to figure out.

2 Likes

thank you. this will definitely save some time.

2 Likes

This is a great tip! I have had great success using row notes and tying them to the same year Named Set that I use in the template. That way the row notes move forward in time along with the rest of the template.

2 Likes

thanks. we use row notes for monthly variance commentary and it works great!

1 Like

Thanks for providing tips like this.

1 Like

This is very useful information . thank you.

We have been using Row Notes to keep track of comments on P&L

1 Like

Very useful information. I have yet to use this functionality. Thanks for sharing!

We plan to use Row Notes in 2023.

Thanks for sharing!!

Row notes, a great tip.

That is good to know!