Display OutputLogicalSQL in Presentation Services for every Analysis

This is on of the most helpful options that helps a developer a lot.
We need to modify the instanceconfig.xml file to enable this feature.

Follow the below simple steps to enable it.

1.Find the instanceconfig.xml file take backup for safety.open the file.

2.Add the below XML code to the file and save it.

                     <TestAutomation>

                 <OutputLogicalSQL>true </OutputLogicalSQL>

                 </TestAutomation>

3.Restart the presentation services.


That's it,You are Done.

Convert columns into rows and vice-versa in Excel

We can chage the rows to columns and vice-versa very easily.

Follow the steps and get the result.

Step 1: Copy what ever you want to change.

Step 2 : Right click where you want to paste and select Paste Special


Step 3: Select Transpose option and click ok.


Thats it you're done