www.bispsolutions.com
www.bispsolutions.com
Smartview Reporting Using
Smartview Reporting Using
Free-Form Mode
Free-Form Mode
Presented By :Amit Sharma
www.bispsolutions.com
www.bispsolutions.com
Lesson 8: Using Free Form Reporting Lesson 8: Using Free Form Reporting Duration:
Duration: 30 minutes 30 minutes Topics
Topics
About Free-Form ModeAbout Free-Form Mode
Free-Form GuidelinesFree-Form Guidelines
Free-Form Grid ExamplesFree-Form Grid Examples
Comments in Free-Form GridsComments in Free-Form Grids
Comments in Blank Rows and ColumnsComments in Blank Rows and Columns
Comments Inside and Outside of Grid Comments Inside and Outside of Grid BoundariesBoundaries
Formulas in Free-Form GridsFormulas in Free-Form Grids
www.bispsolutions.com
www.bispsolutions.com
About Free-Form Mode
About Free-Form Mode
In ad hoc analysis, if
In ad hoc analysis, if you are familiar with the dimensions and members of youryou are familiar with the dimensions and members of your database, you can use
database, you can use free-form mode by typing dimension and free-form mode by typing dimension and member namesmember names directly into cells. You can still
directly into cells. You can still use the POV, member selection, and other ad hocuse the POV, member selection, and other ad hoc operations in free-form grids.
www.bispsolutions.com
www.bispsolutions.com
Free-Form Guidelines
Free-Form Guidelines
1.
1. GriGrids ds do ndo not not neeeed to d to stastart in rt in cecell All A1.1. 2.
2. A grid mA grid must haust have at leve at least onast one row e row dimedimension nsion and onand one cole column dumn dimenimensionsion.. 3.
3. Each rEach row dimeow dimension nsion can concan contain mtain membeembers of only ors of only one dimene dimensionnsion. Each co. Each columnlumn dimension can contain members of only one dimension.
dimension can contain members of only one dimension. 4.
4. MembMembers of oners of one dimene dimension csion can be entan be entereered only in ond only in one of the foe of the followllowing reing regiongions:s: 1
1.. In In ththe e sasame me rrooww 2.
2. In In ththe e sasame me cocolulumnmn
llThe replacement labels specified in the Data The replacement labels specified in the Data Options page of Smart Options page of Smart View OptionsView Options
apply in free-form mode. apply in free-form mode.
5. Numerical entries are identifie
5. Numerical entries are identified as d as data in the data data in the data region, and as commentsregion, and as comments
outside the data region. If you want to use a number as a member name, precede it outside the data region. If you want to use a number as a member name, precede it with a single quotation mark; for example, '100.
www.bispsolutions.com
www.bispsolutions.com
Free-Form Grid Examples
Free-Form Grid Examples
Simple Example
www.bispsolutions.com
www.bispsolutions.com
Comments in Free-Form Grids
Comments in Free-Form Grids
Between row dimensionsBetween row dimensions
Between column dimensionsBetween column dimensions
Between page dimensionsBetween page dimensions
Between dimensionBetween dimensions and data s and data cellscells
Interleaved with members of page dimensionsInterleaved with members of page dimensions
Interleaved with members of row, column and page dimensionsInterleaved with members of row, column and page dimensions
Further, comment rows and comment columns can be interleaved with rowFurther, comment rows and comment columns can be interleaved with row and column dimensions.
and column dimensions.
www.bispsolutions.com
www.bispsolutions.com
Comments in Blank Rows and Columns
www.bispsolutions.com
www.bispsolutions.com
Comments Inside and Outside of Grid
www.bispsolutions.com
www.bispsolutions.com
Formulas in Free-Form Grids
Formulas in Free-Form Grids
You can enter Excel formulas in cells that can contain comments. You can enter Excel formulas in cells that can contain comments.
www.bispsolutions.com
www.bispsolutions.com
Creating Free-Form Reports
Creating Free-Form Reports
To construct a free-form report: To construct a free-form report:
1 Open a worksheet and connect to a
1 Open a worksheet and connect to a data source.data source. 2 In the
2 In the worksheet, enter member names according to the rules worksheet, enter member names according to the rules specified.specified. 3 Members may
3 Members may have duplicate names (for example, both East have duplicate names (for example, both East and West marketsand West markets may contain a member named Portland
may contain a member named Portland —— Maine and Oregon). To enter a Maine and Oregon). To enter a duplicate member name:
duplicate member name:
In Financial Management, the Member Name Resolution window is displayed In Financial Management, the Member Name Resolution window is displayed if the member you enter has a
if the member you enter has a duplicate. From the drop-down list, select theduplicate. From the drop-down list, select the dimension of the member you entered and click OK. Repeat as necessary. dimension of the member you entered and click OK. Repeat as necessary. 4 Refr
4 Refresh the grid, esh the grid, or select Ad hoc analysis.or select Ad hoc analysis. 5 Perform further ad hoc