Framework:Macros - Revision history

Admin at 09:18, 12 September 2017

2017-09-12T09:18:35Z

← Older revision		Revision as of 10:18, 12 September 2017
Line 70:		Line 70:
	\|-		\|-
	\|Synchronize dataobject		\|Synchronize dataobject
	\|Forces the synchronization of an CoPlanner table or dimension and the SQL server before further CoPlanner ServerCommands are executed.		\|(9.5 HF 1.8)Forces the synchronization of an CoPlanner table or dimension and the SQL server before further CoPlanner ServerCommands are executed.
	\|-		\|-
	\|Complete pending calculations		\|Complete pending calculations

Admin at 09:18, 12 September 2017

2017-09-12T09:18:08Z

← Older revision		Revision as of 10:18, 12 September 2017
Line 68:		Line 68:
	\|Synchronize database		\|Synchronize database
	\|Forces the synchronization of the CoPlanner server and the SQL server before further CoPlanner ServerCommands are executed.		\|Forces the synchronization of the CoPlanner server and the SQL server before further CoPlanner ServerCommands are executed.
			\|-
			\|Synchronize dataobject
			\|Forces the synchronization of an CoPlanner table or dimension and the SQL server before further CoPlanner ServerCommands are executed.
	\|-		\|-
	\|Complete pending calculations		\|Complete pending calculations

Admin at 10:12, 20 November 2015

2015-11-20T10:12:35Z

← Older revision		Revision as of 11:12, 20 November 2015
Line 79:		Line 79:
	To change over to macro mode: MacroMode=1		To change over to macro mode: MacroMode=1
	To leave the macro mode: MacroMode=0		To leave the macro mode: MacroMode=0
			\|-
			\|OLAP refresh
			\|Macro command to update OLAP connections (connections from CoPlanner server to SSAS will be closed and rebuilt if necessary). In addition to updating the dimensions this command is directed to delete any possible ADOMD caches (Security). After restarting the client changed dimension members in CoPlanner should be obvious to the user.
			\|-
			\|Set Log Level
			\|For development purposes, all messages that are generated in the log can be shown in the console/Telnet in the Console. In real operation, it is not recommended because it can cause performance degradations.
			Configuration:
			[[image:Fw_Makrodesigner_Loglevel_setzen.jpg\|thumb\|center\|Framework, Macro - Loglevel configuration]]
	\|}		\|}

Admin at 14:05, 9 January 2013

2013-01-09T14:05:52Z

← Older revision		Revision as of 15:05, 9 January 2013
Line 188:		Line 188:
	If the option “Report in case of non-fulfillment” is activated, the user is shown the message with the corresponding text if the macro is aborted. If the option is not active, the macro will be aborted without further message.		If the option “Report in case of non-fulfillment” is activated, the user is shown the message with the corresponding text if the macro is aborted. If the option is not active, the macro will be aborted without further message.

	[[image:Fw_Batch_Designer_Fortsetzungsbedingung Meldung bei ~~Nichterfüllung~~.jpg\|thumb\|center\|Framework, Macro - Continuation condition - Message in case of non-fulfillment]]		[[image:Fw_Batch_Designer_Fortsetzungsbedingung Meldung bei Nichterfuellung.jpg\|thumb\|center\|Framework, Macro - Continuation condition - Message in case of non-fulfillment]]

Admin at 14:01, 9 January 2013

2013-01-09T14:01:05Z

← Older revision		Revision as of 15:01, 9 January 2013
Line 180:		Line 180:
	Whether the SQL query does not return a single line can be queried with the ‘ZERO’ constant.		Whether the SQL query does not return a single line can be queried with the ‘ZERO’ constant.

	[[image:Fw_Batch_Designer_Fortsetzungsbedingung Abfrage ob ~~Datensätze~~ geliefert werden.jpg\|thumb\|center\|Framework, Macro - Continuation condition - Query whether datasets are supplied]]		[[image:Fw_Batch_Designer_Fortsetzungsbedingung Abfrage ob Datensaetze geliefert werden.jpg\|thumb\|center\|Framework, Macro - Continuation condition - Query whether datasets are supplied]]

	Expressions can also receive CoPlanner session variables. Before the evaluation of the expression proper, these are replaced with the corresponding value. Session variables can also be used as a constant value.		Expressions can also receive CoPlanner session variables. Before the evaluation of the expression proper, these are replaced with the corresponding value. Session variables can also be used as a constant value.

