Framework:BI Center:Create Analysis View - Revision history

Admin at 08:30, 25 November 2010

2010-11-25T08:30:27Z

← Older revision		Revision as of 09:30, 25 November 2010
Line 14:		Line 14:
	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''Input'''</span>  Select the menu item "Create Analysis View" from the context menu of the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|My revenues]]". Confirm the caption "View ~~of Meine Umsatzplanung~~" with OK.		\|<span style="color: darkblue">'''Input'''</span>  Select the menu item "Create Analysis View" from the context menu of the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|My revenues]]". Confirm the caption "View My revenues" with OK.
	\|}		\|}

Admin at 08:28, 25 November 2010

2010-11-25T08:28:04Z

← Older revision		Revision as of 09:28, 25 November 2010
Line 10:		Line 10:
	==Design==		==Design==

	As an example, in this section you will create a analysis view with the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|~~Meine Umsatzplanung~~]]".		As an example, in this section you will create a analysis view with the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|My revenues]]".

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''Input'''</span>  Select the menu item "Create Analysis View" from the context menu of the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|~~Meine Umsatzplanung~~]]". Confirm the caption "View of Meine Umsatzplanung" with OK.		\|<span style="color: darkblue">'''Input'''</span>  Select the menu item "Create Analysis View" from the context menu of the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|My revenues]]". Confirm the caption "View of Meine Umsatzplanung" with OK.
	\|}		\|}

Admin at 09:17, 24 November 2010

2010-11-24T09:17:55Z

← Older revision		Revision as of 10:17, 24 November 2010
Line 10:		Line 10:
	==Design==		==Design==

	As an example, in this section you will create a ~~matrix~~ view with the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|Meine Umsatzplanung]]".		As an example, in this section you will create a analysis view with the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|Meine Umsatzplanung]]".

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}

Admin at 09:17, 24 November 2010

2010-11-24T09:17:10Z

← Older revision		Revision as of 10:17, 24 November 2010
Line 1:		Line 1:
	__TOC__		__TOC__
	An analye view differs from input view in the place of storage and no possibility to input data.		An analye view differs from input view in the place of storage and no possibility to input data.
	To Create a new ~~analyse~~ view open the [[Framework:BI_Center\|BI Center]]. The basis of every analysis view is a data object. As a data object, the following are available to you: [[Framework:BI_Center:CoPlanner_Cube\|CoPlanner cubes]], [[Framework:BI_Center:CoPlanner_Table\|CoPlanner tables]] and [[Framework:BI_Center:OLAP_Cube\|OLAP cubes]].		To Create a new analysis view open the [[Framework:BI_Center\|BI Center]]. The basis of every analysis view is a data object. As a data object, the following are available to you: [[Framework:BI_Center:CoPlanner_Cube\|CoPlanner cubes]], [[Framework:BI_Center:CoPlanner_Table\|CoPlanner tables]] and [[Framework:BI_Center:OLAP_Cube\|OLAP cubes]].

	==Elements and Functions==		==Elements and Functions==
