NewAccoPlanningV2v2.3.0.0
New accoPLANNINGV2 release: v2.3.0.0
accoPLANNING V2 — Release notes, version 2.3.0.0
## Highlights
- Versions, redesigned.The report's own saved state is now calledReport, and a named version holds only your own view of the grid. Choose which version opens when you open the report, and keep a version in the report to share it with everyone.
- Review changes before you save.A new Writeback dialog lists every change waiting to be saved, lets you take back single changes, and keeps a log of each save.
- A far more capable AI assistant.The assistant can now do most of what you can do by hand, from moving fields and changing measures to locking cells and saving versions, and it can explain the cell you are on. When the report author allows it, it can also answer questions about your numbers.
- Large reports load faster and more reliably.When Power BI does not send all the data, the grid now says so and keeps the grid read-only instead of showing totals that are wrong.
## New features
### Save state and versions
- The report's own saved state is called Reportwherever you see it. Everyone opens on it until they choose a version of their own.
- A named version keeps only what you set for yourself: open groups, sort, row and column order, filter picks, the swap of rows and columns, and sizes. Settings, themes, formats, rules and calculations belong to the report, so an author's later changes reach everyone, whichever version they use.
- Changes to your view last until you close the report. Save statekeeps them in the version you use, and a dot underSave stateshows that you have unsaved changes.
- Tick Open on starton a version in the Versions dialog to open the report in it next time. With no version ticked, the report opens on Report.
- Save as new versionis on the arrow besideSave state.
- While editing the report, Save to reportkeeps a copy of one of your versions in the report, where it does not expire. TickShareon the copy to let everyone who opens the report see and use it. Versions others share are listed underShared with you.
- Resetputs back your last save. It no longer deletes your versions or custom themes.
- Opening the report keeps your versions and custom themes from expiring.
### Writeback
- A new Review changes before savingsetting, under Settings > Data > Editing, is off by default. With it on,Save Dataand Ctrl+Shift+S open a Writeback dialog, andCommitsaves.
- The
Changes
tab lists each change waiting to be saved (a typed value, a splash, a paste, a fill, a delete, a comment, a lock or a change from the assistant) with its time, the cells it changed with their values before and after, and whether it is pending, failed or committed.- Take back one pending change, or all of them with
Discard pending
. Undo
brings them back.- The
Log
tab lists each save, newest first, with every cell it sent and whether it was saved.### Measures
- Each number measure can set its own default splash in Manage measures: how a number typed into a total is spread, the driver for a driver splash, and whether the splash dialog asks first. A paste onto a total, and the assistant when you do not say how to spread, use it too.
- Importing from accoPLANNING v1 now brings each measure's default distribution method across.
- A measure's settings open with the basics first (label, type, role and how it adds up), and the rest in groups: Bindings, Chart, Comments, Format, Editing and Validation.
### AI assistant
- A new switch, Send the grid's values, in Settings on the AI assist tab, lets the assistant answer questions about your numbers, such as "which region is furthest over budget?". It is off by default and saved with the report. A warning shows next to the switch, and under the message box while it is on. Comments are never sent.
- The assistant can now:
- undo and redo, save state, save, switch, rename and delete versions, save your changed numbers, export to Excel and reset,
- change any setting in the Settings dialog, your custom fill lists, a code column shown beside its field, and whether a filter takes one member or several,
- move fields between the rows, the columns and the Filters bar, swap rows and columns, and filter to all but some members,
- change any setting of a measure, and add, delete and move measures,
- add comments, and open a cell's comments or line items,
- lock and unlock cells,
- make highlight rules that test another measure, colour whole rows, columns or labels, and take their colour from a measure, in any colour,
- continue a pattern as the fill handle does, spread a number over the selected cells, and change cells where another measure meets a condition,
- size columns and rows, go to a cell and select cells,
- explain the cell you are on: why it cannot be typed into, why it is coloured, or where its number comes from,
- open the Help & guide at the answer to a "how do I" question, or start the guided tour.
- A change that reaches past the grid or cannot be undone, such as saving data or deleting a version, runs on its own, with a warning first.
- One Applyis one undo step, and anUndobutton under the answer takes all of it back.
- The assistant knows which cells you have selected and what it changed last, so "make these bold" or "make it blue instead" lands where you mean.
- A calculated row or measure the assistant adds can be formatted in the same request.
- When the assistant asks a question with a few clear answers, the answers show as buttons. A waiting plan can be answered with "yes" or "no".
- A request that needs more than 12 changes is done in turns, up to 48 changes.
- In large reports, the assistant looks up a name you mention before it makes the change.
- Stopcancels a request. The assistant gives up after 60 seconds, and waits once when the AI service is busy.
- Last request, on the AI assist tab, shows how many tokens the request used.
- With AI assist on, every message goes to the AI service, and everything it proposes waits for Apply. With AI assist off, number commands work offline as before.
### Grid
- An empty grid says why: no measures to show, no rows that match your filters (with Clear filters), or no data. The footer says it too.
- In merged column headers, an open column group can be moved by its header, so two groups trade places whether they are open or closed.
- Merge lone own nodesandExclude own nodescan be switched from the right-click menus on the row and column headers and on the grid background.
- The Manage Calbutton shows how many calculations the report has.
### Data loading
- Data loads in parts of 30,000 rows, and large reports load faster.
- While data reloads, the grid keeps showing what it had, read-only, until the new data is all there.
- When Power BI stops sending rows, or columns reach the 30,000 limit, a warning icon says so. The toolbar shows "Not all data loaded" and editing stays locked, since the totals are incomplete.
## Improvements and fixes
- A blank number in the data counts as 0 in calculations and totals, so an average over ten rows divides by ten. A 0 typed onto a blank cell is not a change and is not saved. Blank text, dates and yes/no values stay blank.
- In very large reports, a value could go missing or two rows could share their cells, which gave wrong totals and could save an edit to the wrong row. Every row now keeps its own cells.
- Reloading a large report no longer closes open groups or loses the sort and row order of rows that load late.
- A dragged row or column now stays where you drop it, every time.
- When a field matches several columns of the writeback table whose names differ only in upper and lower case, the save is refused and names the columns, instead of writing to one of them.
- An author going back to editing from reading view no longer finds the report's settings locked.
- Ctrl+Home scrolls back to the top of a long grid.
- The assistant says why it could not make a change, names a name it could not find, and lists the matches when a name fits several members.
- The assistant keeps the rest of a highlight rule it changes, and zooms from 40% to 300%, as the zoom control does.
## Please note
- Open groups, sort, row and column order, sizes, spacers, formats on rows and columns, the report's saved state and named versions saved before version 2.3.0.0 no longer match the grid's rows and columns, and need to be set again.
- Changes to your view are no longer saved as you work. Use Save stateto keep them.
The new release is available now from AppSource.