Framework:BI Center:Create CoPlanner Cube - Revision history

Admin at 13:04, 8 February 2011

2011-02-08T13:04:40Z

← Older revision		Revision as of 15:04, 8 February 2011
Line 173:		Line 173:
	With the dialog “Select measure” [[Image:Icon_Spaltenauswahl.jpg‎]], you can now define the measures that are to be displayed as well as their order in the axis.		With the dialog “Select measure” [[Image:Icon_Spaltenauswahl.jpg‎]], you can now define the measures that are to be displayed as well as their order in the axis.
	\|}		\|}


			{\| {{Bausteindesign1}}
			\|-
			\| <span style="color: darkblue;">'''Hint'''</span>  CoPlanner offers the possibility to [[Framework:BI_Center:CoPlanner_Cube_show/hide\|hide CoPlanner cubes]].
			\|}


	__NOEDITSECTION__		__NOEDITSECTION__

Admin at 15:34, 24 November 2010

2010-11-24T15:34:16Z

@@ Line 149: / Line 149: @@
 [[Framework:BI_Center:CoPlanner Cube_-_Properties Measure|Properties in the “Measure” tab]]
 {| {{Bausteindesign2}}
 |-
-|<span style="color: darkblue">'''Entry'''</span> &nbsp;Activate the “Calculated measure” tab
+|<span style="color: darkblue">'''Entry'''</span> &nbsp;Activate the “Preview” tab
 |}

Admin at 15:25, 24 November 2010

2010-11-24T15:25:05Z

← Older revision		Revision as of 17:25, 24 November 2010
Line 82:		Line 82:

	[[Framework:BI_Center:CoPlanner Cube_-_Properties Dimensions\|Properties in the “Dimensions” tab]]		[[Framework:BI_Center:CoPlanner Cube_-_Properties Dimensions\|Properties in the “Dimensions” tab]]

	~~In the right part of the designer, the properties of the dimensions are shown.~~

	~~'''Caption'''~~

	~~This text is shown.~~

	~~'''Name'''~~

	~~The system name of the object.~~


	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
Line 159:		Line 148:
	\|}		\|}

	~~===~~Properties in the “Measure” tab~~===~~		[[Framework:BI_Center:CoPlanner Cube_-_Properties Measure\|Properties in the “Measure” tab]]

	In the right part of the designer, the properties of the measures are shown.		In the right part of the designer, the properties of the measures are shown.

Admin at 15:22, 24 November 2010

2010-11-24T15:22:44Z

← Older revision		Revision as of 17:22, 24 November 2010
Line 81:		Line 81:
	In the corresponding element, the “Manually assigned” [[Image:Icon_manuell_zugeordnet.jpg]] icon is displayed.		In the corresponding element, the “Manually assigned” [[Image:Icon_manuell_zugeordnet.jpg]] icon is displayed.

	~~===~~Properties in the “Dimensions” tab~~===~~		[[Framework:BI_Center:CoPlanner Cube_-_Properties Dimensions\|Properties in the “Dimensions” tab]]

	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.

Admin at 15:21, 24 November 2010

2010-11-24T15:21:06Z

← Older revision		Revision as of 17:21, 24 November 2010
Line 43:		Line 43:

	[[Framework:BI_Center:CoPlanner Cube_-_Properties Data sources\|Properties in the “Data sources” tab]]		[[Framework:BI_Center:CoPlanner Cube_-_Properties Data sources\|Properties in the “Data sources” tab]]

	~~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]]~~

	~~'''Caption'''~~

	~~This text is shown.~~

	~~'''Name'''~~

	~~The system name of the data source.~~

	~~'''Special'''~~

	~~'''CUSTOMROLLUP=LASTMONTHONYEAR;'''~~

	~~Overrides the annual value in the time dimension and instead shows the value of the last month of the year.~~

	~~'''CUSTOMROLLUP=FIRSTMONTHONYEAR;'''~~

	~~Overrides the annual value in the time dimension and instead shows the value of the first month of the year.~~

	~~'''CUSTOMROLLUP=LASTNONEMPTYMONTHONYEAR;'''~~

	~~Overrides the annual value in the time dimension and instead shows the value of the last non-empty month of the year.~~

	~~'''CUSTOMROLLUP=LASTCHILDONPARENT;'''~~

	~~Overrides the value of nodes on the time axis (or a time subset) and instead shows the value of the last leaf element.~~


	~~{\| {{Bausteindesign1}}~~
	\|-
	~~\| <span style="color: darkblue;">'''Hint'''</span>  Is applied when time subsets are used.~~
	\|}

	~~'''CUSTOMROLLUP=FIRSTCHILDONPARENT;'''~~

	~~Overrides the value of nodes on the time axis (or a time subset) and instead shows the value of the first leaf element.~~

	~~{\| {{Bausteindesign1}}~~
	\|-
	~~\| <span style="color: darkblue;">'''Hint'''</span>  Is applied when time subsets are used.~~
	\|}

Admin at 15:14, 24 November 2010

2010-11-24T15:14:56Z

← Older revision		Revision as of 17:14, 24 November 2010
Line 42:		Line 42:
	\|}		\|}

	~~===~~Properties in the “Data sources” tab~~===~~		[[Framework:BI_Center:CoPlanner Cube_-_Properties Data sources\|Properties in the “Data sources” tab]]

	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.

