New Upload weather data from web services into TM1/Planning Analytics — Read the post →

Create an Active Form from a Cube View

In a new sheet, open the P&L by Account view from the General Ledger cube and click Export Active Form:

image-20251202-114759.png

Toggle format area

Toggle the format area to give our 3 columns (C, D & E) a more readable format:

image-20251202-115128.png

You can type any given number as a sample so you get to see the format that you are selecting; this is simply a best practice. We can then toggle the format area back to hidden, the just rebuild the sheet