<div id="hauptseite">
<div class="hauptseite-oben" id="hauptseite-willkommen">
<div class="hauptseite-welcome">WELCOME</div>
<div class="inhalt">
<br>This portal provides news, information and support about CoPlanner. For a fast and successful entrance and to use the benefits of the CoPlanner products, this Online-help will be updated constantly and offers all about the innovations.

Do you have any questions or suggestions for improvement to this portal? Please don't hesitate to send us, thank you for your [mailto:support@coplanner.com?subject=CoPlanner%20Portal e-mail].

{|width="100%" |
<br>
<br>

</div></div>
<div class="inhalt"><div class="portale imagemap-inline" align="center"><div class="hauptseite-header-mitte" >[[Enterprise_Edition:Enterprise_Edition|ENTERPRISE EDITION]] · [[Framework|FRAMEWORK]] </div>
<div class="hauptseite-header-mitte" >[[Excel Client|EXCEL CLIENT]] · [[Word_Add-in|WORD ADDIN]] · [[PowerPoint_Add-in|POWERPOINT ADDIN]]</div>
[[Portal:Lists of topics|Lists of topics]] · [[Special:Allpages|Alphabetical index]] · [[:Category:Main Category|Articles in categories]]
</div>
<br>
<div class="intern">[mailto:support@coplanner.com?subject=CoPlanner%20Support Contact] </div></div><div></div>
|}

{|width="80%" |
|-
| <div class="hauptseite-header">TUTORIALS</div>
|-
| [[Image:Portal_Line.jpg|left]]
|-
| [[Image:Tutorials.jpg|left]]
|-
|[[Tutorial:Creating a new dimension element|Creating a new dimension element]]
|-
|[[Tutorial:Payment keys|Payment keys]]
|-
|[[Tutorial:Planning turnover on monthly basis|Planning turnover on monthly basis]]
|-
|[[Tutorial:Planning fixed personnel costs on monthly basis|Planning fixed personnel costs on monthly basis]]
|}

__NOTOC__ __NOEDITSECTION__</div>
<br>
[[de:CoPlanner-Portal]]

2021-10-07T11:40:42Z

Admin:

__TOC__

Session variables are properties.