Admin at 14:04, 24 November 2010

2010-11-24T14:04:46Z

← Older revision		Revision as of 16:04, 24 November 2010
Line 297:		Line 297:
	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 tab01.jpg\|thumb\|center\|Framework, BI Center, “Preview” tab]]

Admin at 14:02, 24 November 2010

2010-11-24T14:02:18Z

← Older revision		Revision as of 16:02, 24 November 2010
Line 163:		Line 163:
	Move following measures from the data object tree in the working area by the order specified and rename them:		Move following measures from the data object tree in the working area by the order specified and rename them:
	Umsatzerloese_IST:		Umsatzerloese_IST:
	:*Menge: Quantity act. PY		:*Menge: Quantity act PY
	:*Preis: Price act. PY		:*Preis: Price act PY
	:*Umsatz absolut: Sales absolute act. PY		:*Umsatz absolut: Sales absolute act PY
	:*Umsatz:Sales act. PY		:*Umsatz:Sales act PY

	Umsatzerloese_Forecast:		Umsatzerloese_Forecast:
Line 199:		Line 199:
	\|-		\|-
	\|<span style="color: darkblue">'''Entry'''</span>  Enter following settings to these measures:		\|<span style="color: darkblue">'''Entry'''</span>  Enter following settings to these measures:
	:*Shift_Col: ~~Zeit~~		:*Shift_Col: Period
	:*Shift_Interval: -1		:*Shift_Interval: -1
	:*TimeDimType: Jahr		:*TimeDimType: Jahr
Line 308:		Line 308:
	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''Entry'''</span>  Assign the dimension “Products” to the vertical axis, ~~“Time”~~ to the horizontal axis. As a filter, choose “Plan”, “Forecast”, the “Company” and the “Cost Center” dimension.		\|<span style="color: darkblue">'''Entry'''</span>  Assign the dimension “Products” to the vertical axis, “Period” to the horizontal axis. As a filter, choose “Plan”, “Forecast”, the “Company” and the “Cost Center” dimension.
	With the dialog “Select measure” [[Image:Icon_Spaltenauswahl.jpg‎]], you can now define the measures that are to be displayed as well as their order in the axis.		With the dialog “Select measure” [[Image:Icon_Spaltenauswahl.jpg‎]], you can now define the measures that are to be displayed as well as their order in the axis.
	\|}		\|}

Admin at 13:56, 24 November 2010

2010-11-24T13:56:57Z

← Older revision		Revision as of 15:56, 24 November 2010
Line 308:		Line 308:
	{\| {{Bausteindesign2}}		{\| {{Bausteindesign2}}
	\|-		\|-
	\|<span style="color: darkblue">'''Entry'''</span>  Assign the dimension ~~“Sub_P&LACM”~~ to the vertical axis, “Time” to the horizontal axis. As a filter, choose “Plan”, the “Company” and the “Cost Center” dimension.		\|<span style="color: darkblue">'''Entry'''</span>  Assign the dimension “Products” to the vertical axis, “Time” to the horizontal axis. As a filter, choose “Plan”, “Forecast”, the “Company” and the “Cost Center” dimension.
	With the dialog “Select measure” [[Image:Icon_Spaltenauswahl.jpg‎]], you can now define the measures that are to be displayed as well as their order in the axis.		With the dialog “Select measure” [[Image:Icon_Spaltenauswahl.jpg‎]], you can now define the measures that are to be displayed as well as their order in the axis.
	\|}		\|}

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



	__NOEDITSECTION__		__NOEDITSECTION__

Admin at 13:55, 24 November 2010

2010-11-24T13:55:34Z

← Older revision		Revision as of 15:55, 24 November 2010
Line 30:		Line 30:
	::*[[image:Fw_BI_Center CoPlanner Würfel DesignerIcon04.jpg]] [[Framework:BI_Center:Create_CoPlanner_Cube#.E2.80.9CPreview.E2.80.9D_tab\|Preview]]		::*[[image:Fw_BI_Center CoPlanner Würfel DesignerIcon04.jpg]] [[Framework:BI_Center:Create_CoPlanner_Cube#.E2.80.9CPreview.E2.80.9D_tab\|Preview]]

	===“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 [[Framework:Tables\|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.
Line 42:		Line 42:
	\|}		\|}

	====Properties in the “Data sources” tab====		===Properties in the “Data sources” tab===

	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.
Line 90:		Line 90:


	===“Dimensions” tab===		==“Dimensions” tab==

	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.
Line 126:		Line 126:
	In the corresponding element, the “Manually assigned” [[Image:Icon_manuell_zugeordnet.jpg]] icon is displayed.		In the corresponding element, the “Manually assigned” [[Image:Icon_manuell_zugeordnet.jpg]] icon is displayed.

	====Properties in the “Dimensions” tab====		===Properties in the “Dimensions” tab===

	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.
Line 145:		Line 145:


	===“Measure” tab===		==“Measure” tab==

	In the “Measure” tab, you define which measures are shown.		In the “Measure” tab, you define which measures are shown.
Line 204:		Line 204:
	\|}		\|}

	====Properties in the “Measure” tab====		===Properties in the “Measure” tab===

	In the right part of the designer, the properties of the measures are shown.		In the right part of the designer, the properties of the measures are shown.
Line 293:		Line 293:
	\|}		\|}

	===“Preview” tab===		==“Preview” tab==

	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.