Choose to warn the user of the possible consequences when rebuilding or purging a set. Choose to use a classic Venn Diagram when creating a Sets on Sets step. For the show values commands in the data foundation and business layer editors, you can select how to display values.
Select how you want the values to display. Set or clear display options:. Show data types If selected, an icon showing the data type of the column is displayed in front of the column name.
For example, AB indicates a string data type, and 12 indicates numeric. Centered If selected, column names are centered in the table display.
Otherwise, column names are left-justified. Shadow border If selected, tables display with a shadow border. Postfix alias names with If selected, the original table name for an alias table is displayed in parentheses after the alias original table name table name. Prefix table names with If selected, the owner and qualifier names are displayed in front of the table name. Show full table names in This option is not currently used. Auto scroll and zoom to If selected, when you select an element in the view, the view automatically scrolls and zooms selection to better center the element in the viewing area.
The Help menu in the information design tool lets you link to different types of user assistance for the application. Cheat Sheets A cheat sheet shows how to complete a complex task, for example, creating a relational universe. The Cheat Sheets command displays a list of available cheat sheets.
Double-click a cheat sheet to start. It opens in the information design tool Help View. For some steps, you can click Click to perform and the application will start the appropriate wizard to help you complete that step.
To get more help on a step, click the help icon. If the URL address of the online tutorials changes, you can enter the new address in the information design tool preferences. To display help topics, you can navigate the Table of Contents, search the text, or look up topics in the index. Search The Search command opens the Help View on the search function. You can use wizards to help you create local resources in the information design tool. The wizards are available from the New menu in the main tool bar.
To see a list of all wizards, select New Other. To start a wizard, select it in the list and click Next. About resources in the information design tool [page 43] How to create a universe with the information design tool [page 18]. Only one SQL Anywhere database with this name can run on the network. See the Business Intelligence Platform Installation Guide for more information about the sample installation. As an administrator, you need to understand and optimize the usage of the Business Intelligence platform.
You can now use a universe and native reporting clients to query the metadata objects of the CMS repository database. These metadata objects include Business Intelligence platform information, such as:. You can import the CMS reporting sample that contains predefined objects to help you create reports and dashboards using the following SAP BusinessObjects data analysis and reporting applications :.
You can either use the default connection available in the CMS reporting sample or you can create your own CMS database connection. For the CMS database connection, you need to use a relational connection.
The following table describes the parameters of a relational connection. Authentication Mode The method used to authenticate the user's login credentials when accessing the data source:. You can access the data source from either an on premise system or a distant system. You can only see the content you are allowed to see and work with. You can only access the data source from an on premise system.
Note For security matters, this authentication mode is the recommended choice. User Name The user name to access the data source if Authentication Mode is Use specified user name and password. Password The password to access the data source if Authentication Mode is Use specified user name and password.
Before you begin, make sure that you have access to the CMS reporting sample which is in the following location:.
Click Import Import File. Select File System 4. Click Choose file to select the sample. Enter the login parameters then click Login Create. In the Promotion Jobs pane, right-click the sample then select Promote. In the Promote dialog box, click Promote. To use the sample universe for CMS reporting, see the related topic.
The CMS sample universe includes a predefined universe that supports common reporting scenarios. According to your analysis and reporting needs, you can edit and enhance the predefined universe. You can also find a list of predefined queries in the Queries pane.
These queries can serve as a tutorial for the universe features. Sample-User-Relationship-Detail Allows you to see in which group a user belongs to. Sample-FolderPath Universe Allows you to find the location of an universe.
Sample-ScheduleInfo-Relationships Allows you to visualize the actions scheduled by the users. You can create a linked universe to expand the CMS sample universe. A linked universe is a. For more information on creating a linked universe, see the related topic. Once you have created the linked universe, you can save its data foundation and business layer inherited from the CMS sample universe as new files so they have a life cycle independent of the CMS sample universe.
You can add tables, create joins linking the core data foundation tables with the new ones, and add new components to the business layer in the same way that you do for any other universe.
Any changes in the core components are automatically propagated to the linked universe when it is checked into the CMS. For more information on working with the data foundation of a linked universe, see the related topic.
Create a linked universe Creating a new linked universe [page ]. Insert alias tables Inserting alias tables [page ]. Insert a join Inserting and editing a join [page ]. Work with the data foundation of a linked universe Working with the data foundation of a linked universe [page ]. Open Web Intelligence and click the New icon in the File toolbar. Select the CMS sample universe. The Query Panel opens. Select and drag dimensions and measures that you want to include in the query into the Result Objects pane.
Select the objects on which you want to define query filters and drag them to the Query Filters pane. To create a quick filter on an object, select the object in the Result Objects pane then click the Add a quick filter icon in the Result Objects toolbar.
Click Run Query. CMC - Central Management Console A web based tool that you use to configure security settings and manage the following items:. Query Builder also referred as Admin Tool A web-based tool that you use to query the BusinessObjects repository and get the required information that cannot be found in CMC.
You can use the Convert. You can then work on the converted universe in a local project as you would a universe created with the information design tool. This is called a. The Convert. Note Before you can convert universes created in version XI 3 that are saved in a repository, you must upgrade the universes using the upgrade management tool.
How you convert. The following table describes the steps to follow for different conversion scenarios. For details of the conversion procedures, see the Related Topics. In the information design tool, follow the procedure for converting a. The conversion creates an equivalent. Any locally-stored. A locally-stored universe refers to a non-secured Publish the business layer to create the. This is the default setting.
When converting a. Documents in SAP BusinessObjects query and reporting tools based on the universe are still linked to the. This gives you the opportunity to check and test the converted universe before changing the documents that depend on it. Some features of. Once you have converted a universe, you can edit the universe resources in a local project in the information design tool to check and correct inconsistencies; and to take advantage of new universe features.
For a description of the supported features and how they are implemented in. After converting the universe, it is recommended to refresh the structure of the data foundation and run a check integrity on the universe. For tips on resolving check integrity errors on converted universes, see the related topic. Converting a. The table below indicates which. For certain features, tips are described for obtaining best conversion results. Table Feature in original.
Universe schema The objects in the universe schema are created in the data foundation:. Tip Prompt functions in self-join expressions may require manual intervention after conversion. See the related topic on resolving check integrity errors. Tip Contexts are converted with all joins explicitly included or excluded. You can manually restrict the context definition to the ambiguous parts of the schema using neutral joins.
For more information about contexts, see the related topic. Restriction When converting a. If the. The list of values has the following restrictions:. Universe outline The objects in the universe outline are created in the business layer with all their properties:. Multilingual universe All translated strings, language settings, and locale settings are converted. The conversion of a core universe does rived not trigger the conversion of the derived universes that depend on it.
A derived universe contains a link to a core universe. When you convert a derived universe, you have the following choices:. The links to the core universes are preserved, so that your.
This was the default behavior for previous versions of the information design tool. The data foundation of the converted universe contains all the tables and joins from all core universes and any tables, joins, or contexts that were defined in the derived universe.
Universe Controls Parameters: Query limits are converted and can be edited in the business layer. Query Limits. Edit all other SQL restrictions in the business layer. You can add customized values to the converted PRM file, and customize universe parameter settings in the converted universe using the information design tool.
Tip Check and reset custom settings to SQL generation parameters in the data foundation properties and business layer properties. For information on setting SQL parameters, see the related topic. Prompts Prompt functions in dimension and measure expressions in the business layer, and in SQL expressions in the data foundation are supported.
When converting, you have the option to automatically create a named parameter for the prompt in the business layer. Prompt expressions in the data foundation are not converted. Prompt functions in self- join expressions may require manual intervention after conversion. Lists of values Named lists of values are created in the business layer for dimension and measure objects that specify a list of values.
Access Restrictions When converting a universe in a repository, universe Access Restrictions are converted into security profiles that can be edited using the Security Editor:. Tip Business Security Profiles allow you to secure the metadata separately from the data. For more information about universe security in the information design tool, see the related topic. Note For. In the converted universe, priority is assigned to Data Security Profiles instead of groups.
If the priority for the profile assigned to the group is higher than the priority of the profile assigned to the user, the group profile is used. Connections When converting a universe in a repository, the same secured relational connection is used by both the. If you retrieve the converted universe into a local project, a connection shortcut is created that references the secured connection in the repository. Tip Relational connections can be created and shared by the universe design tool and the information design tool.
The connections are published in the same Connections folder in the repository. When converting a locally-stored non-secured universe, personal and shared connections are converted to local connections.
Tips for resolving check integrity errors after converting. After converting a. Certain errors in the check integrity results can be resolved by following the best practices described below. Refresh the structure in the data foundation just after the conversion. This avoids data-type errors in the integrity check.
If a join expression in the. The steps to follow for two possible solutions are described. The descriptions use the following example:. The self- join expression is:. After converting the universe, the data foundation contains a column filter on the dimProductStrings table. The join expression for the filter contains the Prompt.
The first solution consists of creating a prompted parameter and list of values in the data foundation:. Open the data foundation by double-clicking the data foundation name in the Local Projects View 2.
Click the Parameters and Lists of Values tab. In the data foundation Parameters pane, define a parameter for Language. Select the option Prompt to users and associate the Language list of values to it.
In the data foundation, edit the column filter in the dimProductStrings table. Change the join expression to reference the new prompted parameter, for example: dimProductStrings. Save and close the data foundation. Open the data foundation in the editor and delete the column filter on the dimProductStrings table that contains the Prompt. Open the business layer in the editor. In the business layer Lists of values pane, define a list of values based on custom SQL for Language.
In the business layer Parameters pane, define a parameter for Language. Keep the default option to Prompt to users and associate the Language list of values to it. In the business layer, in the folder associated with Product, create a filter with an expression that refers to the Language prompted parameter, for example: dimProductStrings.
In the Properties tab of the filter definition, select the Use filter as mandatory in the query option. Select the Filter scope of Apply on Folder. Save and close the business layer. You can convert a single or a group of multiple. UNV universes to. UNX universe format from different repository folders.
If you want to retrieve the converted. Note You can also convert a single. In the Convert a. Open a session on the repository where the. A conversion dialog box appears. In the left side pane, browse to the repository folder that contains one or multiple. Select one or more universes and click the right arrow so that the universes are listed in the right side pane, then click OK.
A conversion options box appears. The selected universes are listed with the repository file paths. You have the following conversion options:. Keep the same destination folder The converted. Note If the folder contains a. If you have not selected this option, then the new. Change the destination folder You select a different repository folder to receive the converted. For more information about named parameters, see the related topic. Note Don't select this option if you want to convert core and derived universes to.
UNX format and preserve the core and derived links. This option is not selected by default. Converting linked. UNX You can convert linked. UNX conserving links to all core universes universes. You can also choose to include all core. UNX universe if you prefer. Overwrite existing files Any. After conversion, it is recommended to refresh the structure of the data foundation, then run a check integrity on the universe to detect problems in the conversion.
For tips on resolving check integrity errors, see the related topic. Change the destination You select a different local folder to receive the converted. Select your preferred conversion options. Click OK to start the conversion. The conversion creates the equivalent universe resources data foundation, business layer, and local connection in the specified local project folder.
You can now publish the business layer to create the. This creates a local universe. To publish the universe to the repository, continue with the next step. Publish the local connection to a repository. Edit the data foundation and change the connection to use the secured connection published in the last step. Publish the business layer to the repository.
The Publishing Wizard allows you to run a check integrity on the universe recommended. Features supported when converting. Follow the instructions on the wizard pages. For more information about what to do on a particular page, click the help button. When the wizard finishes, the business layer and its dependent resources connections, connection shortcuts, and data foundation are created in the local project and are ready to be edited.
Note By default, the resources are retrieved into the local project and are secured locally by requiring you to enter your repository system authentication when opening a retrieved data foundation or business layer. To remove the local security requirement, select the Save for all users option when selecting the universe in the repository.
Opening a session [page ] Selecting a repository folder [page ] Creating a local project [page 90]. The first step in creating resources in the information design tool is to create a local project in the Local Projects View.
You create and edit all resources except secured connections and security profiles in a local project. The resources and folders in a local project are stored as physical files and folders in the local file system. The Local Projects View lets you to navigate local projects and open resources in the information design tool. Once you have created a local project, there are several ways you can populate it with resources:.
You edit the resources using the information design tool editors by double-clicking the resource name in the local project. To open a resource from a list of resources recently opened, select File Recent Resources. You can get information on the resources you create by right-clicking the resource name and selecting Properties. The properties displayed include the path to the resource in the local file system and the date the resource was last modified. When you copy resources, it is best to copy the entire folder so that all the references between the resources are maintained.
This is because the paths to referenced resources are relative, not absolute. The information design tool assumes that all resources that reference each other are in the same folder. If you copy a single resource to a location outside of the folder without copying the resources it references, the references are broken.
You can delete a project from the Local Projects View. The project files remain in the local file system until you explicitly delete them. Open the project to make it available again in the Local Projects View. Creating a local project [page 90] Deleting a local project [page 91] Opening a local project [page 91] About resources in the information design tool [page 43] Finding universe resources in the local file system [page 91] About converting.
From the information design tool main menu, select File New Project. Give the project a unique name. In Project Location, the file path to the default root directory for all projects workspace displays.
To select a. Resource names identify the connections, data foundations, and business layers in the local project. You give a name to the resource when you create it. The name must be unique within the local project. Note If you use the same name for resources in different projects, when publishing the resources to the same repository you may have naming conflicts because the names are not unique.
About resources in the information design tool [page 43] About resource dependencies [page ]. In the Local Projects View, open the project that contains the universe resources. Right-click a resource for example, a data foundation, connection, or business layer and select Properties.
Information design tool projects saved on the file system can be opened in the Local Projects View. From the information design tool main menu, select File Open Project. Select the Select root directory option and click Browse. The Browse for Folder dialog box opens with the default root directory for all projects workspace already selected.
Click OK to select the default directory, or browse to the folder containing the project you want to open. All projects not already open in the Local Projects View are listed in Projects and are selected by default. Clear the checkbox for any projects you do not want to open and click Finish. If you want to permanently delete the project from the Local Projects View and the local file system, select the Delete project contents on disk option in the Confirm Project Delete dialog box.
Note If you select this option, the deletion is permanent and cannot be undone. If you did not delete the project contents permanently, you can open the project to make it available again in the Local Projects View. To filter the types of resources displayed in the Local Projects View, click the filter icon in the icon bar of the view.
Select the types to include or exclude. The Local Projects View displays only resources of the types selected.
In the search text box, enter the text and press the Enter key to start the search. The first resource name that contains the search text is highlighted in the view. The total number of resource names containing the search text displays in the search text box. Note The search does not highlight resource types that are unselected in the filter. To highlight the next resource found, press the Enter key again.
Use the Enter key to browse through all resource names that match the search text. Sometimes when the information design tool ends unexpectedly, the local workspace becomes corrupted and you are unable to restart the information design tool.
Use this procedure to recreate the workspace and recover your local projects. For example:. Rename the workspace folder to workspace. Start the information design tool. Somtimes you can recover project files by reopening them from the backup workspace see step 4. Otherwise, projects can be manually recovered see step 5. To recover projects using the Open Project command:. Select File Open Project from the main menu.
In the Import Existing Projects dialog box, select the root directory and browse to the path of the workspace. Select the projects you want to restore. Select the Copy projects into workspace option and click Finish. To recover projects manually: a. Open a system file and folder manager for example, Windows Explorer and navigate to the path of the workspace.
Copy and paste project folders from the workspace. A shared project is a project in a repository whose resources are available to other designers. You create a shared project in a repository from an existing local project in the Local Projects View. To start working on shared resources, you use the following tasks in the Project Synchronization View:. This creates a local project associated with the shared project so that you can start working on the shared resources.
Creating a shared project from a local project [page 94] Working in a shared project [page 94] Synchronizing a project [page 99] Locking a resource [page ] Unlocking a resource [page ] Merging changes to shared resources [page ].
The shared project will automatically be given the same name as the local project. A project with this name cannot already exist in the repository. If you need to rename an existing shared project, use the rename command in the Project Synchronization View. In the Open Session dialog box, select the repository system session you want to open and enter your system authentication.
The Project Synchronization View opens showing a shared project with the same name as the local project. At this point, the shared project is empty.
In the Project Synchronization View, synchronize the resources you want to save in the shared project. Renaming a shared project [page 95] Opening a session [page ] Synchronizing a project [page 99]. Open the Project Synchronization View with a session on the repository system where the shared project is saved. Select the shared project from the Shared Project list.
In the selected shared project, lock the resources you want to work on. Locks are available as a communication tool between designers. When other designers open the Project Synchronization View, your lock informs them that you are making changes. It also prevents other designers from updating these resources in the shared project while you have them locked. However, any designer can unlock the resource if necessary. Synchronize the project to update the resources in the local project with the latest changes saved on the server.
If you do not already have a local version of the project, one is created in the Local Projects View. You may want to review the changes made on the server before updating them in the local project. For more information, see the related topic on merging changes in shared resources. Once you have made your changes, in the Project Synchronization View, synchronize the project to save your changes on the server. Unlock the resources. Opening the Project Synchronization View [page 98] Locking a resource [page ] Synchronizing a project [page 99] Merging changes to shared resources [page ] Unlocking a resource [page ].
Click the Rename Shared Project icon. Enter a new name that is unique in the repository. To create a local project with the new name in the Local Projects View, synchronize the project.
Local projects with the original name are no longer associated with the shared project with the new name. The resources in those local projects can no longer be synchronized with the newly named shared project.
Opening the Project Synchronization View [page 98] Synchronizing a project [page 99]. The shared project is deleted from the repository. Resources in the local projects associated with the deleted shared project are not affected, however synchronization statuses of the local project are lost. Synchronizing a project starts with comparing the resources in a project in the Local Projects View with an associated shared project on the repository server.
Synchronization detects added resources, deleted resources, and differences between the resources. Based on the differences detected, you can update the local and shared resources. Use the Project Synchronization View to synchronize a project. The view displays synchronization information in two panes:. A lock icon appears next to the resource if it is locked. Other information about the resources on the server is given: the user who last modified the resource and on what date, the user who locked the resource and on what date.
The status is determined by comparing the resources in the local and shared projects. Added Locally The resource was added in the local project, but not in the shared project. Changed Locally The resource was changed in the local project, but not in the shared project since the last synchronization. Deleted Locally The resource was deleted in the local project but still exists in the shared project. Added on Server The resource is not in the local project but exists in the shared project.
Changed on Server The resource was changed in the shared project, but not in the local project since the last synchronization. Deleted on Server The resource exists in the local project, but was deleted in the shared project. Conflicting Any of the following situations creates a conflicting status:. Three commands allow you to synchronize resources. When you select the resources to be synchronized, you can select individual resources or folders.
Starting in the first maintenance release for SAS 9. Beginning in SAS 9. Training Courses. Learning path for Business Intelligence. Previous Versions. Expand All Collapse All 9. Hot Fixes Find quick solutions to problems or conduct routine system maintenance. Expand All Collapse All 4. When you create a data model, a default schedule is also defined every day at 8PM same as the wallet. To access wallets and flows schedules, right click the wallet or flow, select Properties and open the Schedule tab.
If you want to schedule the flow at a different time than the wallet, clear the With wallet box. To access data models schedules, in the Data source advanced configuration dialog box, open the Refresh frequency tab at the bottom of the window.
To add a schedule, click Add. The dialog box Refresh frequency opens. The refresh is done as soon as the URL is executed. To configure this event, you must add a schedule on the flow and the cube, enter the External event ID and specify a frequency which defines in this case the minimum time between 2 refresh.
If no event is received, the flow and cube won't be refreshed unless another schedule is setup. You can define several events for a flow or cube and the same event can be used for several flows or cubes. It can be used to define several channels of refresh.
If you execute the URL from your browser, a connection screen is displayed if needed, then the event is fired. You will get a message mentioning that the event has been fired. This doesn't mean that the event has been handled. In fact, if the scheduler is already busy, the event will be wait listed. Moreover, if the previous event has been sent too recently minimum time requirement between 2 refresh is not fulfilled , the event will be ignored.
Podcasts are audio and video programs published on the internet. DigDash Enterprise provides a directory of podcasts you can add to your information wallet.
In the flows pane on the left, click the Emails icon. The Chart dialog box shows up. Enter the emails parameters :. In the flows pane located on the left, click the Calendar icon dialog box shows up. Enter the parameters of the calendar you want to use:. Documents builder lets you build PowerPoint documents including information flows generated by DigDash Enterprise.
You can also add legends for these information flows. In the flows pane located on the left, click the documents builder icon. The dialog box Chart shows up. By default, existing filters on flows are not taken into account. If you want to add filter on dimensions used in your information flows, click Select besides Filters, then select the values to use in the filters.
Note : if you create a flow in a role wallet, it can only use flows of this role else, you will get an error message when displaying the document. Click the previous or next icons to display the previous or the next flow. If you want to publish a flow based on a condition, select this flow, right click and choose Properties.
Click the Edit icon besides the device on which you want to add a condition. The dialog box Conditional synchronization opens up. Create a formula which describes the condition to fulfill for the flow synchronization.
By default, the only tab displayed in the administration console is Wallet. This command allows you to update the history of the selected flows. If a wallet is selected, it updates the history of all the flows contained in the wallet. This command allows you to delete the history of the selected flows. If a wallet is selected, it deletes the history of all the flows contained in the wallet. This command allows you to synchronize the selected flows.
If a wallet is selected, it synchronize all flows contained in the wallet. It allows you to synchronize the selected flows for all users of a role. If a wallet is selected, it synchronize all role flows contained in the wallet. The tools menu provides access to centralized meta data of DigDash enterprise data source, formats, colors, The first tab shows the user data models, the next tabs show the roles data models.
In the example above, the user john smith has two roles: marketing and sales. In the sales role, the user has two data models: retail and telecom. To display metadata, click the arrow on the right of the search field.
You can then select the data you want to display select Show all to display all the meta data. Click the arrow besides the data model name to display the data columns, then groups, targets or formats, You can edit, remove or copy meta data targets, groups, formats, variables, Note: some groups can use values that are not available in the dimension where you copy the hierarchy.
In that case, groups are copied but don't include missing values. Remove a target: select the target, then click Delete or select the hierarchy, right click and choose Delete. The dictionary manager lets you view and modify the translation of meta data flow names, dimensions names, You can configure favorite devices by selecting the device, then clicking Configure. Mobile devices can be configured in the following way:.
SMS device : enter the phone number and signature content. Mobile device : by default, the configuration is the one that best suits your device. You can modify it by selecting another output type image, video or document and other files formats example BMP for images. File server device : use this device, to synchronize flows on a file server.
In that case, you must select the file server on which you want to synchronize the flows and the format of the file you want to generate pdf, ppt,excel This menu lets you access the format editor. This menu lets you access the documents server manager. From the documents server manager, you can add, edit or remove documents server. From this menu, you can create modify or remove color palette. From this menu, you can create, edit or remove predefined functions.
These functions can be used when filtering time dimensions for example. From this menu, you can create, edit or remove CSS. These CSS can be used to customize flows visualization. The hierarchies are displayed on the left. When you select a hierarchy, its definition shows up on the right. Right click the hierarchies list, then click Add. Enter the hierarchy name then select the hierarchy type: explicit or calculated.
We multiply this timestamp by as the value is in milliseconds. To define an explicit hierarchy, you must enter manually the limits of each group. The values of a group are greater or equal to the value Start and strictly less than the value End.
You can rename, remove, or translate a group. To do so, right click the group and select the appropriate menu. If you want to add the hierarchy to all the time dimensions, check the box Add to all upcoming time dimensions. Remove a hierarchy: select a hierarchy, right click and choose Remove. Duplicate a hierarchy : select a hierarchy, right click and choose Duplicate. Enter the name of the hierarchy.
Rename a hierarchy: select a hierarchy, right click and choose Rename. You can also select the user interface language languages available are the one you selected in the server settings page. In the HTML browser section, you can select the browser that will be used when viewing document the default brower used is Chromium.
In the tabs section, check the tabs that you would like to display in the administration console by default the tab Wallet is the only one to be displayed. In the defaults section, you can choose to restore hidden dialog dialog that show up only once to ask for global settings , Restore tool tips seen once, For example, if you edit a data source, a warning message is displayed. If you check the box Do not ask again , this warning message won't be displayed again. In the advanced tab, you can configure the HTTP proxy by default, no proxy and define Storage options.
From this menu, you can access available documentations admin console, dashboard editor, tutorial. Returns the value of the field Display Name field defined in the Users Settings page. Returns the value of the field Common name cn defined in the Users Settings page.
Returns the value of the field sn defined in the Users Settings page. Returns the value of the field mobile defined in the Users Settings page.
Returns the value of the field Email defined in the Users Settings page. Returns the value of the field Email password defined in the Users Settings page. Toggle navigation Search. Office Formats. Export as PDF. Other Formats. Select the pages to export: Select from: All pages Created pages The pages created by the user or by XWiki extensions on behalf of the user.
Created and modified pages Includes modified extension pages usually configuration pages. All pages Includes unmodified extension pages. Export as HTML. Add a data model II. Create a target on a measure II. Modify indexation options II. Modify the cube processing mode II. Add a podcast IV. Add a RSS flow V. Add emails VI. Add a calendar VII. Add documents builder VII. Publish an information flow VIII. Menus IX. Operator Description Is not empty Displays the line if the column value is not empty Is empty Displays the line if the column value is empty Equals to Displays the line if the column value is equal to the value set as the operand.
Contains Displays the line if the column value contains the value set as the operand. Doesn't contain Displays the line if the column value doesn't contain the value set as the operand. Differs from Displays the line if the column value differs from the value set as the operand.
Match regular expression Displays the line if the column value matches the regular expression set as the operand. Is superior to Displays the line if the column value is greater than the value set as the operand. Is superior or equal to Displays the line if the column value is greater or equal to the value set as the operand. Is inferior to Displays the line if the column value is less than the value set as the operand. Is inferior or equal to Displays the line if the column value is less or equal to the value set as the operand.
Start with Displays the line if the column value starts with the value set as the operand. Ends with Displays the line if the column value ends with the value set as the operand. Is in Displays the line if the column value is in the value set as the operand. Is not in Displays the line if the column value is not in value set as the operand. Operation Execution Add a table Drag-and-drop table s containing the desired information on the drawing board located on the right.
Delete a table To remove a table placed on the drawing board, right-click the header of the table, then select Delete the table. Add a join To add a join between two columns of tables placed on the drawing board, click successively on the two columns.
A join between the two columns represented by an arrow is displayed. Delete a join On a join, right click the circle at the middle of the arrow, then select Delete the join. Change the join type On a join, right click the circle at the middle of the arrow, then select Change the join type. Select Left join, Right join or full join. NumberEmp is the alias of the number column The Sum aggregation has been set on the salary column. Operations Execution Select a column Drag and drop the desired column s on the table at the top right.
Filter a column Drag and drop the desired column s on the table at the bottom right. The Edit filter rule window shows up. Select the type of filter you want to apply. File Sales1. File Sales2. Date Product Unit price Quantity Total price. Exemple of join between two excel files : The first file contains customer information customer.
Create a table based on this new data source. Cumulative value from the beginning of the year to the selected date included Example: if the selected date is January 26 , returns the cumulative value from January 1 st to January 26 Cumulative value for the year preceding the selected year Example: if the selected date is January 26 , cumulative value from January first to December 31 Cumulative value for the current year Example: if the current date is January 26 , cumulative value for Cumulative value from the first day of the month to the selected date.
Example: if the selected date is January 26 ,. Cumulative value from January first to the current month non included Example: if the current month is December , cumulative value from January first to November 30 th Cumulative value for the previous month Example: if the current date is January 26 , cumulative value from December first to December 31 st Cumulative value for the last N months.
Cumulative value for the selected period of the previous year. Example: if the selected month is January , cumulative value for January Example: A bar chart displays a turnover by area. Keyword Description Member Displays the current value of the dimension. Percent value Displays the measure value in percentage.
Dimension name Displays the name of the dimension.
0コメント