orkungedik/SAP-basis-dataset huggingface dataset:
## 4.10.8  To switch between display and change mode
When you work with input-ready data sources, Analysis offers two different modes: display mode and change mode. You use change mode to enter planning data and to recalculate or save the changed data to the backend system. If a user is working with an input-ready data source in change mode, this data source is locked for the other users. If the user switches to display mode, another user can work with this data source in change mode.
When you open a workbook containing input-ready data sources, the crosstabs of these data sources are displayed in change mode. If you select the check box Switch All Data Sources to Change Mode for Initial Refresh on the components tab in the design panel when saving a workbook, the workbook will be opened in display mode. The data sources will be switched to change mode with the initial refresh automatically.
In change mode, new lines for planning are added to the bottom of the crosstab, and read-only cells of the data source are displayed with different background colors. The Plug-in includes SAP standard styles for the visualization (SAPEditableDataCell, SAPEditiableDataTotalCell, SAPReadonlyDataCell and SAPReadonlyDataTotalCell). You can change the cell styles as required. In display mode, the distinct visualization of input-ready and read-only cells is not visible.
## Switch to display mode
You work in a workbook that includes input-ready data sources.
1. Enter or change planning data.
2. Choose Display to switch to display mode.
3. A dialog box asks if you want to save your changes before switching to display mode. Press Yes to save your changes or No to discard them.
The data sources are switched to display mode. The distinct visualization of input-ready and read-only cells is not visible any more and the new lines at the bottom of the crosstab are deleted. The data sources can now be used in change mode by another user.
You can also use the PlanDataToDisplayMode command from API method SAPExecuteCommand to switch to display mode.
## Switch to change mode
You work in a workbook that includes input-ready data sources. You are currently working in display mode.
1. Check on the Components tab in the design panel that the correct planning system is connected.
2. Check on the Components tab in the design panel that the check box Planning: Open Data Source InputEnabled is selected for the data sources you want to change.
## 3. Choose Change to switch to change mode.
All data sources in the workbook that are available in the selected planning system and are selected as input-enabled are switched to change mode. The distinct visualization of input-ready and read-only cells is applied, and the new lines are added at the bottom of the corresponding crosstabs.
##  Note
If a data source is locked by another user, a message is displayed.
You can also use the PlanDataToChangeMode command from API method SAPExecuteCommand to switch to change mode.
## Related Information
The Components tab [page 148] SAP cell styles [page 56]
## 4.10.9  Editing short texts in queries
With release SAP BW 7.40 SPS08, you can edit short texts in input-ready queries. This enables you to use characteristics of a suitable InfoProvider as key figures in the query definition, in order to change characteristic values (for example, classifications) in queries or to write comments (short texts) on key figure values in queries.
In Analysis, you can select or modify characteristic values for classification, depending on the definition in the query designer. You can also enter or change short texts as comments in a query.
You can find more information about editing short texts in queries and the definition in the query designer, in the SAP BW documentation in the SAP Help Portal at Editing Short Texts in Queries.
## 5 Using Analysis in other SAP Applications
After performing an analysis, you might want to use other SAP applications to communicate your findings and share the analysis with others.
To use an analysis in other applications, you save it as an analysis view. An analysis view is a saved navigation state of an analysis including applied filters, hierarchies, and available metadata.
Analysis views can be saved with SAP Analysis for Microsoft Office and with SAP BusinessObjects Analysis, edition for OLAP. They can be inserted in both editions of SAP Analysis.
Like workbooks, analysis views are saved to the business intelligence platform server. While a workbook can comprise several analyses, an analysis view comprises just one.
If analysis views created with a 1.x Analysis version and containing SAP HANA data sources are available, you can use the Analysis View Migration dialog on the Conversion tab in the options dialog to migrate them to 2.x analysis views.
You can also export data sources from Analysis to the SAP BusinessObjects Design Studio and use it there for creating applications and dashboards.
## Related Information
To save an analysis view [page 224]
To insert an analysis view [page 225] Conversion Options [page 329]
## 5.1 To save an analysis view
## Prerequisites
You have to be connected to a business intelligence platform server.
## Procedure
1. In the worksheet, select the crosstab component that you want to save as an analysis view.
2. Choose Save View .
##  Note
If you are not connected to a BI platform server, the Save Query View dialog box appears to save a query view in the BW system.
3. Select the location to save your analysis view to.
4. Type a filename for the analysis view and press Save .
## Results
The analysis view is saved to the repository.
## 5.2 To insert an analysis view
## Procedure
1. In your worksheet, select the cell where you want to insert the analysis view.
2. Choose Insert Data Source Insert Analysis View .
If you are not already connected to a business intelligence platform server, connect to the server where the analysis view you want to open is saved.
##  Note
If you want to insert analysis views created with a 1.x Analysis version and containing SAP HANA data sources, you can use the Analysis View Migration dialog on the Conversion tab in the options dialog to migrate them to 2.x analysis views.
3. In the folder list, select an analysis view and press OK .
## Results
The selected analysis view is added to the worksheet. You can change the displayed data set and create new views on the data as required.
## Related Information
## Conversion Options [page 329]
## 5.3 To export a data source to SAP Lumira / SAP BusinessObjects Design Studio
## Prerequisites
To export a data source and use it in SAP Lumira / SAP BusinessObjects Design Studio, the following prerequisites have to be fulfilled:
- Make sure that you have installed SAP Analysis for Microsoft Office and SAP Lumira / SAP BusinessObjects Design Studio on your machine.
- Make sure that you use both tools in either local mode or with a BI platform. Otherwise you can not insert an exported data source.
## Context
SAP Lumira / Design Studio enables application designers to create analysis applications and dashboards for browsers and mobile devices on top of BW and SAP HANA data sources. In Analysis for Microsoft Office, you can use analysis methods that are not available in Lumira / design studio. For example, you can define calculations, conditional formatting and filters to change a data source. With exporting a changed data source to Lumira / design studio, you can use these changes in the data source also for the application design.
## Procedure
1. To export a data source to the design studio , select the crosstab of the corresponding data source.
2. Choose Smart Copy in the context menu.
3. Insert the data source in Lumira / Design Studio. For more information, see the corresponding Application Designer guide on the SAP Help Portal:
- SAP Lumira
- SAP BusinessObjects Design Studio
## 6 Customizing Analysis
In the Customizing area in the Analysis backstage menu, you have different options to customize Analysis according to your needs:
## · Customizing the User Interface
Here you can define the commands that you want be to see on the ribbon tabs. You can hide commands that you don't need. And you can also define new groups and commands whenever you need them.
## · Maintaining settings in Analysis
You can specify settings for the Analysis add-in, the Analysis plug-in and the BPC plug-in here.
## · Options
Here you can change user options according to your personal preferences. Depending on the selected platform, you might see only a subset of the described options.
## Related Information
Analysis in the File tab [page 8]
## 6.1 Customizing the User Interface
## 6.1.1  Introduction to Customizing the User Interface
## Why customize the user interface?
To meet your business profile needs, you want to display only the commands that you use the most, and hide those commands you use less often.
For example, you can customize the Analysis tab of the Ribbon by hiding the commands you do not need. You can add the groups and commands you use the most.
You customize the user interface by using profiles.
## Which areas of the user interface can you customize?
- In the Microsoft Excel version of Analysis, you can customize:
- The tabs of the Ribbon for the plug-ins installed (such as Analysis and BPC),
- The context menu for the plug-ins.
- The entries to the installed plug-ins in the File Menu.
- The tabs of the design panel for the Analysis plug-in.
- In the Microsoft PowerPoint version of Analysis, you can customize:
- The tabs of the Ribbon for the plug-ins installed (such as Analysis and BPC),
- The context menu (called from tables) for the plug-ins.
- The entries to the installed plug-ins in the File Menu.
Please note that Analysis, edition for SAP Analytics Cloud, does not include a PowerPoint version.
Therefore, you don't have this option when using the SAP Analytics Cloud edition.
## 6.1.2  Profiles
## What's a profile?
A profile is a set of user interface customizations.
Here are the several types of profiles that exist.
## Profile (or user profile)
When you create a profile using the dedicated dialog box, it is a user profile.
The profile is stored in your user information on your computer at the following location: C:\Users\[user] \AppData\Roaming\SAP\Cof\User Interface
- Standard Profile (read-only) . If you haven't made any customizations yet, the standard profile is applied by default. It is tagged with (read-only) and you cannot modify or delete it.
- Default profile. This is the profile you set as the profile to be applied the next time you open Analysis. As said above, as long as you haven't made any customizations, the standard profile is applied by default. See Setting a profile as a default profile [page 237].
- User profile tagged with (read-only) . So that users can share user profiles without having to make a copy of them, you can store user profiles in a specific dedicated folder: all the profiles are read-only. Using user profiles as read-only profiles [page 239].
## Company Profile
If you are an administrator, you can define a specific profile for your company and provide it to your end-users. This profile is tagged with 'Company' and cannot be deleted or modified by end-users.
Company default profile : you can set a default company profile to make sure that the end-users have at least one company profile applied.
Besides, you can impose the default company profile and not allow the end-users to create their own profiles. Therefore, they cannot access the User Interface Customization feature.
For further details, see Creating a Company Profile [page 238].
## Embedded Profile
An embedded profile is a user profile that is embedded in a workbook. When you provide the workbook to other users, the embedded profile applies by default. See Embedding a profile in a workbook [page 237].
## 6.1.3  Creating a profile
If you haven't made any customizations yet, the standard profile is applied by default. You can't modify or delete it. The standard profile is named Standard Profile (read-only).
But you can create other profiles, using the dedicated dialog box Customize User Interface .
## Where do you access the Customize User Interface dialog box?
Select File Analysis Customize Analysis Customize User Interface .
## How do you create a profile?
Using the dialog box Customize User Interface , you can create a profile by clicking Save As and then entering a name for your profile in the dialog box that appears.
##  Note
if you want this profile to be applied the next time you open Analysis, select the option Set as Default Profile . But you can always set later a profile as the default profile.
The name of profile you have just created is selected in the Profile dropdown list. You can now start to define the customizations you want: in the tabs of the Ribbon, in the context menus or in the Backstage view.
##  Note
the profile that is currently applied is displayed in the bottom-left part of the Customize User Interface dialog box.
## 6.1.3.3 How do you customize the File menu?
You can arrange, add or hide menu groups or commands as needed for the plug-ins in the File menu.
## Arrange
To arrange the columns, the groups or commands of a tab, you can do the following:
- Use the buttons Move Up and Move Down .
##  Note
Using the Move Up and Move Down buttons, you can move the elements only inside a node element.
- Use the drag-and-drop to move an element inside or outside a node element.
## Renaming columns
To rename the columns, the groups or commands of a tab, click the column and enter a text in the Label area.
## Show or hide
- To hide or display all the groups and commands of a tab, use the Show / Hide all Elements .
- To hide or display all the elements of a group or an element, select the group or element, then right click and use the commands Show all Elements of and Hide all Elements of .
- Select or deselect the checkboxes in the tree view.
## Add
You can create new tabs.
You can create the following in a tab: new sub-elements.
You can create the following types of sub-elements: menus under one of the columns, menu groups under menus, then buttons or toggle buttons under menu groups.
## How do you do it?
To create or delete new tabs, use the New Tab button (or the tab with the + icon) and the Delete Tab button. You can enter a name for a new tab and specify where to position it, before or after an existing tab (amongst the tabs that are natively delivered with Microsoft Excel).
To create or delete the groups or elements, use the New Sub-Element and Delete buttons or the same commands that you access from the context menu in the tree view of the tab.
## What elements can you create?
Here is the list of elements you can create, with their properties (that are explained below).
- Menu: label, description, image.
- Menu group: size.
- Button: identifier, label, description, macro, image, Leave Backstage View .
- Toggle button: identifier, label, description, macro (for the action), macro for the state of the button (pressed or not), image.
## What are the possible properties of the elements you create?
- Label: enter the name of the element as it will appear on the interface.
- Description: enter a text describing what is the aim of the element.
- Image: choose the image that you want to be displayed next to the label. The images are stored within the profile xml.
- Get Button State: macro that sets the state of the toggle button, pressed or not.
- Macro: see the Macro section here: How do you customize a tab in the Ribbon? [page 230].
- Display ID: see the ID section here: How do you customize a tab in the Ribbon? [page 230].
- Leave Backstage View : see the Leave Backstage View section below.
## Leave Backstage View
When you select this option, once you click the button you are currently creating, you leave the Backstage view.
## 6.1.3.4 How do you customize the Design Panel
You can show and hide tabs of the design panel as needed for the Analysis plug-in. By default, all tabs are shown in Analysis.
To show or hide a tab in the design panel, select or deselect the corresponding checkbox.
The following tabs are available for the design panel in the Analysis plug-in:
- Analysis
- Information
- Components
- Design Rules
- SAC Versions This tab is only displayed if a SAC data source is used.
- Comments
## 6.1.4  Renaming a profile
Select the profile you want to rename, then enter the new name and click Save .
## 6.1.5  Setting a profile as a default profile
To set a profile as the default profile:
- When creating a new profile, select the option Set as Default Profile . See Creating a profile [page 229].
- At any time, you can set a default profile by selecting the profile and clicking the appropriate icon (next to cross icon) in the upper part of the Customize User Interface dialog box.
The profile is applied the next time you open Analysis.
##  Note
As long as you haven't made any customizations, the standard profile is applied by default.
## 6.1.6  Embedding a profile in a workbook
You can embed a user profile in one or more workbooks. When you provide the workbook to other users, the embedded profile applies by default. You can also modify embedded profiles.
Note that you can only apply an embedded profile to workbooks that are saved locally.
When you open a workbook that has an embedded profile, a message appears in the Customize User Interface dialog.
##  Note
You can embed a profile only in workbooks with an Open XML format: xlsx and xlsm. This concerns all workbooks saved with Excel versions before version 97-2003.
## Why would you embed a profile in a workbook?
For example, for a viewer type of profile, you want all the greyed out buttons to be hidden.
When using a workbook in which a profile is embedded:
- The profile is applied and overrides all the other profiles that you can see in the profile dropdown list of the Customize User Interface dialog.
- You can still modify and create other user profiles, but you cannot apply them to this workbook.
## How do you embed a profile in one or more workbooks?
1. Make sure that the workbook(s) that is to get an embedded profile is saved locally.
2. Open an empty workbook and open Customize User Interface dialog.
3. Select the profile in the dedicated dropdown list, then do one of the following:
- To embed the profile in the current workbook, save the current workbook if not already, then select the icon Embed Profile , then Embed [profile name] in the Current Workbook [workbook name] .
- To embed the profile in one or more workbooks, then select the icon Embed Profile , then Embed [profile name] in one or more Workbooks . Select the workbooks, then click Embed Profile .
4. You can cancel the process by clicking the Cancel button that appears instead of the Close button during the embedding process.
5. You can upload the workbook(s) with the embedded profile to the server.
The embedded profile is applied to the selected workbook(s).
## How do you modify an embedded profile?
1. Make sure that the workbook(s) that contains the embedded profile is saved locally.
2. Open an empty workbook and open the Customize User Interface dialog.
3. Select the embedded profile in the dedicated dropdown list and change the user interface according to your needs.
4. Select Save to save your changes.
5. Select Embed Profile and apply the changed profile as embedded profile to the local workbook(s).
6. You can upload the workbook(s) to the server and overwrite the existing version with the changed embedded profile.
## 6.1.7  Creating a Company Profile
If you are an administrator, you can define a specific profile for your company and provide it to your end-users.
When you create a profile, it is a user profile that is stored locally at the following location: C:\Users\[user] \AppData\Roaming\SAP\Cof\User Interface.
## Making a profile a company profile
As an administrator, to make your profile a company profile, you take your profile from the above location and move it to the location for company profiles: C:\ProgramData\SAP\COF\User Interface. This is the default location.
When you open your application, the profile is tagged with 'Company' and cannot be deleted or modified by end-users.
## Setting a company profile as the default company profile
You can set a default company profile to make sure that the end-users have at least one company profile applied.
If there is a default company profile, the following rules apply:
- If you have set a user profile as the default profile, this user profile is applied,
- If not, the default company profile is applied,
- If there is no default company profile, the standard profile is applied.
To set a company profile as the default company profile, enter the path to the default company profile in the file Cof\_app.config located in C:\ProgramData\SAP\COF, using the following parameters:
- &lt;section name="AppBuilderExcelDefaultCompanyProfilePath" type="String" configurationLevel="PerMachine" /&gt;
- &lt;section name="AppBuilderPptDefaultCompanyProfilePath" type="String" configurationLevel="PerMachine" /&gt;
- &lt;section name="AppBuilderWrdDefaultCompanyProfilePath" type="String" configurationLevel="PerMachine" /&gt;
If needed, you can impose the default company profile and not allow the end-users to create their own profiles, so they cannot access the User Interface Customization feature.
To impose the default company profile and not give access to the User Interface Customization feature, set this parameter to False:
&lt;section name="CanCustomizeUserInterface" type="Boolean" configurationLevel="PerMachine" /&gt;
## 6.1.8  Using user profiles as read-only profiles
Read-only profiles behave just like user profiles, except that they cannot be modified.
Typically, you store read-only profiles in a shared folder so that other users can use the profiles.
To create a read-only profile, go to this configuration file: "C:\Users\
[User1]\AppData\Roaming\SAP\Cof\Cof\_user\_roaming.config"
- You enter the path to the folders that contain the user profiles you want to use as read-only profiles.
- If you enter several paths, enter ; between each path.
- Here is an example where I is a shared folder:
- If you use images in the read-only profiles, the images are stored within the profile xml.
```
<AppBuilderReadOnlyProfileDirectories value="I:\...\ReadonlyProfilesDirectory1;I:\...\ReadonlyProfilesDirectory2 "/>
```
You do not need to have administrator rights to manage read-only profiles.
## 6.2 Maintaining settings in Analysis
Besides maintaining settings directly in the file system, you can modify settings in the Analysis backstage area.
1. Open the Technical Configuration dialog.
Select File Analysis Adapt Analysis Technical Configuration .
While the dialog with all settings is loaded, you can already start the search for a specific setting and enter the setting name in the search field.
2. Display the settings you want to modify. You have the following options:
- Enter a setting name in the search field. The search is executed immediately and the settings are displayed accordingly.
- Select the configuration file prefix:
Ao for the Analysis plug-in, Bpc for the BPC plug-in and Cof for the Analysis Add-in. The setting are displayed according to their assignment in the file system.
3. Specify the settings to be displayed.
You have the following options:
- All Settings
All settings are displayed.
- All Settings Deviating from Default Value The settings that have already been modified are displayed.
- All Settings Containing a Value in File
All settings that contain a value in the corresponding file (e.g. Ao\_app.config) are displayed.
4. Modify a setting.
Change the default value for the setting. Depending on the type, you can select the check box for boolean values, enter an integer value or enter a text.
In the details view, you get the following information per setting:
- Type:
The type can be Bool for boolean values, Int32 for integer value or String for texts. For boolean values, the value is True if the check box is selected.
- Default:
The default value for the setting is displayed.
- Publish:
The value is always True . This means that the setting is public.
- Loaded From:
The path to the configuration file in the file system is displayed.
## · Allowed Configuration Level:
The configuration level can be UserRoaming or PerMachine .
A user can change settings with configuration level UserRoaming . The changed settings are stored in the file system under Users\&lt;UserID&gt;\AppData\Roaming\SAP\Cof . The file names for the changed settings are cof\_user\_roaming.config , ao\_user\_roaming.config and bpc\_user\_roaming.config . These files are created automatically if you change a setting in the Technical Configuration dialog. An administrator can also change settings with configuration level PerMachine . The changed settings are stored in the file system under C:\ProgramData\SAP\Cof . The file names are Cof\_app.config , Ao\_app.config and Bpc\_app.config .
As an administrator, you can also change the configuration level from UserRoaming to PerMachine for any setting. Then, these settings can no longer be changed by a user.
## · Config Prefix:
The prefix of the corresponding configuration file is displayed. The prefix can be Ao for the Analysis plug-in, Bpc for the BPC plug-in and Cof for the Analysis Add-in.
## 5. Press OK .
The changed setting values are executed.
The Analysis settings are modified according to your changes. The changed values are availabe in the Technical Configuration dialog and in the corresponding files in the file system.
## 6.3 Options
In Analysis for Microsoft Excel, you can change user options according to your personal preferences. The User Options dialog box is divided into the following tab pages, each providing different settings:
- User Options
- Advanced Options
- Platform Options
- Conversion Options
Depending on the selected platform, you might see only a subset of these tab pages or options.
To open the options dialog, select File Analysis Customize Anlaysis Options in the ribbon tab.
## Related Information
Advanced Options [page 326] Conversion Options [page 329]
## 6.3.1  User Options
On the User tab, you can define the following options.
## Recently Used List
When you choose Insert in the menu to insert a new data source into the workbook, you get a list of recently used data sources for quick selection. To define the number of listed data sources, enter the required number in the Maximum Number of Entries in Recent List field.
If you choose Delete Recently Used List , the history of recently used data sources is deleted.
## Number of Members Displayed in Filter Dialog
Here, you can enter the maximum number of members displayed in the Filter by Member dialog for selection. To define the number of members displayed, enter the required number in the Maximum Number of Members Displayed in Filter Dialog field. If you filter on a dimension that contains more members than defined in the user options, you see only the currently selected members, but you can search for all members.
##  Note
You can also define options at workbook level. These workbook properties are part of the Component tab in the design panel.
## Default Workbook Location
You can set the location of your default workbook. The default workbook is used when you open a data source by choosing Open Data Source . The data source is opened with the styles, formatting, and the workbook options of the default workbook.
## Related Information
The Components tab [page 148]
To insert a data source into a default workbook [page 31]
## 6.3.2  Advanced Options
On the Advanced tab, you can define the following options.
## Enhance Currency Conversion by Query Definition
Select this checkbox if you want the Use Currency Translation from Query Definition checkbox to be available in the currency translation dialog for measures.
## Show All Time-Dependent Hierarchies in Analysis Tab
Select this checkbox if all time-dependent hierarchies for a dimension should be available in the design panel. If this option is not selected, only the hierarchy for a selected period is available in the design panel.
## Transfer Filter Values while Assigning a Hierarchy
Select this checkbox to transfer filter values of a dimension as far as possible when a different hierarchy or a flat presentation is assigned to the dimension.
## Show Access Mode for Member Display
Select this checkbox to enable the access mode for the member display definition in the crosstab and for the 'Filter by Member' dialog. If this option is not selected, the access mode option is not displayed in the menu.
## Allow Client and Language Selection for SSO Logon
Select this checkbox if the Logon dialog box should be displayed when using SSO with BW systems (locally or on a SAP BW platform). In this logon dialog box, you can change the client and the logon language.
And when logging on to an SAP Analytics Cloud Live data connection, you get a dialog to select your desired logon language.
## Force Logon Dialog for SSO Logon on BIP
Select this checkbox if the Logon dialog box should be displayed when using SSO with the BI platform.
The last used BI platform is selected as default. In this logon dialog box, you can select one of the available BI platforms.
## 6.3.3  Platform Options
On the Platform tab, you can define the following options.
## Preferred Platform
You can select the following options:
- Selectable
This selection enables all platforms. You can save workbooks to all platforms and open workbooks from there.
- Business Intelligence Platform
This selection enables the SAP BusinessObjects Business Intelligence Platform. You can save workbooks to this platform and open workbooks from this platform only.
- If you use SAP BusinessObjects Business Intelligence platform 4.0, the workbook is saved as a Microsoft Excel object.
If you use SAP BusinessObjects Business Intelligence platform 4.1 or a higher version, the workbook is saved as an Analysis Workbook object.
- Business Warehouse
This selection comprises SAP BW and SAP BW4/HANA. You can save workbooks to these platforms and open workbooks from these platforms only.
## Comments Storage
You can select one of the following options to define where comments are stored:
- No Storage
- Business Intelligence Platform
- Business Warehouse
## Workbook Caching
Caching allows you to store copies of frequently used workbooks on a local client machine for quick access. In Analysis, caching can be used for documents that are stored on a SAP BW server. The documents will be cached for each server (BW system) independently.
To enable caching, the option Enable Workbook Caching must be selected. After the installation, the option is selected by default.
The default location for cached documents is the directory sapaocache which is located beneath the users Temp directory. You can change the Cache Location here.
To delete the cached documents, press Clear Cache .
You can also enable the option and change the folder path with the file system settings IsCachingDocuments and DocumentCacheFolderPath in the Ao\_app.config file. For more information, contact your IT administrator.
## Replace System
With this option, you can replace one or multiple systems in a workbook. The System Replacement... button to open the dialog is enabled if a workbook with a data source is opened but not connected to any of the systems.
For BW and HANA systems, you can replace local connections and connections from the BI platform. If a workbook contains BW and HANA connections, you will find two tabs in the dialog: BW and HANA.
In the dialog, select the system that should be replaced (Current System) and the system that should replace the former system (Replace By System).
To list the BIP connections in the Replace By System section, select the Logon to BIP icon and log on to the BI platform.
You can also open the dialog for replacing systems with the context menu on workbook level in the design panel.
## Related Information
Commenting data cells [page 206]
## 6.3.4  Conversion Options
On the Conversion tab, you can define the following settings.
## BEx Workbook Conversion
You can convert workbooks created with SAP BEx Analyzer 3.5 and SAP BEx Analyzer 7.0 to an Analysis workbook. You can specify which BEx objects should be converted and you can also specify whether a conversion log should be created.
## Option:
Conversion Settings
You can select the following settings:
- Convert All All objects in the workbook are converted.
- Convert Data Sources and Crosstabs Data sources and crosstabs are converted.
- Convert Data Sources Only Only the data sources are converted.
## Option: Refresh Workbook
You can select the followingoptions:
- Always The workbook is always refreshed after conversion.
- Never The workbook is not refreshed after conversion.
- Use Workbook Settings The workbook is refreshed after conversion if the corresponding property is active in BEx Analyzer.
## Setting: Conversion Log
You can select the following options:
- Disabled No conversion log is created.
- Create on New Visible Worksheet A log is created and displayed on a new worksheet.
- Create on New Hidden Worksheet A log is created and stored on a hidden sheet in the workbook.
## Option: Show Save Dialog After Conversion
If you select this option, the Save dialog is displayed after conversion.
## Analysis View Migration
You can use the Analysis View Migration dialog to migrate analysis views (which were created with Analysis version 1.x and which contain SAP HANA data sources) to 2.x analysis views.
SAP HANA ODBC connections that were used in previous Analysis releases (1.x) are no longer supported. Therefore, you cannot open an analysis view created with a 1.x version in Analysis 2.x. For Analysis 2.x versions, HTTP connections are used for SAP HANA data sources. With Analysis 2.3 and higher, you can migrate the analysis views.
After creating a SAP HANA HTTP connection, you can open the Analysis View Migration dialog and migrate the analysis views:
1. Log on to the BI platform.
2. Select a HANA ODBC connection.
3. Select a HANA HTTP connection.
4. Select the analysis view to be migrated. You can migrate one analysis view per migration.
5. Press Migrate
6. .
7. You can select another analysis view and start the migration again, or press Close to close the dialog.
The migrated analysis views can now be opened in Analysis.
##  Note
Migrated Analysis Views can no longer be used in Analysis 1.4. Furthermore, they cannot be used with other clients that use JDBC-based OLAP connections, such as Design Studio and Analysis, edition for OLAP.
## 7 Troubleshooting
## 1 SCENARIO
The Change and Transport System (CTS) of ABAP has been enhanced so that it can be used for transporting non-ABAP objects as well -this is known as CTS+ or enhanced CTS. In the remainder of this document, the abbreviation CTS is used for the system where the transport landscapes are configured and for the fact that CTS can also be used for non-ABAP transports.
In this guide, you can find information on how to use CTS for transporting applications running on the SAP BTP, Cloud Foundry environment. This guide shows step by step -including sample screenshots how the configuration is done. Afterwards you will be able to transport Cloud Foundry applications bundled in Multi-Target Application (MTA) archives to Cloud Foundry spaces. If you already use CTS, for example, to manage non-ABAP transports for applications like the SAP Enterprise Portal or to transport your BW ABAP objects, you might be interested in using the same tool to transport the Cloud Foundry content as well. With the integration of Cloud Foundry into CTS, this is now possible. You can model a landscape for your Cloud Foundry spaces in CTS like for any other non-ABAP application supported by CTS. When doing that, you associate logical systems in TMS to the spaces you have in Cloud Foundry.
Note that in the remainder of this document, the representations of the Cloud Foundry spaces in CTS will be called systems ( for example, logical non-ABAP system, source or export system, as well as target or import system) .
The following figure shows a sample transport route modeled in CTS+.

