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]