Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 2

changes.mady.by.user ROLLIER, Charlotte

Saved on

compared with

New Version Current

changes.mady.by.user Ousseina Kadri Dodo

Saved on

Key

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

The use of analysis is done mainly via the

ribbons

ribbon in excel

:
  • Analysis

Image Removed

  • Analysis Design

Image Removed

Individual

. Individual features in the ribbon are enabled or disabled based on the type of data displayed and selected (Greyed out if disabled).

Image Added



"Analysis" tab 

The Analysis tab contains the following groups:

SP Horizontal nav group
color#B3D4FF
SP Horizontal nav item
anchor660315823
nameData Source
GroupIconDescription

Image Added

Image Added

Insert Data source

Image Removed

Tab

Insert data from a source system into a crosstab

Image Added

Refresh All

Refresh all data sources. The data sources are updated with the corresponding data from the server and the crosstabs are redrawn

SP Horizontal nav item
anchor502849757
nameActions
GroupIconDescription

Image Added

Image Added

Undo

Undo last Analysis step

Image Added

Redo

Redo last Analysis step

SP Horizontal nav item
anchor1679116654
nameData Analysis

Image Removed

GroupIconDescription

Image Added

Image Added

Prompt

Enter values for Query parameters and variables

Image Added

Filter

Define filter criteria for data

Image Added

Sort

Sort data

Image Added

Hierarchy 

Define hierarchy options such as expansion level and parent member positions

Image Added

Calculations 

Define simple calculations (+,-,*,/) and dynamic calculations (for example, ranking and cumulation

SP Horizontal nav item
anchor958549854
nameDisplay
GroupIconDescription

Image Added

Image Added

Member Display

Configure display for members (key/text)

Image Added

Measure Display

Define display options for measures (for example, decimal places, scaling factors and currencies)

Image Added

Totals (Show, Hide)

Configure display, position and calculation of totals

SP Horizontal nav item
anchor537771500
nameComments
GroupIconDescription

Image Added

Image Added

Save Comment

Image Added

New Comment

Image Added

Delete Comment

Image Added

Show/Hide Comment
SP Horizontal nav item
anchor1934019453
namePlanning
GroupIconDescription

Image Added

Image Added

Save Data

Save plan values to InfoProvider

Image Added

Recalculate

Recalculate plan values

Image Added

Lock Cells

Lock and unlock input-ready cells

Image Added

Work Status

Change the work status of the data source/selected cells

Image Added

Display

Switch all data sources to display mode

Image Added

Change

Switch all data sources to change mode

Image Added

Back

Reset edited cells

SP Horizontal nav item
anchor405830946
nameDesign Panel
GroupIconDescription

Image Added

Image Added

Display

Show/ Hide Design Panel.  

Image Added

Pause Refresh

Activate/deactivate automatic refresh after each navigation step in the Design Panel.


"Analysis Design" tab 

The Analysis Design tab contains the following groups:

SP Horizontal nav group
color#B3D4FF
SP Horizontal nav item
anchor2099925287
nameInsert
GroupIconDescription

Image Added

Image Added

Chart

Insert dynamic chart

Image Added

Info Field

Insert information on data sources (for example, name and last data update)

Image Added

Filter

Insert component for simple data filtering

SP Horizontal nav item
anchor502849757
nameActions
GroupIconDescription

Image Added

Image Added

Undo

Undo last Analysis step

Image Added

Redo

Redo last Analysis step

SP Horizontal nav item
anchor2110055447
nameFormat
GroupIconDescription

Image Added

Image Added

Conditional Formatting 

Define rules for highlighting values using colors and symbols

Image Added

New Lines

Insert/delete new rows or new columns

Image Added

Format Cells

Format new cells or existing cells

Image Added

Crosstab

Configure display options for the crosstab.

The following options are available:

  • Apply Default Formats
  • Display Symbols for Parent Members
  • Optimum Cell Width/Height
  • Repeat Members

Image Added

Styles

Manage crosstab styles

SP Horizontal nav item
anchor64542286
nameBuild
GroupIconDescription

Image Added

Image Added

Combine

Group crosstabs or link dimensions

Image Added

Create

Create Local Provider

Image Added

Reload

Reload Local Provider

Image Added

Add

Add Local Provider to Data Source

SP Horizontal nav item
anchor80992699
nameTools
GroupIconDescription

Image Added

Image Added

Convert to Formula

Convert a crosstab into Excel formulas to retrieve the data.

Image Added

Create Web Application

Transfer components in an Analysis workbook to the SAP BusinessObject Design Studio to create a web application

Image Added

Launch Query Designer

Launch a query designer to check the query definition and to change the definition according to your needs

SP Horizontal nav item
anchor2666181
nameView
GroupIconDescription

Image Added

Image Added

Smart Copy

Copy data source to clipboard

Image Added

Smart Paste

Paste data source from clipboard as table

Image Added

Save View

Save data source as view

SP Horizontal nav item
anchor405830946
nameDesign Panel
GroupIconDescription

Image Added

Image Added

Display

Show/ Hide Design Panel.  

Image Added

Pause Refresh

Activate/deactivate automatic refresh after each navigation step in the Design Panel.


Related Information

Image Removed

Image Removed

Image Removed

Image Removed

Image Removed