Jedox Web buttons in Jedox Ribbon

image_pdfimage_print

In the Jedox Web section of the Jedox Ribbon you can find the buttons Publish and Edit Jedox Spreadsheet. On the drop-down menu, you can find the commands Publish to Reports and Publish to Microsoft OneDrive.

With these commands, you can:

  • Store Excel files in the Jedox Web Report Designer
  • Load Jedox spreadsheets in Excel
  • Publish Excel files in Jedox Web Reports 
  • Store Excel files on Microsoft OneDrive

There are some limitations on which features/functions can be exported/imported. The main formats and PALO functions are supported.

To publish and to store Excel files in Jedox Web, or to load Jedox spreadsheets from Jedox Web in Excel, the connection to Jedox Web must meet the following conditions:

  1. A valid URL connection in the displayed format with a port specification.
  2. Valid user and password entries.
  3. The security token must match the entry CFG_SECRET in the file 
    …\Jedox Suite\httpd\app\etc\config.php.
  4. The connection must be Set as Default Connection.

Publish button 

The Publish button saves the current Excel sheet in the Report Designer of Jedox Web. You have the following options:

  • Convert to Jedox Web Spreadsheet: if checked, the file will be converted to WSS file; if not checked, the file will be saved as static XLSX file
  • Show log: sends a log file for the file conversion

Publish to Reports

The Publish to Reports command in the Publish drop-down menu immediately publishes the current Excel sheet in Jedox Web Reports. The file is stored as a WSS file in Published Reports > Published > Report Designer. This folder and folder group are created if they do not already exist.

Publish to Microsoft OneDrive

The Publish to Microsoft OneDrive command in the Publish drop-down menu stores the current Excel sheet as a file [filename]_OLAP_Snapshot.xlsx, in which PALO formulas are replaced with the current values. If this stored file is opened in a system with a corresponding Jedox installation, you receive the following dialog:

  • If you click Yes, you are reconnected with Jedox Server and Jedox attempts to restore the previous PALO formulas in Jedox View cells.
  • If you click No, the saved values will be displayed.

 

Edit Jedox Spreadsheet button 

This button opens the Report Designer of Jedox Web to load a Jedox Web spreadsheet in Excel.

image_pdfimage_print