Enterprise Edition:New in Enterprise Edition Version 9.5

From CoPlanner 10
Revision as of 11:50, 7 February 2017 by Admin (talk | contribs)

Jump to navigationJump to search

Content

  • Change to framework 4.6.2
  • REST Service
  • Tiles
  • Extension formula
  • Help pages
  • Macro with context
  • Excel Import
  • CSV Upload


Change to framework 4.6.2

That means that all devices on which clients and server are running have to have installed this framework. For use with web clients the AppPool has to be adjusted too.

REST Service

CoPlanner offers now a REST API which can be accessed. There are already new features which are based on this technology.

Tiles

You can find a description here.

Extension formula

Extension of group formula with GroupBeforeJoin and possibility of cumulation.

Formula has been extended by new formula type "group formula" in the last version.

This type summarizes rows which have the same dimension and the result will be further written. At the moment the calculation which is performed by data field is done for each row.

The possibility is required to aggregate data first to perform calculation on the aggregated data.

It is possible for each table which uses a group to:

  • Define filters for this table(similar to function FKT_Aggregat)
  • Define dimensions which will be used as base for grouping.

This is possible for the base table as well as for all tables which are joined to this table.

Syntax for all further source tables is:

tbTabellennameLtObv,tbTabellenAliasInJoin([Summenwertfeld1]$[Summenwertfeld2]#Filter1$Filter2#[GruppierungsFeld1]$[Gruppierungsfeld2]),NONE;

In formula using group formulas tables can be joined and expressions can be defined for it. Join is always performed with the equality sign.

Formula designer was extended so that the operater can also be selected in the join. These operators are supported:

  • =
  • <
  • >
  • <=
  • >=


Using this help simple cumulations can be created via group formulas.

Help pages

You can find a description here.


Adaption FKT_Abschreibung

FKT_Abschreibung changed his behavior in option "typed calculations" in fdrmulas. Non integer values for usage years are supported too.

Round is done internally and therefore these examples are produced:

1 year = 12 months

1,5 years = 18 months

1,502 years = 18 months

0,083333 years = 1 month

0,08 years = 1 month


"Declining": in "typed calculations" all parameter until half-year-rule are obligatory. Parameter for change linear/declining as also max. Phrase are without function.

Macro with context

If you execute a macro with an active context(e.g. a link) place holder in the format @Context.<filtername>@, for example @Context.COPSYS_ID@ will be replaced with these parameters:

  • Continuation condition

Example: Sql=select COUNT(*) from Tabelle where COPSYS_ID=@Context.COPSYSID@

  • NavAktion/Sonstige/BrowserWindow

Example: http://localhost:8058/@SessionID=@Session_ID@,@RecordID=@Context.COPSYSID@

  • ServerBefehl/DBC Execute Procedure (in parameter)

Example(in Stored-Procedure Parameter): @COPSYS_ID=@Context.COPSYSID@

  • NavAktion/Action which have a parameter window name

Mask for ID @Context.COPSYSID@

Example of a link which creates a context:

cop://name=Name der Aktion & aktion=Makro & p1=MakroKontext & p2= & p3= & p4=ContextFiltersetting:COPSYSID=636172261478600305=0=FilterText=COPSYS_ID & frmlocation=Struktur & bild=__PARAM_NOT_FOUND__ & info=__PARAM_NOT_FOUND__ & styledefinition=Blau Verlauf.maskskin & readonly=__PARAM_NOT_FOUND__

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Enterprise_Edition:New_in_Enterprise_Edition_Version_9.5&oldid=15769"