CTS does not limit your landscape to one source and one target system. All the options that you might know from TMS are available for systems associated with Cloud Foundry spaces as well. You can, for example, have several systems in a row or more than one target system at once.
To implement the scenario, you need a physical system where CTS is configured. For the setup described in this guide, you must use a SAP NetWeaver system on release 7.4 or higher.
In order to trigger the transport, you must create a transport request for the first system in the transport route (Dev in the example above) and attach the MTA archives that you want to transport to it using the Transport Organizer tool in CTS. Afterwards you need to release the transport request. You can then start the import into the next logical system from the transport route, which will trigger the import into the corresponding Cloud Foundry space.
## 2 BACKGROUND INFORMATION
- SAP Business Technology Platform documentation
- Guides for CTS
- Official MTA specification documents: The Multitarget Application Model v.2, The
- Multitarget Application Model v.3
- Documentation for CTS including CTS Plug-In
- Central note for CTS+: 1003674
- Security for the Enhanced Change and Transport System (CTS+)
## 3 PREREQUISITES
To be able to use CTS with SAP BTP, Cloud Foundry environment as described in this guide, your systems must fulfill the following prerequisites:
- CTS System: SAP NetWeaver 7.4 or higher
- If CTS System is on state lower than SAP NetWeaver 7.4 SP10: CTS plug-in installed on the CTS system (taken from the latest available SL Toolset 1.0 CTS plug-in). SAP Note for installing the SAP CTS Plug-In of SL Toolset: 1665940
- SAP Notes 2236955 and 1160362 must be applied to the CTS system.
## 4 RESTRICTIONS AND RECOMMENDATIONS
- You must use a system, such as the CTS system, which is on SAP NetWeaver 7.4 and at least on SP10 or has CTS plug-in installed (for SPs below SP10).
- The total size of all MTA archives in a single transport request cannot exceed 20GB.
- You can only use users from the default identity provider of SAP BTP -SAP ID service (See Default Identity Provider). For transport scenarios involving users from a custom identity provider, it is necessary to transition from on-prem CTS+ to SAP Cloud Transport Management (cTMS) service. SAP Cloud Transport Management service is continuously evolving alongside SAP BTP, whereas the CTS+ scenario remains in maintenance mode with no planned enhancements or new features. Upon switching to cTMS, you need to use Destinations using SAP Cloud Deployment Service with OAuth2Password authentication (See Creating Destinations Using SAP Cloud Deployment Service with OAuth2Password Authentication).
## 5 BASIC CONFIGURATION FOR CTS
You must do configurations on your CTS system and on the Cloud Foundry spaces to be able to use CTS. This chapter helps you with these configurations. It provides a step-by-step guide. (Remember: You may have to install the CTS plug-in on the CTS system.)
## Sample Landscape

