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
