A new Oracle Fusion Cloud client needs to produce an income statement on a regular basis using Smart View. Which Smart View tool would be best for…

Query Designer is a Smart View tool that enables you to create and modify ad hoc queries on

General Ledger balances cubes. You can use Query Designer to select the dimensions, members, and

filters that you want to include in your query, and then retrieve the data in a grid format in Excel. You

can also save, open, and refresh your queries as needed. Query Designer is the best tool for

producing an income statement on a regular basis using Smart View, because it allows you to easily

access and analyze the income and expense accounts, as well as the ledger, period, currency, and

other dimensions that are relevant for your report. You can also customize the layout and format of

your grid, and use Excel functions and features to enhance your report. Reference:

Overview of Smart View

Creating an Ad Hoc Analysis in Smart View