Jul-14-2020, 04:21 PM
Hi All,
Anyone can suggest, simplified Python Code to find my recursion levels..!!!
I have attached the sample xml input and my output should be like below
<com.google.com.transformation.object.Formula>
<Measures>
<Name>Measure1</Name>
<Expression>(A/B)</Expression>
</Measures>
<Measures>
<Name>Measure2</Name>
<Expression>(Formula('Measure6'))/Formula('Measure9'))
)</Expression>
</Measures>
<Measures>
<Name>Measure3</Name>
<Expression>(Formula('Measure7')/Formula('Measure1')</Expression>
</Measures>
<Measures>
<Name>Measure4</Name>
<Expression>(Formula('Measure2')</Expression>
</Measures>
<Measures>
<Name>Measure5</Name>
<Expression>(Formula('Measure2')/Formula('Measure3')</Expression>
</Measures>
<Measures>
<Name>Measure6</Name>
<Expression>(A11+A12+B12)</Expression>
</Measures>
<Measures>
<Name>Measure7</Name>
<Expression>(A/B)</Expression>
</Measures>
<Measures>
<Name>Measure8</Name>
<Expression>(AB+BC+DA)</Expression>
</Measures>
<Measures>
<Name>Measure9</Name>
<Expression>(ABC+CDA+BCA)</Expression>
</Measures>
<Measures>
<Name>Measure10</Name>
<Expression>(Formula('Measure5')/Formula('Measure1')</Expression>
</Measures>
</com.google.com.transformation.object.Formula>[/input]
Anyone can suggest, simplified Python Code to find my recursion levels..!!!
I have attached the sample xml input and my output should be like below
Output:NameLevel1 Level2 Level3 Level4 Measure1 Measure2 Measure6 Measure2 Measure9 Measure3 Measure7 Measure3 Measure1 Measure4 Measure2 Measure6 Measure4 Measure2 Measure9 Measure5 Measure2 Measure6 Measure5 Measure2 Measure9 Measure5 Measure3 Measure7 Measure5 Measure3 Measure1 Measure6 Measure7 Measure8 Measure9 Measure10 Measure5 Measure2 Measure6 Measure10 Measure5 Measure2 Measure9 Measure10 Measure5 Measure3 Measure7 Measure10 Measure5 Measure3 Measure1 Measure10 Measure1[input]<?xml version='1.0' encoding='UTF-8' ?><com.google.com.transformation.object.Formula>
<Measures>
<Name>Measure1</Name>
<Expression>(A/B)</Expression>
</Measures>
<Measures>
<Name>Measure2</Name>
<Expression>(Formula('Measure6'))/Formula('Measure9'))
)</Expression>
</Measures>
<Measures>
<Name>Measure3</Name>
<Expression>(Formula('Measure7')/Formula('Measure1')</Expression>
</Measures>
<Measures>
<Name>Measure4</Name>
<Expression>(Formula('Measure2')</Expression>
</Measures>
<Measures>
<Name>Measure5</Name>
<Expression>(Formula('Measure2')/Formula('Measure3')</Expression>
</Measures>
<Measures>
<Name>Measure6</Name>
<Expression>(A11+A12+B12)</Expression>
</Measures>
<Measures>
<Name>Measure7</Name>
<Expression>(A/B)</Expression>
</Measures>
<Measures>
<Name>Measure8</Name>
<Expression>(AB+BC+DA)</Expression>
</Measures>
<Measures>
<Name>Measure9</Name>
<Expression>(ABC+CDA+BCA)</Expression>
</Measures>
<Measures>
<Name>Measure10</Name>
<Expression>(Formula('Measure5')/Formula('Measure1')</Expression>
</Measures>
</com.google.com.transformation.object.Formula>[/input]
