SAP BPC 10.1 Table in which controls are stored in BW

[Former Member]

Hello,

in terms of having a good overview - I would like to download a list of all implemented controls with their parameters.

I have already checked the following tables UJCTRL_CONTROL, UJCTRL_CONTROLT, UJCTRL_CTRL_SET, UJCTRL_CTRL_SETT, UJCTRL_CT_FILE, UJCTRL_CTRL_SET_AS but e.g. UJCTRL_CONTROL provides only some parts of each validation but that one I want to validate against is missing. What is the table in which this one is stored?

Thanks in advance.

Regards Malte

[former_member186338 · Accepted solution]

You have to create abap program to get the field content and parse xml.

[Former Member]

ok, thanks for your help.

[former_member186338]

Then select the correct answer and close the discussion!

[former_member186338]

Thanks a lot for NOT selecting any of my answers as answered!

And none as helpful (with upwote!)

[Former Member]

Honestly, this was my first qutestion on this site. Sorry for that.

I have selected one of your answers right now. In case, you want me to do anything else in terms of voting - please let me know and I will do.

[Former Member]

Hi Vadim,

thanks for your hint. Basically, this is a pain to copy the text out and I guess that there is no easier solution... otherwise you would have probably mentioned it. I set the Cursor in front of the first letter and used Shift + End as well as Ctrl + C

I noticed that the text I copied out is not complete - in the second row, I have one additional Dimension which is not provided. It stops with "Interco" Dimension but I have one additional Dimension behind.

Do you have any idea?

[former_member186338]

Please look on the FULL text in EXPRESSION field (long!):

[former_member186338]

Sample of full text:

<?xml version="1.0" encoding="utf-16"?>
<ns2:ujctrl_expression xmlns:ns2="http://xml.sap.com/2010/02/bpc/controls">
<ns2:expression>
<ns2:leftExpression><ns2:operand rank="0" sign="+" multiply="x" value="1">
<ns2:tupple>
<ns2:dimensionMember dimensionId="ACCOUNT" memberId="SCF2010"/>
<ns2:dimensionMember dimensionId="AUDIT_TRAIL" memberId="ALL_INPUT"/>
<ns2:dimensionMember dimensionId="FLOW" memberId="F99"/>
<ns2:dimensionMember dimensionId="INTERCO" memberId="I_NONE"/>
</ns2:tupple>
<ns2:multiply>x</ns2:multiply>
</ns2:operand></ns2:leftExpression>
<ns2:rightExpression><ns2:operand rank="0" sign="+" multiply="x" value="1">
<ns2:tupple>
<ns2:dimensionMember dimensionId="ACCOUNT" memberId="TP500"/>
<ns2:dimensionMember dimensionId="AUDIT_TRAIL" memberId="ALL_INPUT"/>
<ns2:dimensionMember dimensionId="FLOW" memberId="F10"/>
<ns2:dimensionMember dimensionId="INTERCO" memberId="I_NONE"/>
</ns2:tupple>
</ns2:operand></ns2:rightExpression>
</ns2:expression></ns2:ujctrl_expression>

[Former Member]

Hello Vadim,

what do you mean with XML Expression?

I did the following:

1. I opened the UJCTRL_CONTROL table

2. I selected Appset_ID and Application ID

3. the result provides for each control ID one row with Validation Parameters (e.g. Equation_Type, Breakdown Dimension, etc.) and another row with the prefix XML and some Dimension members of the first part of the Validation behind.

Regards Malte

[former_member186338]

Have you explored the xml EXPRESSION in UJCTRL_CONTROL?