Framework:CoPlanner cube designer - Revision history

Admin at 09:14, 25 January 2017

2017-01-25T09:14:56Z

Admin at 12:42, 14 October 2013

2013-10-14T12:42:25Z

← Older revision		Revision as of 14:42, 14 October 2013
Line 246:		Line 246:
	Specifies how subordinated elements are aggregated (projected) in the sum element above.		Specifies how subordinated elements are aggregated (projected) in the sum element above.

	~~SUM~~: Subelements are added		AGG: Subelements are added
	~~AVG~~: Subelements are averaged		Member: Subelements are averaged

	'''Caption'''		'''Caption'''

Admin at 15:19, 12 December 2012

2012-12-12T15:19:15Z

← Older revision		Revision as of 17:19, 12 December 2012
Line 41:		Line 41:
	\| Button		\| Button
	\| Action		\| Action
			\|-
			\|[[Image:Icon_CheckIn.jpg‎]]
			\|CheckIn/Out to modify the Cube
	\|-		\|-
	\| [[image:Icon_Speichern.jpg‎]]		\| [[image:Icon_Speichern.jpg‎]]
Line 48:		Line 51:
	\| Reload connectors		\| Reload connectors
	During a session, changes in the OLAP database are only reloaded from the server after a click on this button.		During a session, changes in the OLAP database are only reloaded from the server after a click on this button.
	\|-
	~~\|[[Image:Icon_Suchen.jpg‎]]~~
	~~\|Search~~
	~~Search in the object tree~~
	\|}		\|}

Admin at 08:26, 6 March 2012

2012-03-06T08:26:49Z