Admin at 07:09, 6 March 2012

2012-03-06T07:09:52Z

← Older revision		Revision as of 08:09, 6 March 2012
Line 26:		Line 26:
	Various different server commands are available for choice		Various different server commands are available for choice

	{\| ~~cellspacing~~="~~1" cellpadding="3~~" width={{{breite\|80%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|80%}}}
	\|-		\|- {{Tabellentitel}}
	\| ~~style=background-color:#f6f6f6 \|'''~~Command~~'''~~		\| Command
	\| ~~style=background-color:#f6f6f6 \|'''~~Description		\| Description
	\|-		\|-
	\|DBC Execute Procedure		\|DBC Execute Procedure
Line 102:		Line 102:
	[[image:Fw_Makrodesigner_Makro Filter Editor01.png\|thumb\|center\|Framework, Macro – Filter - Editor]]		[[image:Fw_Makrodesigner_Makro Filter Editor01.png\|thumb\|center\|Framework, Macro – Filter - Editor]]

	{\| ~~cellspacing~~="~~1" cellpadding="3~~" width={{{breite\|50%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|50%}}}
	\|-		\|- {{Tabellentitel}}
	\| ~~style=background-color:#f6f6f6 \|'''~~Column~~'''~~		\| Column
	\| ~~style=background-color:#f6f6f6 \|'''~~Expression~~'''~~		\| Expression
	\|-		\|-
	\|Feld		\|Feld
Line 129:		Line 129:


	{\| ~~cellspacing~~="~~1" cellpadding="3~~" width={{{breite\|100%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|100%}}}
	\|-		\|-
	\|'''Error'''		\|'''Error'''

Admin at 09:43, 3 February 2011

2011-02-03T09:43:04Z

@@ Line 81: / Line 81: @@
 |}
-Example: Delete table datasets:
+===Example: Delete table datasets===
 The task is to use one macro in order to delete all datasets from a table that belong to the logged in plan.
@@ Line 95: / Line 95: @@
 If you need this filter several times, you can save it with the “Save filter” command and reinsert it with “Load filter”.
 ==Message==

Admin at 14:34, 28 July 2010

2010-07-28T14:34:43Z

← Older revision		Revision as of 15:34, 28 July 2010
Line 1:		Line 1:
	__TOC__		__TOC__
	A macro is a group of actions, each of which carries out a certain operation such as the opening of a form or the execution of a server command. With macros, you can automate tasks that need to be performed frequently. For instance, you can create a macro that executes an import, i.e. deletes data, ~~re-imports~~ them and then opens a report if a user calls it up through a menu item.		A macro is a group of actions, each of which carries out a certain operation such as the opening of a form or the execution of a server command. With macros, you can automate tasks that need to be performed frequently. For instance, you can create a macro that executes an [[Framework:Imports\|import]], i.e. deletes data, reimports them and then opens a report if a user calls it up through a menu item.

	To give properties to the macro, open the macro by clicking the “Design“ button, or by clicking on the context menu with the right mouse button, or by double-clicking the batch designer. With the “New” menu item, you can also create a new macro here.		To give properties to the macro, open the macro by clicking the “Design“ button, or by clicking on the context menu with the right mouse button, or by double-clicking the batch designer. With the “New” menu item, you can also create a new macro here.
Line 18:		Line 18:
	==NavAction==		==NavAction==

	With NavActions, you can open masks, dimensions etc. In addition, NavActions can also execute [[Framework:Formulae\|formulae]], imports etc. A description of all NavActions you find [[Framework:Navigation Actions\|here]].		With NavActions, you can open masks, dimensions etc. In addition, NavActions can also execute [[Framework:Formulae\|formulae]], [[Framework:Imports\|imports]] etc. A description of all NavActions you find [[Framework:Navigation Actions\|here]].

	[[image:Fw_Batch designer_NavAction.jpg\|thumb\|center\|Framework, NavAction]]		[[image:Fw_Batch designer_NavAction.jpg\|thumb\|center\|Framework, NavAction]]
Line 63:		Line 63:
	\|All datasets within the selected plan of a table are recalculated. In addition, XML filters for the datasets can be specified here..		\|All datasets within the selected plan of a table are recalculated. In addition, XML filters for the datasets can be specified here..
	\|-		\|-
	\|Start import on the Server		\|Start [[Framework:Imports\|import]] on the Server
	\|Starts an import object on the Server. As each import object returns a ‘successful’ message, this ‘successful’ message can be suppressed with the “Activate feedback” parameter.		\|Starts an import object on the Server. As each [[Framework:Imports\|import object]] returns a ‘successful’ message, this ‘successful’ message can be suppressed with the “Activate feedback” parameter.
	\|-		\|-
	\|Synchronize database		\|Synchronize database

Admin at 14:30, 28 July 2010

2010-07-28T14:30:53Z

← Older revision		Revision as of 15:30, 28 July 2010
Line 18:		Line 18:
	==NavAction==		==NavAction==

	With NavActions, you can open masks, dimensions etc. In addition, NavActions can also execute formulae, imports etc. A description of all NavActions you find [[Framework:Navigation Actions\|here]].		With NavActions, you can open masks, dimensions etc. In addition, NavActions can also execute [[Framework:Formulae\|formulae]], imports etc. A description of all NavActions you find [[Framework:Navigation Actions\|here]].

	[[image:Fw_Batch designer_NavAction.jpg\|thumb\|center\|Framework, NavAction]]		[[image:Fw_Batch designer_NavAction.jpg\|thumb\|center\|Framework, NavAction]]
Line 38:		Line 38:
	\|-		\|-
	\|Formula activate		\|Formula activate
	\|This ServerCommand can activate or deactivate formulae. In addition, the formula “Macro active” can be set.		\|This ServerCommand can activate or deactivate [[Framework:Formulae\|formulae]]. In addition, the formula “Macro active” can be set.
	\|-		\|-
	\|Activate formulae		\|Activate [[Framework:Formulae\|formulae]]
	\|Activates the CoPlanner formulae.		\|Activates the CoPlanner [[Framework:Formulae\|formulae]].
	\|-		\|-
	\|Deactivate formulae		\|Deactivate [[Framework:Formulae\|formulae]]
	\|Deactivates the CoPlanner formulae.		\|Deactivates the CoPlanner [[Framework:Formulae\|formulae]].
	\|-		\|-
	\|Reload PlanSecurity		\|Reload PlanSecurity
Line 68:		Line 68:
	\|Synchronize database		\|Synchronize database
	\|Forces the synchronization of the CoPlanner server and the SQL server before further CoPlanner ServerCommands are executed.		\|Forces the synchronization of the CoPlanner server and the SQL server before further CoPlanner ServerCommands are executed.
	Complete pending calculations Forces the execution of all pending calculations (formulae). Then a database synchronization is forced before further ServerCommands are executed.		\|-
			\|Complete pending calculations
			\|Forces the execution of all pending calculations ([[Framework:Formulae\|formulae]]). Then a database synchronization is forced before further ServerCommands are executed.
	\|-		\|-
	\|Execute formula		\|Execute formula
Line 74:		Line 76:
	\|-		\|-
	\|Change session parameter		\|Change session parameter
	\|Changes the session properties. Here it can be specified, for instance, that the session context is executed in macro mode so that subsequently further formulae will be executed whose property is set to ‘Execute in macro mode’. For this purpose, please specify the following parameters:		\|Changes the session properties. Here it can be specified, for instance, that the session context is executed in macro mode so that subsequently further [[Framework:Formulae\|formulae]] will be executed whose property is set to ‘Execute in macro mode’. For this purpose, please specify the following parameters:
	To change over to macro mode: MacroMode=1		To change over to macro mode: MacroMode=1
	To leave the macro mode: MacroMode=0		To leave the macro mode: MacroMode=0

Admin at 06:58, 7 May 2010

2010-05-07T06:58:53Z

← Older revision		Revision as of 07:58, 7 May 2010
Line 18:		Line 18:
	==NavAction==		==NavAction==

	With NavActions, you can open masks, dimensions etc. In addition, NavActions can also execute formulae, imports etc. A description of all NavActions you find [[Framework:Navigation ~~Action~~\|here]].		With NavActions, you can open masks, dimensions etc. In addition, NavActions can also execute formulae, imports etc. A description of all NavActions you find [[Framework:Navigation Actions\|here]].

	[[image:Fw_Batch designer_NavAction.jpg\|thumb\|center\|Framework, NavAction]]		[[image:Fw_Batch designer_NavAction.jpg\|thumb\|center\|Framework, NavAction]]