QAAWS response XI 3.1 vs BI 4.1

[ivanov77]

Hello Guru!

I need help with next question!

If you see QaaWS response in XI 3.1, you see:

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Body>

      <runQueryAsAServiceResponse xmlns="ws_test_format">

         <table>

            <row>

               <Str_Value>0.00000026</Str_Value>

            </row>

            <row>

               <Str_Value>145.26574512</Str_Value>

            </row>

            <row>

               <Str_Value>1458.26522</Str_Value>

            </row>

            <row>

               <Str_Value>15417558.6904871</Str_Value>

            </row>

            <row>

               <Str_Value>145265745.12</Str_Value>

            </row>

            <row>

               <Str_Value>145265745.124568</Str_Value>

            </row>

         </table>

         <message/>

         <creatorname>Administrator</creatorname>

         <creationdate>2015-08-25T17:47:04.924</creationdate>

         <creationdateformated>08/25/2015 5:47:04 PM</creationdateformated>

         <description/>

         <universe>uTEST_ws_format</universe>

         <queryruntime>1</queryruntime>

         <fetchedrows>6</fetchedrows>

      </runQueryAsAServiceResponse>

   </soap:Body>

</soap:Envelope>

But when create the QAAWS with same data in BI 4.1 you can see:

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Body>

      <runQueryAsAServiceResponse xmlns="ws_test_format">

         <table>

            <row>

               <Str_Value>2.6E-7</Str_Value>

            </row>

            <row>

               <Str_Value>145.26574512</Str_Value>

            </row>

            <row>

               <Str_Value>1458.26522</Str_Value>

            </row>

            <row>

               <Str_Value>1.54175586904871E7</Str_Value>

            </row>

            <row>

               <Str_Value>1.45265745124568E8</Str_Value>

            </row>

         </table>

         <message/>

         <creatorname>Administrator</creatorname>

         <creationdate>2015-08-25T17:47:04.924</creationdate>

         <creationdateformated>08/25/2015 5:47:04 PM</creationdateformated>

         <description/>

         <universe>uTEST_ws_format</universe>

         <queryruntime>1</queryruntime>

         <fetchedrows>5</fetchedrows>

      </runQueryAsAServiceResponse>

   </soap:Body>

</soap:Envelope>

You can see that if data more then (or small then) 6 digit the QaaWS return data in scientific format (1.23E2)

Can you help me change this behaviour QaaWS in BI 4.1?

Best Regards

Andrey Ivanov

[Former Member]

Hello,

Can you please elaborate more ...

Where you used Qaaws connection ?

is that necessary to use Qaaws because it become legacy now and not to use recommended by SAP.

Regards,

Dhaval Dave

[ivanov77]

Hello Dave!

Thank you for your answer!

We have third-party software which use QaaWS.

This is program read answer from QaaWS XI 3.1 fine..

When we are migrate to BI 4.1 the QaaWS return big data some different format.. (all data when see it more 6 digit)..

And now we need to recompile our third-party software (it's difficult and expensive) or change QaaWS settings to return old XI 3.1 behavior.

Best Regards

Andrey

[Former Member]

Hello,

I don't know, how your third party tool is working through the QAAWS, So, I am not able to give you exact answer on it. but yes i can give you some idea that might be helpful to you.

like, you can use publish as web service (url can be generate through web intelligence report)

Or you can use another web application server using web deploy and check the scenario.

Regards,

Dhaval Dave

[former_member182521]

Have you tried to compare the property of the measure object in both the versions, especially for precision.

Thanks

Mani

[ivanov77]

Hello Mani!

Thank you for your answer.

Could you explain what measure objects you mean? In which application?

I need change retern xml with data from QaaWS.. Is it possible?

Best Reagrds

Andrey

[former_member182521]

I mean it is from universe.

[ivanov77]

I think this is QaaWS settings in Tomcat..

Something use function which automatic change format data if data view more then 6 digit..

Best regards

Andrey Ivanov