← Older revision		Revision as of 10:26, 6 March 2012
Line 37:		Line 37:


	{\| ~~style~~="~~width: 857px; height: 108px" cellspacing="1" cellpadding="3~~" width="~~857" border="1~~"		{\| class="wikitable" width="857px"
	\|-		\|- {{Tabellentitel}}
	\| ~~style=background-color:#f6f6f6 \|'''~~Button~~'''~~		\| Button
	\| ~~style=background-color:#f6f6f6 \|'''~~Action~~'''~~		\| Action
	\|-		\|-
	\| [[image:Icon_Speichern.jpg‎]]		\| [[image:Icon_Speichern.jpg‎]]

Admin at 14:44, 17 August 2011

2011-08-17T14:44:51Z

← Older revision		Revision as of 16:44, 17 August 2011
Line 44:		Line 44:
	\| [[image:Icon_Speichern.jpg‎]]		\| [[image:Icon_Speichern.jpg‎]]
	\| Save		\| Save
	\|-
	~~\| [[Image:Icon_Speichern_unter.jpg]]~~
	~~\| Save as~~
	~~Not in use~~
	\|-		\|-
	\| [[Image:Icon_Konnektoren_laden.jpg]]		\| [[Image:Icon_Konnektoren_laden.jpg]]

Admin at 14:25, 17 August 2011

2011-08-17T14:25:46Z

← Older revision		Revision as of 16:25, 17 August 2011
Line 79:		Line 79:
	[[image:Fw_BI_Center property of the data object.jpg\|thumb\|center\|Framework, BI Center, property of the data object]]		[[image:Fw_BI_Center property of the data object.jpg\|thumb\|center\|Framework, BI Center, property of the data object]]

	'''~~Alias~~'''		'''Caption'''

	This text is shown.		This text is shown.

	'''~~IsPlanDependent~~'''		'''Name'''

	~~Provides information whether~~ the ~~data object is plan dependant, i.e. whether the data acquired by the user are written to the plan selected at login, or whether this characteristic is not relevant (actual data)~~.		Name of the source.

	'''~~Special~~'''		'''SpecialDefinition'''

	'''CUSTOMROLLUP=LASTMONTHONYEAR;'''		'''CUSTOMROLLUP=LASTMONTHONYEAR;'''
Line 181:		Line 181:
	In the right part of the designer, the properties of the dimensions are shown.		In the right part of the designer, the properties of the dimensions are shown.

	'''~~Alias~~'''		'''Caption'''

	This text is shown.		This text is shown.

	'''~~IsPlan~~'''		'''Name'''

	Provides information whether the dimension is the CoPlanner system dimension “Plan”. If the dimension is the plan dimension, it can only be applied to data objects if “IsPlanDependent”, has been set as the property of the ~~data~~ source.		Name of the source dimension.


Line 254:		Line 254:
	AVG: Subelements are averaged		AVG: Subelements are averaged

	'''~~Alias~~'''		'''Caption'''

	This text is shown.		This text is shown.
Line 298:		Line 298:
	Defines whether this column is to be write-protected.		Defines whether this column is to be write-protected.

	'''~~CumSettingType~~'''		'''ToDateType'''

	Setting of the cumulation. The following possibilities are available for selection:		Setting of the cumulation. The following possibilities are available for selection:
Line 308:		Line 308:
	:*Week		:*Week

	'''~~CumSettingColumn~~'''		'''ToDateColumn'''

	CumSettingColumn offers the dimensions of the data source for selection over which a cumulation is to be performed.		CumSettingColumn offers the dimensions of the data source for selection over which a cumulation is to be performed.
Line 316:		Line 316:
	This offers the dimensions of the data source to which a time shift can be applied.		This offers the dimensions of the data source to which a time shift can be applied.

	'''~~Shift_Interval~~'''		'''ShiftInterval'''

	Number of periods that are to be shifted. A forward and backward time shift is possible and defined by using the (+/-)sign.		Number of periods that are to be shifted. A forward and backward time shift is possible and defined by using the (+/-)sign.

Admin at 15:39, 24 November 2010

2010-11-24T15:39:57Z

← Older revision		Revision as of 17:39, 24 November 2010
Line 427:		Line 427:

	[[Category:Framework\|CoPlanner cube designer]]		[[Category:Framework\|CoPlanner cube designer]]
	~~[[Category:BI Center\|CoPlanner cube designer]]~~
	[[de:Framework:CoPlanner_Würfel_Designer]]		[[de:Framework:CoPlanner_Würfel_Designer]]

Admin at 08:12, 19 July 2010

2010-07-19T08:12:34Z

Admin at 08:06, 19 July 2010

2010-07-19T08:06:58Z

Admin at 13:18, 1 June 2010

2010-06-01T13:18:15Z

← Older revision		Revision as of 15:18, 1 June 2010
Line 61:		Line 61:
	===“Data sources“ tab===		===“Data sources“ tab===

	In this tab, the data basis is defined. The available data objects are shown in the left tree of the designer. These are arranged by CoPlanner tables, CoPlanner cubes and OLAP cubes.		In this tab, the data basis is defined. The available data objects are shown in the left tree of the designer. These are arranged by [[Framework:Tables\|CoPlanner tables]], CoPlanner cubes and OLAP cubes.
	You can change the width of the tree by clicking on the right edge with the left mouse button. With the button held down, make the area bigger or smaller.		You can change the width of the tree by clicking on the right edge with the left mouse button. With the button held down, make the area bigger or smaller.

Line 68:		Line 68:
	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''Entry'''</span>  As the data basis, choose the CoPlanner tables and “P&L_aggregate cost method_PLAN” and “P&L_ aggregate cost method_ACTUAL”. Using drag & drop, drag these tables to the working area.		\|<span style="color: darkblue">'''Entry'''</span>  As the data basis, choose the [[Framework:Tables\|CoPlanner tables]] and “P&L_aggregate cost method_PLAN” and “P&L_ aggregate cost method_ACTUAL”. Using drag & drop, drag these tables to the working area.
	\|}		\|}

← Older revision		Revision as of 10:12, 19 July 2010
Line 8:		Line 8:


	[[image:Fw_BI_Center creating a new CoPlanner cube.jpg\|thumb\|center\|Framework, BI ~~Centre~~, creating a new CoPlanner cube]]		[[image:Fw_BI_Center creating a new CoPlanner cube.jpg\|thumb\|center\|Framework, BI Center, creating a new CoPlanner cube]]

	The dialog “CoPlanner cube” is displayed.		The dialog “CoPlanner cube” is displayed.

	[[image:Fw_BI_Center name of the CoPlanner cube.jpg\|thumb\|center\|Framework, BI ~~Centre~~, name of the CoPlanner cube]]		[[image:Fw_BI_Center name of the CoPlanner cube.jpg\|thumb\|center\|Framework, BI Center, name of the CoPlanner cube]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 21:		Line 21:
	The new CoPlanner cube object “;My P&L” is created and the CoPlanner cube designer is opened. The following screen is presented.		The new CoPlanner cube object “;My P&L” is created and the CoPlanner cube designer is opened. The following screen is presented.

	[[image:Fw_BI_Center CoPlanner cube designer.jpg\|thumb\|center\|Framework, BI ~~Centre~~, CoPlanner cube designer]]		[[image:Fw_BI_Center CoPlanner cube designer.jpg\|thumb\|center\|Framework, BI Center, CoPlanner cube designer]]

	The CoPlanner cube designer contains four tabs.		The CoPlanner cube designer contains four tabs.
Line 64:		Line 64:
	You can change the width of the tree by clicking on the right edge with the left mouse button. With the button held down, make the area bigger or smaller.		You can change the width of the tree by clicking on the right edge with the left mouse button. With the button held down, make the area bigger or smaller.

	[[image:Fw_BI_Center changing the width of the object tree.jpg\|thumb\|center\|Framework, BI ~~Centre~~, changing the width of the object tree]]		[[image:Fw_BI_Center changing the width of the object tree.jpg\|thumb\|center\|Framework, BI Center, changing the width of the object tree]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 71:		Line 71:
	\|}		\|}

	[[image:Fw_BI_Center Structure and object selection .jpg\|thumb\|center\|Framework, BI ~~Centre~~, Structure and object selection ]]		[[image:Fw_BI_Center Structure and object selection .jpg\|thumb\|center\|Framework, BI Center, Structure and object selection ]]

	====Properties in the “Data sources” tab====		====Properties in the “Data sources” tab====
Line 77:		Line 77:
	In the right part of the Designer, the properties of the data objects are shown.		In the right part of the Designer, the properties of the data objects are shown.

	[[image:Fw_BI_Center property of the data object.jpg\|thumb\|center\|Framework, BI ~~Centre~~, property of the data object]]		[[image:Fw_BI_Center property of the data object.jpg\|thumb\|center\|Framework, BI Center, property of the data object]]

	'''Alias'''		'''Alias'''
Line 132:		Line 132:
	The “Dimensions” tab shows all dimensions assigned to the data objects, whereas identical dimensions contained in the data objects are connected and assigned. Assigned dimensions are indicated with a green check [[Image:Icon_Haekchen.jpg]], non-assigned dimensions or dimensions that cannot be assigned are shown on a grey background.		The “Dimensions” tab shows all dimensions assigned to the data objects, whereas identical dimensions contained in the data objects are connected and assigned. Assigned dimensions are indicated with a green check [[Image:Icon_Haekchen.jpg]], non-assigned dimensions or dimensions that cannot be assigned are shown on a grey background.

	[[image:Fw_BI_Center Dimensions tab.jpg\|thumb\|center\|Framework, BI ~~Centre~~, Dimensions tab]]		[[image:Fw_BI_Center Dimensions tab.jpg\|thumb\|center\|Framework, BI Center, Dimensions tab]]

	You can break an assignment [[Image:Icon_Haekchen.jpg]] of the dimension by clicking on the corresponding element. In the same manner, you can also re-establish an assignment.		You can break an assignment [[Image:Icon_Haekchen.jpg]] of the dimension by clicking on the corresponding element. In the same manner, you can also re-establish an assignment.
Line 144:		Line 144:
	The following screen is presented.		The following screen is presented.

	[[image:Fw_BI_Center Adding a subset.jpg\|thumb\|center\|Framework, BI ~~Centre~~, Adding a subset]]		[[image:Fw_BI_Center Adding a subset.jpg\|thumb\|center\|Framework, BI Center, Adding a subset]]

	For both data objects, the assignment is shown on a grey background.		For both data objects, the assignment is shown on a grey background.
Line 155:		Line 155:
	A dialog to select the subset opens. Only the possible assignments are shown in black.		A dialog to select the subset opens. Only the possible assignments are shown in black.

	[[image:Fw_BI_Center possible assignments.jpg\|thumb\|center\|Framework, BI ~~Centre~~, possible assignments]]		[[image:Fw_BI_Center possible assignments.jpg\|thumb\|center\|Framework, BI Center, possible assignments]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 164:		Line 164:
	In the corresponding element, the “Manually assigned” [[Image:Icon_manuell_zugeordnet.jpg]] icon is displayed. This data object is now linked with this subset.		In the corresponding element, the “Manually assigned” [[Image:Icon_manuell_zugeordnet.jpg]] icon is displayed. This data object is now linked with this subset.

	[[image:Fw_BI_Center manually assigned subset.jpg\|thumb\|center\|Framework, BI ~~Centre~~, manually assigned subset]]		[[image:Fw_BI_Center manually assigned subset.jpg\|thumb\|center\|Framework, BI Center, manually assigned subset]]

	The dimension “P&L structure” is not required any more and deleted.		The dimension “P&L structure” is not required any more and deleted.
Line 175:		Line 175:
	You will see the following screen:		You will see the following screen:

	[[image:Fw_BI_Center dimensions.jpg\|thumb\|center\|Framework, BI ~~Centre~~, dimensions]]		[[image:Fw_BI_Center dimensions.jpg\|thumb\|center\|Framework, BI Center, dimensions]]

	====Properties in the “Dimensions” tab====		====Properties in the “Dimensions” tab====
Line 219:		Line 219:
	The following screen shows up:		The following screen shows up:

	[[image:Fw_BI_Center Measure tab.jpg\|thumb\|center\|Framework, BI ~~Centre~~, “Measure” tab]]		[[image:Fw_BI_Center Measure tab.jpg\|thumb\|center\|Framework, BI Center, “Measure” tab]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 226:		Line 226:
	\|}		\|}

	[[image:Fw_BI_Center properties of a measure.jpg\|thumb\|center\|Framework, BI ~~Centre~~, properties of a measure]]		[[image:Fw_BI_Center properties of a measure.jpg\|thumb\|center\|Framework, BI Center, properties of a measure]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 241:		Line 241:
	\|}		\|}

	[[image:Fw_BI_Center Properties of a measure cumulated.jpg\|thumb\|center\|Framework, BI ~~Centre~~, Properties of a measure, cumulated]]		[[image:Fw_BI_Center Properties of a measure cumulated.jpg\|thumb\|center\|Framework, BI Center, Properties of a measure, cumulated]]

	====Properties in the “Measure” tab====		====Properties in the “Measure” tab====
Line 350:		Line 350:
	You are shown the following screen:		You are shown the following screen:

	[[image:Fw_BI_Center creating a calculated measure.jpg\|thumb\|center\|Framework, BI ~~Centre~~, creating a calculated measure]]		[[image:Fw_BI_Center creating a calculated measure.jpg\|thumb\|center\|Framework, BI Center, creating a calculated measure]]

	The second calculated measure should show this variance in percent.		The second calculated measure should show this variance in percent.
Line 371:		Line 371:
	\|}		\|}

	[[image:Fw_BI_Center creating a calculated measure in percent.jpg\|thumb\|center\|Framework, BI ~~Centre~~, creating the calculated measure “in percent”]]		[[image:Fw_BI_Center creating a calculated measure in percent.jpg\|thumb\|center\|Framework, BI Center, creating the calculated measure “in percent”]]

	To establish the variance, both absolute and in percent for the cumulated values, proceed exactly as explained in the previous steps. As a result, you get the following appearance.		To establish the variance, both absolute and in percent for the cumulated values, proceed exactly as explained in the previous steps. As a result, you get the following appearance.
Line 405:		Line 405:
	In this tab, the result of the CoPlanner cube is displayed. In the tree on the left, the available dimensions and measures are displayed. They can be added to the analysis as a filter or measure by dragging and dropping or with a mouse click. The right part shows general properties of the analysis.		In this tab, the result of the CoPlanner cube is displayed. In the tree on the left, the available dimensions and measures are displayed. They can be added to the analysis as a filter or measure by dragging and dropping or with a mouse click. The right part shows general properties of the analysis.

	[[image:Fw_BI_Center Preview tab.jpg\|thumb\|center\|Framework, BI ~~Centre~~, “Preview” tab]]		[[image:Fw_BI_Center Preview tab.jpg\|thumb\|center\|Framework, BI Center, “Preview” tab]]


Line 420:		Line 420:
	\|}		\|}

	[[image:Fw_BI_Center Preview tab, select measure.jpg\|thumb\|center\|Framework, BI ~~Centre~~, “Preview” tab, select measure]]		[[image:Fw_BI_Center Preview tab, select measure.jpg\|thumb\|center\|Framework, BI Center, “Preview” tab, select measure]]

← Older revision		Revision as of 10:06, 19 July 2010
Line 8:		Line 8:


	[[image:Fw_BI_Center creating a new CoPlanner cube.jpg\|thumb\|center\|Framework, BI ~~Center~~, creating a new CoPlanner cube]]		[[image:Fw_BI_Center creating a new CoPlanner cube.jpg\|thumb\|center\|Framework, BI Centre, creating a new CoPlanner cube]]

	The dialog “CoPlanner cube” is displayed.		The dialog “CoPlanner cube” is displayed.

	[[image:Fw_BI_Center name of the CoPlanner cube.jpg\|thumb\|center\|Framework, BI ~~Center~~, name of the CoPlanner cube]]		[[image:Fw_BI_Center name of the CoPlanner cube.jpg\|thumb\|center\|Framework, BI Centre, name of the CoPlanner cube]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 21:		Line 21:
	The new CoPlanner cube object “;My P&L” is created and the CoPlanner cube designer is opened. The following screen is presented.		The new CoPlanner cube object “;My P&L” is created and the CoPlanner cube designer is opened. The following screen is presented.

	[[image:Fw_BI_Center CoPlanner cube designer.jpg\|thumb\|center\|Framework, BI ~~Center~~, CoPlanner cube designer]]		[[image:Fw_BI_Center CoPlanner cube designer.jpg\|thumb\|center\|Framework, BI Centre, CoPlanner cube designer]]

	The CoPlanner cube designer contains four tabs.		The CoPlanner cube designer contains four tabs.
Line 64:		Line 64:
	You can change the width of the tree by clicking on the right edge with the left mouse button. With the button held down, make the area bigger or smaller.		You can change the width of the tree by clicking on the right edge with the left mouse button. With the button held down, make the area bigger or smaller.

	[[image:Fw_BI_Center changing the width of the object tree.jpg\|thumb\|center\|Framework, BI ~~Center~~, changing the width of the object tree]]		[[image:Fw_BI_Center changing the width of the object tree.jpg\|thumb\|center\|Framework, BI Centre, changing the width of the object tree]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 71:		Line 71:
	\|}		\|}

	[[image:Fw_BI_Center Structure and object selection .jpg\|thumb\|center\|Framework, BI ~~Center~~, Structure and object selection ]]		[[image:Fw_BI_Center Structure and object selection .jpg\|thumb\|center\|Framework, BI Centre, Structure and object selection ]]

	====Properties in the “Data sources” tab====		====Properties in the “Data sources” tab====
Line 77:		Line 77:
	In the right part of the Designer, the properties of the data objects are shown.		In the right part of the Designer, the properties of the data objects are shown.

	[[image:Fw_BI_Center property of the data object.jpg\|thumb\|center\|Framework, BI ~~Center~~, property of the data object]]		[[image:Fw_BI_Center property of the data object.jpg\|thumb\|center\|Framework, BI Centre, property of the data object]]

	'''Alias'''		'''Alias'''
Line 132:		Line 132:
	The “Dimensions” tab shows all dimensions assigned to the data objects, whereas identical dimensions contained in the data objects are connected and assigned. Assigned dimensions are indicated with a green check [[Image:Icon_Haekchen.jpg]], non-assigned dimensions or dimensions that cannot be assigned are shown on a grey background.		The “Dimensions” tab shows all dimensions assigned to the data objects, whereas identical dimensions contained in the data objects are connected and assigned. Assigned dimensions are indicated with a green check [[Image:Icon_Haekchen.jpg]], non-assigned dimensions or dimensions that cannot be assigned are shown on a grey background.

	[[image:Fw_BI_Center Dimensions tab.jpg\|thumb\|center\|Framework, BI ~~Center~~, Dimensions tab]]		[[image:Fw_BI_Center Dimensions tab.jpg\|thumb\|center\|Framework, BI Centre, Dimensions tab]]

	You can break an assignment [[Image:Icon_Haekchen.jpg]] of the dimension by clicking on the corresponding element. In the same manner, you can also re-establish an assignment.		You can break an assignment [[Image:Icon_Haekchen.jpg]] of the dimension by clicking on the corresponding element. In the same manner, you can also re-establish an assignment.
Line 144:		Line 144:
	The following screen is presented.		The following screen is presented.

	[[image:Fw_BI_Center Adding a subset.jpg\|thumb\|center\|Framework, BI ~~Center~~, Adding a subset]]		[[image:Fw_BI_Center Adding a subset.jpg\|thumb\|center\|Framework, BI Centre, Adding a subset]]

	For both data objects, the assignment is shown on a grey background.		For both data objects, the assignment is shown on a grey background.
Line 155:		Line 155:
	A dialog to select the subset opens. Only the possible assignments are shown in black.		A dialog to select the subset opens. Only the possible assignments are shown in black.

	[[image:Fw_BI_Center possible assignments.jpg\|thumb\|center\|Framework, BI ~~Center~~, possible assignments]]		[[image:Fw_BI_Center possible assignments.jpg\|thumb\|center\|Framework, BI Centre, possible assignments]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 164:		Line 164:
	In the corresponding element, the “Manually assigned” [[Image:Icon_manuell_zugeordnet.jpg]] icon is displayed. This data object is now linked with this subset.		In the corresponding element, the “Manually assigned” [[Image:Icon_manuell_zugeordnet.jpg]] icon is displayed. This data object is now linked with this subset.

	[[image:Fw_BI_Center manually assigned subset.jpg\|thumb\|center\|Framework, BI ~~Center~~, manually assigned subset]]		[[image:Fw_BI_Center manually assigned subset.jpg\|thumb\|center\|Framework, BI Centre, manually assigned subset]]

	The dimension “P&L structure” is not required any more and deleted.		The dimension “P&L structure” is not required any more and deleted.
Line 175:		Line 175:
	You will see the following screen:		You will see the following screen:

	[[image:Fw_BI_Center dimensions.jpg\|thumb\|center\|Framework, BI ~~Center~~, dimensions]]		[[image:Fw_BI_Center dimensions.jpg\|thumb\|center\|Framework, BI Centre, dimensions]]

	====Properties in the “Dimensions” tab====		====Properties in the “Dimensions” tab====
Line 219:		Line 219:
	The following screen shows up:		The following screen shows up:

	[[image:Fw_BI_Center Measure tab.jpg\|thumb\|center\|Framework, BI ~~Center~~, “Measure” tab]]		[[image:Fw_BI_Center Measure tab.jpg\|thumb\|center\|Framework, BI Centre, “Measure” tab]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 226:		Line 226:
	\|}		\|}

	[[image:Fw_BI_Center properties of a measure.jpg\|thumb\|center\|Framework, BI ~~Center~~, properties of a measure]]		[[image:Fw_BI_Center properties of a measure.jpg\|thumb\|center\|Framework, BI Centre, properties of a measure]]

	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 241:		Line 241:
	\|}		\|}

	[[image:Fw_BI_Center Properties of a measure cumulated.jpg\|thumb\|center\|Framework, BI ~~Center~~, Properties of a measure, cumulated]]		[[image:Fw_BI_Center Properties of a measure cumulated.jpg\|thumb\|center\|Framework, BI Centre, Properties of a measure, cumulated]]

	====Properties in the “Measure” tab====		====Properties in the “Measure” tab====
Line 350:		Line 350:
	You are shown the following screen:		You are shown the following screen:

	[[image:Fw_BI_Center creating a calculated measure.jpg\|thumb\|center\|Framework, BI ~~Center~~, creating a calculated measure]]		[[image:Fw_BI_Center creating a calculated measure.jpg\|thumb\|center\|Framework, BI Centre, creating a calculated measure]]

	The second calculated measure should show this variance in percent.		The second calculated measure should show this variance in percent.
Line 371:		Line 371:
	\|}		\|}

	[[image:Fw_BI_Center creating a calculated measure in percent.jpg\|thumb\|center\|Framework, BI ~~Center~~, creating the calculated measure “in percent”]]		[[image:Fw_BI_Center creating a calculated measure in percent.jpg\|thumb\|center\|Framework, BI Centre, creating the calculated measure “in percent”]]

	To establish the variance, both absolute and in percent for the cumulated values, proceed exactly as explained in the previous steps. As a result, you get the following appearance.		To establish the variance, both absolute and in percent for the cumulated values, proceed exactly as explained in the previous steps. As a result, you get the following appearance.
Line 405:		Line 405:
	In this tab, the result of the CoPlanner cube is displayed. In the tree on the left, the available dimensions and measures are displayed. They can be added to the analysis as a filter or measure by dragging and dropping or with a mouse click. The right part shows general properties of the analysis.		In this tab, the result of the CoPlanner cube is displayed. In the tree on the left, the available dimensions and measures are displayed. They can be added to the analysis as a filter or measure by dragging and dropping or with a mouse click. The right part shows general properties of the analysis.

	[[image:Fw_BI_Center Preview tab.jpg\|thumb\|center\|Framework, BI ~~Center~~, “Preview” tab]]		[[image:Fw_BI_Center Preview tab.jpg\|thumb\|center\|Framework, BI Centre, “Preview” tab]]


Line 420:		Line 420:
	\|}		\|}

	[[image:Fw_BI_Center Preview tab, select measure.jpg\|thumb\|center\|Framework, BI ~~Center~~, “Preview” tab, select measure]]		[[image:Fw_BI_Center Preview tab, select measure.jpg\|thumb\|center\|Framework, BI Centre, “Preview” tab, select measure]]