In the sample landscape shown in the picture above, you can see three systems associated with Cloud Foundry spaces:
- BD3 represents the development CF space -also called export or source system
- BT3 is the test CF space -also called import or target system
- BP3 is the productive CF space -also called import or target system
This landscape is used as an example in the following chapters explaining the configuration.
## 5.2 Import SSL Certificate
The CTS system must validate the server certificate to ensure the server identity and to prevent manin-the-middle attacks. This means that the root certificate of the certificate authority that was used to sign the Cloud Foundry server certificate needs to be imported.
SAP offers a public GitHub repository called BTP Trust Store with current collections of the trusted Root CA certificates that are used by SAP BTP services and load balancers now and in the near future, as announced in SAP Note 3472211 . SAP recommends that customers proactively trust the centrally maintained collection of Root CAs marked as required. For more information, see Trust Store for SAP
## BTP.

2. Select the SSL client certificate list (Standard) on the left that you have specified in the previous chapter when setting up the HTTP connection:
3. Click the Import Certificate button in the bottom left:
4. In the dialog that opens, enter the file path of a required PEM certificate from BTP Trust Store:





5. Click Add to Certificate List and leave edit mode by clicking the Display &lt;-&gt; Change button at the top.
6. Make sure that all required PEM certificates from BTP Trust Store are imported.
7. Save the changes by clicking the Save button:
8. After the certificate is imported, the connection test for the connection in transaction SM59 should be successful:
## 5.3 Configuring the Transport Organizer Web UI

