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. References:
* Overview of Smart View
* Creating an Ad Hoc Analysis in Smart View