Hi, this is simple document about the t-code UJKT and how can be useful to use this resource available in BPC NW.

Basically, UJKT it’s a testing tool. Dispenses execute a package in data manager to execute a logic script, hence reduces the develop/testing time. Besides has a complete log about the logic execution.

The UJKT transaction is divided in three frames:

  1. 1.    Settings;
  2. 2.    Action;
  3. 3.    Script code.

/wp-content/uploads/2012/08/imagem1_130345.png


The Settings frame is used to determine the environment and the model, as the image below:

 

/wp-content/uploads/2012/08/imagem2_130364.png

It is allowed also to simulate a variable created in data manager package. 

For that use the PARAM field to define Dynamic Script variables that will be used in the script

PARAM VAR1=MEMBER1;VAR2=MEMBER2

In the script text variables can be used like:

$VAR1$ and $VAR2$

The ability to pass PARAM’s to the script make it easy to test real scripts with $$ variables.

The Action frame contains the execution buttons, there are three of them:

/wp-content/uploads/2012/08/imagem3_130365.png


1 – VALIDATE, will just verify the code, but not execute it.

2 – EXECUTE, will validate, execute and write the records in the cube effectively.

3- EXECUTE(Simulate), will validate and execute the script,  but not write the result in the cube.

PS: In EXECUTE (Simulate), there is no detailed records list with values to be written, in opposite that occurs in EXECUTE.

In the Action frame, has also an input area, Data Region, where it determines variables of scope, simulating for example a package with the PROMPT statement selecting and restricting dimension members. This can be done with the dimension name, such as:

  1. i.e.: TIME = 2012.JAN

CATEGORY = ACTUAL

 

/wp-content/uploads/2012/08/imagem4_130366.png

The Script Code frame, placed on bottom of the transaction is divided into two. The first is an entry on the left side, where it is typed / pasted the logic script.


PS: If the script is saved on BPC Admin, you can also trigger it using the *INCLUDE statement to invoke it:

  • *INCLUDE your_Script.LGF


On the right is the log area, where is showed the calculations and results logs, or in case, the syntax error.

 

/wp-content/uploads/2012/08/imagem5_130370.png

Above the example uses the Data Region resource, in the scope *XDIM_MEMBERSET TIME = %TIME_SET%.

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Vadim Kalinin

    Hi Lucas,

    Please add to your very good document the explanation how to use the PARAM field in the Settings frame:

    In the PARAM field you can define Dynamic Script variables that will be used in the script

    PARAM VAR1=MEMBER1;VAR2=MEMBER2

    In the script text variables can be used like:

    $VAR1$ and $VAR2$

    The ability to pass PARAM’s to the script make it easy to test real scripts with $$ variables.

    For 3- EXECUTE(Simulate) – it can be mentioned, that opposite to 2-EXECUTE there is no detailed records list with values to be written.

    B.R. Vadim

    (0) 
  2. Pedro Santiesteban

    Hi Lucas,

    Nice document. Just be careful when using pretty print on your web interface and then taking your scripts to UJKT cause sometimes i get an error like this:

    UJK_VALIDATION_EXCEPTION:Line 52: Unknown or unimplemented keyword “”

    Even if the script validates correctly on the web. To solve it i just eliminate Tabs or additional spaces generated by the pretty print and it should work.

    Kind regards,

    Pedro

    (0) 

Leave a Reply