Line 14:		Line 14:
	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''Input'''</span>  Select the menu item "Create ~~Analyse~~ View" from the context menu of the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|Meine Umsatzplanung]]". Confirm the caption "View of Meine Umsatzplanung" with OK.		\|<span style="color: darkblue">'''Input'''</span>  Select the menu item "Create Analysis View" from the context menu of the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube\|Meine Umsatzplanung]]". Confirm the caption "View of Meine Umsatzplanung" with OK.
	\|}		\|}

	The analysis view is created:		The analysis view is created:

	[[Image:FW_Anlegen_Eingabemaske.jpg\|thumb\|center\|BI-Center, Initial view of an ~~analyse~~ view]]		[[Image:FW_Anlegen_Eingabemaske.jpg\|thumb\|center\|BI-Center, Initial view of an analysis view]]

	After you have selected a data object, the dimensions that can be used as axis dimensions or filters will be available in the right-hand pane.		After you have selected a data object, the dimensions that can be used as axis dimensions or filters will be available in the right-hand pane.
Line 75:		Line 75:
	==Properties==		==Properties==

	The properties of an ~~analyse~~ view are as follows:		The properties of an analysis view are as follows:

	:*[[Framework:BI_Center:Input Mask - General properties\|General properties]]		:*[[Framework:BI_Center:Input Mask - General properties\|General properties]]

Admin at 09:16, 24 November 2010

2010-11-24T09:16:26Z

← Older revision		Revision as of 10:16, 24 November 2010
Line 5:		Line 5:
	==Elements and Functions==		==Elements and Functions==

	:*[[Framework:~~Ribbon_Analyse_view~~\|Ribbon]]		:*[[Framework:Ribbon_Analysis_view\|Ribbon]]
	:*[[Framework:Context_menu_input_mask\|Context menu]]		:*[[Framework:Context_menu_input_mask\|Context menu]]

Admin: Created page with "TOC An analye view differs from input view in the place of storage and no possibility to input data. To Create a new analyse view open the BI Center. ..."

2010-11-24T08:54:56Z

Created page with "__TOC__ An analye view differs from input view in the place of storage and no possibility to input data. To Create a new analyse view open the BI Center. ..."

New page

__TOC__
An analye view differs from input view in the place of storage and no possibility to input data.
To Create a new analyse view open the [[Framework:BI_Center|BI Center]]. The basis of every analysis view is a data object. As a data object, the following are available to you: [[Framework:BI_Center:CoPlanner_Cube|CoPlanner cubes]], [[Framework:BI_Center:CoPlanner_Table|CoPlanner tables]] and [[Framework:BI_Center:OLAP_Cube|OLAP cubes]].

==Elements and Functions==

:*[[Framework:Ribbon_Analyse_view|Ribbon]]
:*[[Framework:Context_menu_input_mask|Context menu]]

==Design==

As an example, in this section you will create a matrix view with the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube|Meine Umsatzplanung]]".

{| {{Bausteindesign2}}
|-
|<span style="color: darkblue">'''Input'''</span>  Select the menu item "Create Analyse View" from the context menu of the CoPlanner cube "[[Framework:BI_Center:Create CoPlanner Cube|Meine Umsatzplanung]]". Confirm the caption "View of Meine Umsatzplanung" with OK.
|}

The analysis view is created:

[[Image:FW_Anlegen_Eingabemaske.jpg|thumb|center|BI-Center, Initial view of an analyse view]]

After you have selected a data object, the dimensions that can be used as axis dimensions or filters will be available in the right-hand pane.

Additionally, the measures that can be displayed or hidden will be available.

Elements – dimensions and measures – that do not have an associated icon ([[Image:Excel cop points ico.jpg]]) will not be available here. Measures without an icon will not be shown, and dimensions without an icon will be ignored. You can rotate the axes by clicking on the [[Image:Excel cop achse drehen ico.jpg]] icon. To transfer only the measure dimension to the opposite axis, press and hold the Ctrl key. To use a dimension as an axis dimension, drag the dimension to the position of the desired axis and drop it there.

[[Image:EM Dimension als Achsenelement.jpg|thumb|center|BI-Center, Dimension on axis]]

To use a dimension as a filter, drag the dimension to the filter area instead of an axis.

[[Image:EM Dimension als Filter.jpg|thumb|center|BI-Center, Dimension as filter]]

If you want to display fewer measures, simply click on the measure you wish to hide.

[[Image:Excel Hiding a measure.jpg|thumb|center]]

To display the hidden measure again, click on it again.

[[Image:Excel Showing a measure.jpg|thumb|center]]

You can add dimensions as filters without using drag & drop. The procedure is identical to showing or hiding measures, except that, in this case, the dimension must be selected.

[[Image:Excel Showing hiding dimensions.jpg|thumb|center]]

If a dimension was added as a filter, the dimension can be removed again by double-clicking on it in the filter area.

[[Image:Excel Removing a dimension from the filter area.jpg|thumb|center|BI-Center, Remoce dimension]]

You can also use filter dimensions as axis dimensions by means of drag & drop. To do so, simply click on the dimension in the filter, hold the left mouse key, and drag the dimension to the desired axis. When the desired position is highlighted, release the left mouse key. The dimension will be inserted and will now serve as a dimension on the axis.

[[Image:Excel Dragging a dimension from the filter area to an axis.jpg|thumb|center|BI-Center, Move dimansion from filter are to axis]]

To change the order of the measures (fields), click on the measure you want to move and drag it to the desired location. A bold black line will display the current position where the measure will be inserted when you release the left mouse button.

Additionally, you can change the order of the measures in the “Select measures” dialogue. Open the dialogue by clicking on the “Select measure” button. Now change the position of the selected measure using the Up and Down arrow icons.

[[Image:Excel Moving measures up and down.jpg|thumb|center|BI-Center, Reorder measure]]
Dimensions can be positioned on the axis (to the left or right of a previously inserted dimension), or they can replace other axis dimensions. The border around the dimensions on the axis shows the position to which the dimensions will be moved.

[[Image:Excel Inserting a dimension on the left of an existing dimension.jpg|thumb|center]]

[[Image:Excel Replacing an existing dimension.jpg|thumb|center]]

[[Image:Excel Inserting a dimension on the right of an existing dimension.jpg|thumb|center]]

To edit the definition of the axis, right-click on an axis dimension to display a [[Framework:Context_menu_input_mask|context menu]].

{| {{Bausteindesign2}}
|-
|<span style="color: darkblue">'''Input'''</span>  Drag the dimension Products on vertical axis and period on horizontal axis. Choose following dimensions as filter: Scenario, Companies, Customers/Countries, Kind of revenues, Scenario to compare and the period.
|}

==Properties==

The properties of an analyse view are as follows:

:*[[Framework:BI_Center:Input Mask - General properties|General properties]]
:*[[Framework:BI_Center:Input Mask - Dimension properties|Dimension properties]]
:*[[Framework:BI_Center:Input Mask - Measure properties|Measure properties]]

__NOEDITSECTION__

[[Category:Framework|Create Anlysis View]]
[[Category:BI Center|Create Anlysis View]]
[[Category:Masks|Create Anlysis View]]
[[de:Framework:BI_Center:Analysesicht_erstellen]]

Framework:BI Center:Create Analysis View - Revision history

Admin at 08:30, 25 November 2010

Admin at 08:28, 25 November 2010

Admin at 09:17, 24 November 2010

Admin at 09:17, 24 November 2010

Admin at 09:16, 24 November 2010

Admin: Created page with "__TOC__ An analye view differs from input view in the place of storage and no possibility to input data. To Create a new analyse view open the BI Center. ..."

Admin: Created page with "TOC An analye view differs from input view in the place of storage and no possibility to input data. To Create a new analyse view open the BI Center. ..."