{| class="wikitable" width="100%"
|- {{Tabellentitel}}
|width="200pt" |Name German
|Name English
|Description
|Data type
|-
|@Session_ID@
|
|ID of the current session (unique ID for each client logon)
|COPSYS_ID
|-
|@Session_User_ID@
|
|ID of the logged on user
|COPSYS_ID
|-
|@Session_Unternehmen_ID@
|@Session_Entity_ID@
|ID of the logged on company
|COPSYS_ID
|-
|@Session_Sprach_ID@
|@Session_Language_ID@
|ID of the logged on language
|COPSYS_ID
|-
|@Session_PLAN_ID@
|
|ID of the logged on [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_PLAN_WJ_Beginn@
|@Session_PLAN_PJ_Start@
|Beginn of the business year of the logged on [[Framework:Scenario_manager|scenario]] as text (Jan,...)
|Text
|-
|@Session_PLAN_Typ@
|
|Type of the logged on [[Framework:Scenario_manager|scenario]] ("Plan" or "Forecast")
|Text
|-
|@Session_PLAN_Name@
|
|Name of the logged on [[Framework:Scenario_manager|scenario]]
|Text
|-
|@Session_Bezugsplan1_ID@
|@Session_RelationPlan1_ID@
|ID of the relation plan 1 of the logged on [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_Bezugsplan2_ID@
|@Session_RelationPlan2_ID@
|ID of the relation plan 2 of the logged on [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_JP_DimJahr_Von@
|@Session_YP_DimYear_From@
|ID for the year of the planning start of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_JP_DimJahr_Bis@
|@Session_YP_DimYear_To@
|ID for the year of the planning end of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_JP_DimMon_Von@
|@Session_YP_DimMon_From@
|ID for the month of the planning start of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_JP_DimMon_CalcStart@
|@Session_YP_DimMon_CalcStart@
|ID of the first month with plan values (in the case of [[Framework:Scenario_manager|scenarios]], the first planning month, in the case of forecasts the last actual month +1)
|COPSYS_ID
|-
|@Session_JP_DimMon_Bis@
|@Session_YP_DimMon_To@
|ID for the month of the planning end of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_IST_Von@
|@Session_Actual_From@
|Actual data start of the logged on forecasts
|Datum
|-
|@Session_IST_Bis@
|@Session_Actual_To@
|Actual data end of the logged on forecasts
|Datum
|-
|@Session_IST_DimJahr_Von@
|@Session_Actual_DimYear_From@
|ID for the year of the start of the actual data of the current forecast
|COPSYS_ID
|-
|@Session_IST_DimJahr_Bis@
|@Session_Actual_DimYear_To@
|ID for the year of the end of the actual data of the current forecast
|COPSYS_ID
|-
|@Session_IST_DimMon_Von@
|@Session_Actual_DimMon_From@
|ID for the month of the start of the actual data of the current forecasts
|COPSYS_ID
|-
|@Session_IST_DimMon_Bis@
|@Session_Actual_DimMon_To@
|ID for the month of the end of the actual data of the current forecasts
|COPSYS_ID
|-
|@Session_MJP_DimJahr_Von@
|@Session_LTP_DimYear_From@
|ID for the year of the start of the multi-annual planning of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_MJP_DimJahr_Bis@
|@Session_LTP_DimYear_To@
|ID for the year of the end of the multi-annual planning of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_MJP_DimMon_Von@
|@Session_LTP_DimMon_From@
|ID for the month of the start of the multi-annual planning of the curent [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_MJP_DimMon_Bis@
|@Session_LTP_DimMon_To@
|ID for the month of the end of the multi-annual planning of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_TP_DimJahr_Von@
|@Session_DP_DimYear_From@
|ID for the year of the start of the daily planning of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_TP_DimJahr_Bis@
|@Session_DP_DimYear_To@
|ID for the year of the end of the daily planning of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_TP_DimMon_Von@
|@Session_DP_DimMon_From@
|ID for the month of the start of the daily planning of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|@Session_TP_DimMon_Bis@
|@Session_DP_DimMon_To@
|ID for the month of the end of the daily planning of the current [[Framework:Scenario_manager|scenario]]
|COPSYS_ID
|-
|
|@Session_Current_Month_ID@
|ID for the current month
|COPSYS_ID
|-
|
|@Session_Current_Quarter_ID@
|ID for the current quarter
|COPSYS_ID
|-
|
|@Session_Current_Year_ID@
|ID for the current year
|COPSYS_ID
|-
|
|@Session_Current_Day_ID@
|ID for the current day
|COPSYS_ID
|-
|@Session_MJP_Aktiv@
|@Session_LTP_Active@
|Indicates whether multi-annual planning is activated in the logged on [[Framework:Scenario_manager|scenario]](1 or 0)
|Bool
|-
|@Session_TP_Aktiv@
|@Session_DP_Active@
|Indicates whether daily planning is activated in the logged on [[Framework:Scenario_manager|scenario]](1 or 0)
|Bool
|-
|@Session_WebAppUrl@
|
|WebAppUrl, which is defined in de svrconfig, adopted that clients can access via that URL
|String
|}

__NOEDITSECTION__

[[Category:Framework|Session variables]][[Category:Framework Objects|Session variables]]
[[de:Framework:Session-Variablen]]

WebApps:Subset Maintenance

2021-09-02T08:41:24Z

Admin:

__TOC__

Subsets offer an individual view of dimensions. Any number of subsets can be compiled with elements from one dimension. If you'd like to generate or change a subset you need Power User rights. Then you can check out the subset.

[[image:Web_Subsets.jpg|thumb|center|Web, Substes]]

You see the subset itself on the left half of the screen.
By dragging from the right to the left side, individual dimension elements or entire (part) structures can be dragged to the subset. For this purpose, highlight the required elements, move the mouse over the icon of a highlighted element so that the mouse pointer turns into a hand and then drag the elements to the left window. Elements saved in the subset are checked.

In order to drag sum elements without their daughter elements to the subset, press down the “shift” key while you are moving them.
You can change the order of the subset elements using drag & drop.

New elements can be created in the subset (with the ribbon by clicking the “Create various elements” button).

{| {{Bausteindesign1}}
|-
| <span style="color: darkblue;">'''Hint'''</span>  Subsets are used only for the alternative arrangement or depiction of elements, but not for alternative hierarchies. Dragging new daughter elements below a parent element does not change its sum.
|}

=System requirements=

The requirements can be found [[WebApps:Requirements|here]].

=Invocation=
<WebAppUrl of server (replace "+" with Servername/IP address)>/DimensionEditor/?subsetid=<Subset name>

oder

<WebAppUrl of server (replace "+" with Servername/IP address)>/DimensionEditor/?subsetid=<COPSYS_ID of subset>

Example with name of subset:

<nowiki>https://server:4443/coplanner/DimensionEditor/?subsetidname=Sub_Bilanz</nowiki>

Invocation with e.g. Tiles should be done with Session-Variable @Session_WebAppUrl@. e.g.:

@Session_WebAppUrl@/DimensionEditor/?subsetid=Sub_Bilanz

===Extended Invocation===

:* hideSessionHeader: Defines if the session header should be visible or not (true fades out the Session-Header). Default while opening is false

=Menu=

{| class="wikitable" width="857"
|- {{Tabellentitel}}
| Button
| Action
|-
| [[Image:ReportViewer_CoPlanner.JPG]]
| Back to last page.
|-
| [[Image:ReportViewer_MenueOpenClose.JPG]]
| Open/Close of display text of menu.
|-
| [[Image:Web_Speichern.PNG]]
| Check-In/Out
|-
| [[Image:Web_Zuruecksetzen.PNG]]
| Reset of dimension
|-
| [[Image:Web_Checkout.PNG]]
| Saves all changes
|-
| [[Image:Web_Loeschen.PNG]]
| Deletes the selected element
|-
| [[Image:Web_NeuesElementEbenedarunter.PNG]]
| Creates new element on level below
|-
| [[Image:Web_NeuesElementGleicheEbene.PNG]]
| Creates new element on same level
|-
| [[Image:Web_NachLinksVerschieben.PNG]]
| Switch element to next higher level
|-
| [[Image:Web_NachRechtsVerschieben.PNG]]
| Switch element below element above
|-
| [[Image:Web_NachObenVerschieben.PNG]]
| Switch element up on same level
|-
| [[Image:Web_NachUntenVerschieben.PNG]]
| Switch element down on same level
|-
| [[Image:Web_Sortieren.PNG]]
| Sort dimension element in alphabetical order
|-
| [[Image:Web_Elemente_Synchronieren.PNG]]
| The elements below will applied and displayed automatically from the basic dimension. The elements will be displayed only in the masks and not in the subset.
|-
| [[Image:Web_Bezeichnung_Synchronisieren.PNG]]
| The name of the element will be applied dynamically from the dimension.
|-
| [[Image:Web_Suche.PNG]]
| Opens dialog field "Search"
|-
| [[Image:Web_AttributspaltenAnzeigen.PNG]]
| Shows attribute columns of dimension
|}

__NOEDITSECTION__

[[Category:WebApps|Subset Maintenance]]
[[de:WebApps:Subsetwartung]]

2020-08-06T08:54:53Z

Admin: Created page with "==Funktion== Available from CoP 10 HF 1.5 <span {{CoPFormel}}>FKT_TimeDimDatePart(<Time interval>,<ID of the time dimension>)</span> {| cla..."

==[[Framework:Formeln#Funktionen|Funktion]]==

Available from CoP 10 HF 1.5

<span {{CoPFormel}}>FKT_TimeDimDatePart(<Time interval>,<ID of the time dimension>)</span>

{| class="wikitable" width={{{breite|80%}}}
|- {{Tabellentitel}}
| width="150pt" |Parameter
| Description
|-
|Time interval
|Y for year, Q for quarter, M for month or D for day are supported
|-
|ID of the time dimension
|COPSYS_ID of the time dimension
|}
This function belongs to [[:Category:Functions_-_server-side|server-side functions]].

==Result==
Returns the choosen interval for the element of the time dimension.

==Examples==

FKT_TimeDimDatePart(Y,2010050304) returns the year -> 2010

FKT_TimeDimDatePart(Q,2010050304) returns the quarter -> 2

FKT_TimeDimDatePart(M,2010050304) returns the month -> 5

FKT_TimeDimDatePart(D,2010050304) returns the day -> 3

__NOEDITSECTION__

[[Category:Functions|TimeDimDatePart]]
[[Category:Functions_-_server-side|TimeDimDatePart]]
[[de:Framework:FKT TimeDimDatePart]]