CTS provides Transport Organizer Web UI, an ABAP Web Dynpro application, which is used to get detailed information about transport requests (for example, default request, target systems) and to create transport requests and attach objects manually. You must activate the ICF service CTS\_ORGANIZER to run and use this application.
To use the Object List Browser to see a detailed list of objects attached to a transport request (as part of one file) you need to activate the ICF service CTS\_OBJECTLIST\_BROWSER .
For more details, refer to Activating Services for Transport Organizer Web UI.
If CTS+ is already in use on the CTS system where you are doing the configuration, the services should already be activated. If not, activate them now.
If you receive error messages when running this application later or if you don't want to activate all ICF services read the error messages carefully and activate the services named in the error messages via transaction SICF.
The following figure shows the Transport Organizer Web UI.



To open the Transport Organizer Web UI, go to transaction STMS in CTS system and click
## 6 CONFIGURE 'SCP\_CF' AS APPLICATION TYPE
To use CTS with Cloud Foundry, you must define an application type for Cloud Foundry in CTS. The application type will then be used as unique identifier for Cloud Foundry content in CTS. For the Cloud Foundry integration with CTS, the application type SCP\_CF is used.
Documentation on how to do this is provided on the SAP Help Portal under Configuring Source Systems for Further Applications.
The following steps describe how the application type is created and managed in CTS.
## 7 CONFIGURE THE CLOUD FOUNDRY TRANSPORT LANDSCAPE
The configuration of the Cloud Foundry transport landscape consists of several steps, which will be detailed in the following chapter.
As an example, we will set up a landscape of three systems as depicted in chapter Basic Configuration for CTS, i.e., a development system (BD3) as the source system, a test system (BT3) and a production system (BP3) as the target systems.
1. CTS identifies systems resp. transport nodes via 3-digit System IDs (SIDs). You cannot derive a SID from the Cloud Foundry space directly. Therefore, think at first about the 3-digit SIDs that you would like to use to identify your Cloud Foundry space.
## NOTE
SIDs consist of three characters (letters and / or numbers). They have to be unique within your transport domain, but they may be shared between different applications (i.e.  Portal and SLD if they run on same NW AS JAVA instance).
As an example, we will use BD3 (development system), BT3 (test system) and BP3 (production system) in the following.
2. As soon as you define the SIDs for your Cloud Foundry spaces, you can start creating the representations for these systems in TMS and connect them with the help of transport routes. Details are described in the Configure the Transport Landscape in TMS below.
## 7.1 Configuring the Transport Landscape in TMS
Create the individual spaces of your Cloud Foundry transport landscape as non-ABAP systems in TMS. These systems identified with the corresponding SIDs represent the Cloud Foundry spaces in TMS.
Documentation on how to create non-ABAP systems in TMS is provided on the SAP Help Portal under Defining and Configuring Non-ABAP Systems. This chapter shows how setting up the systems would work in our example.
## 7.1.1 Configuring the Development system (Export system)
Define a source system ('BD3') for your Cloud Foundry development space. You therefore must select the option 'Activate Transport Organizer' when creating the system representation in TMS.

