Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 2

changes.mady.by.user Eric BOLLE

Saved on

compared with

New Version Current

changes.mady.by.user ROLLIER, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2

Advanced Features

Convert to Formula

By converting all the fields in the crosstab into formulas, all the objects in the crosstab are deleted The result values called from the server with the formula are still displayed in the table.
In formula mode, you can use all Microsoft Excel formatting functions. With the deletion of the design item, the individual formatting of the data will not be overwritten by the standard formatting in the crosstab the next time you update this data.

Text that is normally not displayed because it occurs several times in a row or column, is now repeated in each cell automatically to produce valid formulas

Info
titleAdvantages with convert to formula
1.
  1. Create persistant individual cell
2.
  1. Insert blank rows or columns to make the display easier to read
3.
  1. Copy parts of the table to other cells in the workbook
4.
  1. Use data from multiple data providers when creating calculations
Note
titleConsequences with convert to Formula
1.
  1. Navigation with Drag & Drop is no longer possible
2.
  1. The context menu is not available
3.
  1. The number format in the cells is set to standard
4.
  1. The conversion can only be undone from the analysis ribbon
5.
  1. If the crosstab is save, it cannot be converted back to analysis mode

 

Add Additional Information via Formula

  1. Click the cell outside the crosstab and click the insert button  
  2. Select Analysis for the “Category” and choose a function in the Pop up
  3. Select a data source to apply the Formula.Type DS_1 the default data source formula Alias
 

Image Added

 

Image Removed

Alternatively , use the drag and drop solution :

  1. Click the Display tab and select “Information tab”

  2. Drag and drop any information from the Design Panel Information tab into an empty cell then save your workbook.

 

Image Modified

 



Filter component

You can add a special cell in the workbook which allows you to dynamically add filters on a dimension.

Image Modified

  1. Click a celloutside a crosstab 

  2. Click “Filter” tab and select a dimension (Note that this filter selection has a green arrow)

  3. Click the Filter Icon to change your filter 

Image ModifiedImage Modified

Create a Power Point Slide with dynamic results

This features allows you to embed a BW query result inside a power point slide. It is then possible to refresh the power point data by connecting to Analysis for Microsoft Power Point.

  1. Select a cell in the crosstab 
  2. Click “Create Slide” button  
  3. Log on to the BW server, enter your Password, press OK  
  4. Adjust your crosstab to your slide
  5. The crosstab had been added to your PPT slide

Image Removed

Once added in Power Point you can then use the normal tools to format the table.

Additional features for power point :

Image Removed

  • Select « Chart » to insert a Chart
  • Select « Info-Field » to add information in the slide
  • Select «  Fit Table » to allowed table split into multiple slide
  • Select «  Move to » to move to another slide
  • Another Analysis features: Insert A Data source / Prompt / …. 




Related Information

Image RemovedImage Removed

Image Removed