View a Dataset Table's Original Formatting

By default Oracle Analytics applies formatting to the numbers and dates in the dataset. You can toggle this default formatting off to view numbers and dates as they're formatted in the dataset's data source.

For example, when Oracle Analytics's default formatting is applied, dates are displayed as 06/20/2019. But when default formatting is turned off, then dates are displayed as 2019-06-20.

You can toggle the default formatting off and on, but you can't save the default formatting. To modify a column's formatting, see Adjust the Display Format of a Date or Number Column.

  1. On the Home page, click Navigator and then click Data.
  2. Click the Datasets tab.
  3. Locate the dataset that you want to open, click Actions, and then click Open.
  4. In the Join Diagram go to the Table Page Tabs and click the table that you want to work with.
  5. In the Transform editor, click the Formatting toggle on the tool bar to turn formatting off or on.
    Formatting Toggle