Togged onto The domuin controller



All Cloud Foundry users that should be allowed to attach Cloud Foundry content to transport requests have to have a corresponding user in the client of the CTS system that you are using for transports (= the client where you activated the Transport Organizer Web UI). To transport non-ABAP objects, you can use the authorizations of the delivered role SAP\_CTS\_PLUS.

Do not use this role directly. Instead, use it as a template and copy it to your own role (Z\_*). More information on the creation and maintenance of roles in ABAP you can find  on the SAP Help Portal under Role Administration.
Also please read note 1003674 for recent updates on authorizations required for the different releases.
## 7.1.2 Configuring the Test and Production System (Import Systems)
All other systems of your Cloud Foundry landscape -like e.g. test and production systems ('BT3', 'BP3') must be defined as target systems. This chapter describes how this is done.





Create any other target system that you might need (e.g. for production system -'BP3') as shown before.
You can also extend the configuration of existing systems to be able to use them with new application types. To do so, do the following:




## NOTE
The parameters DEPLOY\_DATA\_SHARE and DEPLOY\_WEB\_SERVICE are not required if you configure CTS+ for HTTP-based deployment. Nevertheless, they are automatically added to newly created non-ABAP systems in any case. In case of CTS+ using HTTP-based deployment, these parameters are simply ignored at runtime. The same is valid for the parameter CTS\_FILE\_PROVIDER\_URI. There is no need to delete these parameters -neither if they were added automatically when you created the system nor if you decide to change the configuration of a certain non-ABAP system. The transport tool check will only report errors for these parameters if they are used for at least one transport configuration in the respective system.
You can check if the system can be reached: Return to system overview, select the target system, and check the import settings using SAP System → Check → Transport Tool . To get the details about reported errors for non-ABAP systems, go to transaction SA38 and execute the program RSTMS\_NONABAP\_SUPPORT .
## 7.1.3 Transport Landscape: Defining Transport Routes
Now that you have created representations for the different systems (BD3, BT3 and BP3 in our example) in TMS, you must connect them with the help of transport routes.
Use client-independent transport routes.
More details on how to configure transport routes you can find on the SAP Help Portal under Configuring Transport Routes.
## 8 USE SAP BTP, CLOUD FOUNDRY ENVIRONMENT WITH CTS
## 8.1 Select Objects and Attach to Transport Request
This section shows how to attach an MTA archive to a transport request.






After you have added one or more MTA archives to a transport request, you can release the transport request. This is also done in the Transport Organizer Web UI. Mark the transport request that you would like to release and choose Release .


After releasing the transport request, it cannot be changed any more. It is no longer visible in the list of Modifiable transport requests in the Transport Organizer Web UI.
For information on Transport Organizer Web UI, see Transport Organizer Web UI (CTS\_ORGANIZER).

NOTE
If you encounter problems when attaching objects or releasing the transport request, check whether you can find details for errors in the Application Log (transaction SLG1) for object CTSPLUS .