Skip to Content

Saving workbook as 1.x format using 2.x

Hi all,

Here i am going to talk about Handling 1.x documents using Analysis Office 2.x

In analysis office 2.0 whatever the workbooks you saved to Netweaver/BIP/local Platform it saves as 2.0 format by default. If you open 2.0 workbooks in 1.4 version then it will display below message and Analysis Office features will become inactive and disable

but still you want to use analysis office 2.0 and also want to enable the workbooks to work normally in 1.4 also, then you have an option to choose whether workbook should save as 1.x format or 2.x format while saving workbook to Netwevar/BIPlocal Platform.for this you need to enable settings

<SaveAs1xByDefault /> &<SupportsSaveAs1x />  to True like below

<SaveAs1xByDefault value="True"/>

<SupportsSaveAs1x value="True"/>

Please have a look at document more info on settings How to maintain Analysis Office 2.0 settings

<SaveAs1xByDefault value="True"/> enables the "Save workbook in 1.4 format by default" option in advanced settings


Once the option "Save workbooks in 1.4 format by default" set, if you save workbook using 2.0, it saves as 1.4 by default


<SupportsSaveAs1x value="True"/> enables the option "Save as 1.x Format" in save dialog



If you set "Save As 1.x Format", while saving workbook in 2.0  it saves as 1.4 format

If you uncheck "Save As 1.x Format"option workbook saves as 2.0 format

Note :

  1. if you save 2.0 workbook as 1.4 then 2.0 Specific features will be deleted in 1.4 (e.g : TableDesign features).
  2. Without above settings if you open 1.4 workbook in 2.0 and save it. By default workbook saves as 2.0 format
  3. saving workbooks as 1.4 format supports only from NW 701 on wards, if you try to save lower than 701 then it displays below message

Related Documents :

How to create HANA Http connection in local and consume in Analysis Office 2.0

How to create HANA Http in BIP and consume in Analysis Office 2.0

How to migrate ODBC reports to HANA HTTP reports

How to maintain Analysis Office 2.0 settings

Main fetaures in 2.0 :

Whats New In Analysis Office 2.0

Best Regards,

Subhash