Excel Client:Options dialogue - Revision history

Admin at 15:50, 21 August 2013

2013-08-21T15:50:13Z

← Older revision		Revision as of 16:50, 21 August 2013
Line 18:		Line 18:
	{\| {{Bausteindesign1}}		{\| {{Bausteindesign1}}
	\|-		\|-
	\| <span style="color: darkblue;">'''Hinweis'''</span>  The function "Data inputting to database" can only activated by the PowerUser.		\| <span style="color: darkblue;">'''Hinweis'''</span>  The function "Data inputting to database" can only be activated by the PowerUser.
	\|}		\|}

Admin at 15:44, 21 August 2013

2013-08-21T15:44:04Z

← Older revision		Revision as of 16:44, 21 August 2013
Line 18:		Line 18:
	{\| {{Bausteindesign1}}		{\| {{Bausteindesign1}}
	\|-		\|-
	\| <span style="color: darkblue;">'''Hinweis'''</span>  The ~~writeback~~ function can only activated by the PowerUser.		\| <span style="color: darkblue;">'''Hinweis'''</span>  The function "Data inputting to database" can only activated by the PowerUser.
	\|}		\|}

Admin at 15:40, 21 August 2013

2013-08-21T15:40:51Z

← Older revision		Revision as of 16:40, 21 August 2013
Line 13:		Line 13:
	#'''Data inputting to database:''' When this option is checked, it is possible to write values from Microsoft Excel into the CoPlanner server based on a CellRead formula.		#'''Data inputting to database:''' When this option is checked, it is possible to write values from Microsoft Excel into the CoPlanner server based on a CellRead formula.
	#'''Data input in dynamic mode:''' When this option is checked, it is possible to input data in dynamic mode.		#'''Data input in dynamic mode:''' When this option is checked, it is possible to input data in dynamic mode.



	{\| {{Bausteindesign1}}		{\| {{Bausteindesign1}}

Admin at 15:40, 21 August 2013

2013-08-21T15:40:40Z

← Older revision		Revision as of 16:40, 21 August 2013
Line 13:		Line 13:
	#'''Data inputting to database:''' When this option is checked, it is possible to write values from Microsoft Excel into the CoPlanner server based on a CellRead formula.		#'''Data inputting to database:''' When this option is checked, it is possible to write values from Microsoft Excel into the CoPlanner server based on a CellRead formula.
	#'''Data input in dynamic mode:''' When this option is checked, it is possible to input data in dynamic mode.		#'''Data input in dynamic mode:''' When this option is checked, it is possible to input data in dynamic mode.

			{\| {{Bausteindesign1}}
			\|-
			\| <span style="color: darkblue;">'''Hinweis'''</span>  The writeback function can only activated by the PowerUser.
			\|}

Admin at 06:27, 7 May 2010

2010-05-07T06:27:07Z

← Older revision		Revision as of 07:27, 7 May 2010
Line 6:		Line 6:

	#'''Automatic updating of the data after the change of a filter:''' When this option is checked, the current workbook is recalculated (F9) after you change a filter or after you open or close a dimension.		#'''Automatic updating of the data after the change of a filter:''' When this option is checked, the current workbook is recalculated (F9) after you change a filter or after you open or close a dimension.
	#'''Optimise CellRead formulas, join measures:''' Optimise: When this option is checked, fields (measures) are joined during server queries. Depending on the structure of the report, this can have negative or positive consequences. In the case of benchmark reports and large report workbooks with redundant queries, activating this option is not recommended. This will prevent measures from being joined during server queries, which results in smaller query packets.		#'''Optimise [[Excel_Client:CellRead\|CellRead]] formulas, join measures:''' Optimise: When this option is checked, fields (measures) are joined during server queries. Depending on the structure of the report, this can have negative or positive consequences. In the case of benchmark reports and large report workbooks with redundant queries, activating this option is not recommended. This will prevent measures from being joined during server queries, which results in smaller query packets.
	#'''Deactivate screen update while calculating:''' When this option is checked, the intermediate stage is not displayed when loading data (NaN as the result of CellRead formulas).		#'''Deactivate screen update while calculating:''' When this option is checked, the intermediate stage is not displayed when loading data (NaN as the result of CellRead formulas).

Admin at 13:36, 6 May 2010

2010-05-06T13:36:39Z

← Older revision		Revision as of 14:36, 6 May 2010
Line 6:		Line 6:

	#'''Automatic updating of the data after the change of a filter:''' When this option is checked, the current workbook is recalculated (F9) after you change a filter or after you open or close a dimension.		#'''Automatic updating of the data after the change of a filter:''' When this option is checked, the current workbook is recalculated (F9) after you change a filter or after you open or close a dimension.

	#'''Optimise CellRead formulas, join measures:''' Optimise: When this option is checked, fields (measures) are joined during server queries. Depending on the structure of the report, this can have negative or positive consequences. In the case of benchmark reports and large report workbooks with redundant queries, activating this option is not recommended. This will prevent measures from being joined during server queries, which results in smaller query packets.		#'''Optimise CellRead formulas, join measures:''' Optimise: When this option is checked, fields (measures) are joined during server queries. Depending on the structure of the report, this can have negative or positive consequences. In the case of benchmark reports and large report workbooks with redundant queries, activating this option is not recommended. This will prevent measures from being joined during server queries, which results in smaller query packets.

	#'''Deactivate screen update while calculating:''' When this option is checked, the intermediate stage is not displayed when loading data (NaN as the result of CellRead formulas).		#'''Deactivate screen update while calculating:''' When this option is checked, the intermediate stage is not displayed when loading data (NaN as the result of CellRead formulas).

Line 14:		Line 12:

	#'''Data inputting to database:''' When this option is checked, it is possible to write values from Microsoft Excel into the CoPlanner server based on a CellRead formula.		#'''Data inputting to database:''' When this option is checked, it is possible to write values from Microsoft Excel into the CoPlanner server based on a CellRead formula.

	#'''Data input in dynamic mode:''' When this option is checked, it is possible to input data in dynamic mode.		#'''Data input in dynamic mode:''' When this option is checked, it is possible to input data in dynamic mode.

Admin at 13:36, 6 May 2010

2010-05-06T13:36:29Z

← Older revision		Revision as of 14:36, 6 May 2010
Line 1:		Line 1:
	~~Die vom [[Excel_Client\|~~CoPlanner Excel Client~~]] zur Verfügung gestellten Optionen sind durch diesen Dialog einstellbar~~. ~~Sie finden diesen im Hauptmenü –~~ Administration ~~– Optionen~~.		In this dialogue you can edit the options that are available in the CoPlanner Excel Client. You can access this dialogue via the Main Menu / Administration / Options.

	~~Optionen~~:		Options:

	[[image:~~EC_Optionen~~.jpg\|thumb\|center]]		[[image:EC_Options.jpg\|thumb\|center]]

	#~~Automatisches Aktualisieren~~: ~~Ist diese Option gesetzt~~, ~~wird nach der Änderung eines Filters oder nach der Öffnen/Schließen einer Dimension, die aktuelle Arbeitsmappe neu gerechnet~~ (F9).		#'''Automatic updating of the data after the change of a filter:''' When this option is checked, the current workbook is recalculated (F9) after you change a filter or after you open or close a dimension.
	#CellRead Optimierung: Ist dies aktiv, werden auch Felder (Measures) bei Serveranfragen zusammengefasst. Je nach Datenaufbau des Berichts kann sich die negativ oder positiv auswirken. Bei Kennzahlenberichten oder großen Berichtsmappen mit redundanten Abfragen wird empfohlen, diese Option nicht zu setzen. In diesem Fall werden Felder bei Serverabfragen nicht zusammengefasst, was kleinere Abfragepakete zur Folge hat.
	~~#Screen Update bei Berechnungen deaktivieren: Ist dies aktiv, wird der Zwischenschritt beim Laden der Daten (NaN als Ergebnis von CellRead Formeln) nicht visualisiert~~.

	[[image:~~EC_Optionen02~~.jpg\|thumb\|center]]		#'''Optimise CellRead formulas, join measures:''' Optimise: When this option is checked, fields (measures) are joined during server queries. Depending on the structure of the report, this can have negative or positive consequences. In the case of benchmark reports and large report workbooks with redundant queries, activating this option is not recommended. This will prevent measures from being joined during server queries, which results in smaller query packets.
	#~~Schreiben in Datenbank~~: ~~Ist dies aktiv ist es möglich~~, ~~basierend auf einer CellRead – Formel, Werte aus~~ Microsoft Excel ~~heraus in den~~ CoPlanner ~~Server zu schreiben~~.
	#~~Datenerfassung~~ in ~~Analyzer~~: ~~Ist dies aktiv~~, ~~ist eine Eingabe (Datenerfassung) im Analyzer möglich. Dieser dient dann nicht nur mehr als Analyse-Browser, sondern auch als Eingabemaske~~.		#'''Deactivate screen update while calculating:''' When this option is checked, the intermediate stage is not displayed when loading data (NaN as the result of CellRead formulas).

			[[image:EC_Options02.jpg\|thumb\|center]]

			#'''Data inputting to database:''' When this option is checked, it is possible to write values from Microsoft Excel into the CoPlanner server based on a CellRead formula.

			#'''Data input in dynamic mode:''' When this option is checked, it is possible to input data in dynamic mode.

Admin: Created page with 'Die vom CoPlanner Excel Client zur Verfügung gestellten Optionen sind durch diesen Dialog einstellbar. Sie finden diesen im Hauptmenü – Administration – Op…'

2010-05-06T13:32:59Z

Created page with 'Die vom CoPlanner Excel Client zur Verfügung gestellten Optionen sind durch diesen Dialog einstellbar. Sie finden diesen im Hauptmenü – Administration – Op…'

New page

Die vom [[Excel_Client|CoPlanner Excel Client]] zur Verfügung gestellten Optionen sind durch diesen Dialog einstellbar. Sie finden diesen im Hauptmenü – Administration – Optionen.

Optionen:

[[image:EC_Optionen.jpg|thumb|center]]

#Automatisches Aktualisieren: Ist diese Option gesetzt, wird nach der Änderung eines Filters oder nach der Öffnen/Schließen einer Dimension, die aktuelle Arbeitsmappe neu gerechnet (F9).
#CellRead Optimierung: Ist dies aktiv, werden auch Felder (Measures) bei Serveranfragen zusammengefasst. Je nach Datenaufbau des Berichts kann sich die negativ oder positiv auswirken. Bei Kennzahlenberichten oder großen Berichtsmappen mit redundanten Abfragen wird empfohlen, diese Option nicht zu setzen. In diesem Fall werden Felder bei Serverabfragen nicht zusammengefasst, was kleinere Abfragepakete zur Folge hat.
#Screen Update bei Berechnungen deaktivieren: Ist dies aktiv, wird der Zwischenschritt beim Laden der Daten (NaN als Ergebnis von CellRead Formeln) nicht visualisiert.

[[image:EC_Optionen02.jpg|thumb|center]]
#Schreiben in Datenbank: Ist dies aktiv ist es möglich, basierend auf einer CellRead – Formel, Werte aus Microsoft Excel heraus in den CoPlanner Server zu schreiben.
#Datenerfassung in Analyzer: Ist dies aktiv, ist eine Eingabe (Datenerfassung) im Analyzer möglich. Dieser dient dann nicht nur mehr als Analyse-Browser, sondern auch als Eingabemaske.

__NOEDITSECTION__
[[Category:Excel_Client|Options dialogue]][[Category:Excel_Client_Dialogues|Options dialogue]]
[[de:Excel_Client:Optionen]]