José María Guzmán Crespo
Quiz von , erstellt am more than 1 year ago

SAP BPC 10 Certificación

510
0
0
José María Guzmán Crespo
Erstellt von José María Guzmán Crespo vor mehr als 5 Jahre
Schließen

SAP BPC 10 Certificación

Frage 1 von 80

1

Administration - Which objects must be configurated if you want to control user access to amodel from a Web Client? Note: There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Data access profiles

  • Task profiles

  • BW rules

  • Secured dimensions

Erklärung

Frage 2 von 80

1

Input forms and reports - You want to be able to insert comments in an excel popup on SAP BEC version for Netweaver. What do you hace to enable?

Wähle eine oder mehr der folgenden:

  • The enable Comments indicator in model features

  • Environment parameters in Customizing (SPRO)

  • The Show as Microsoft Excel Cpmments checkbox

  • Model parameters in Customizing (SPRO)

Erklärung

Frage 3 von 80

1

Business Rules and Controls - Which business rule requires global definitions business rules?

Wähle eine der folgenden:

  • US eliminations

  • Currency translation

  • Eliminations and adjustments

  • Account-based calculations

Erklärung

Frage 4 von 80

1

Logic and calculation - Which translation allows you to access to system_constants.lgf and MDXlib.lgf files in SAP BPC for version…

Wähle eine der folgenden:

  • Script Logic Tester (UJKT)

  • Transports (UJBPCTR)

  • File Service (UJFS)

  • Write back runtime Parameters (UJRO)

Erklärung

Frage 5 von 80

1

Logic and calculation - Which of the following options do you use to calculate KPIs on the fly?

Wähle eine der folgenden:

  • Script Logic

  • Worksheet Logic

  • Dimension member formulas

  • Business rules

Erklärung

Frage 6 von 80

1

Consolidation central - (NO SE CUAL ES LA RESPUESTA) - The consolidation monitor displays a blank screen for the current period although the previous period has beeen displayed properly. What could be the reason for this?

Wähle eine der folgenden:

  • No master data exists

  • No ownership records exists

  • No trial balance exists

  • No exchange rate records exists

Erklärung

Frage 7 von 80

1

Dimensions - Which dimension types can you use for the context when you use the Controls Monitor in a Financial model? There are 3 correct answers to this question

Wähle eine oder mehr der folgenden:

  • G-Group

  • T-Time

  • E-Entity

  • R-Currency

  • C-Category

Erklärung

Frage 8 von 80

1

Input forms and reports - What is an advantage of using Web reports over EPM reports?

Wähle eine der folgenden:

  • Web reports support EPM functions

  • Web reports support multiple dimensions in the rows and columns

  • Web reports can access data from multiple sources

  • Web reports use a thin client

Erklärung

Frage 9 von 80

1

Dimensions - What do you do when you maintain domensions data manually and want to return to the previous unsaved value?

Wähle eine der folgenden:

  • Choose back

  • Choose revert

  • Choose restore

  • Choose display

Erklärung

Frage 10 von 80

1

Administration - A user tries to connect to a model usig Excel interface on the EPM add-in. However, the model is not available. What could be the issue?

Wähle eine der folgenden:

  • The task profile is assigned to the user's team

  • The data access profile is not assigned to the user's team

  • The data acess profile is assigned to the user's team

  • The task profile is not assignedto the user's team

Erklärung

Frage 11 von 80

1

Models - Which objects in BW is equivalent to a model in SAP BPC for Netweaver?

Wähle eine der folgenden:

  • Standad infocube

  • Multiprovider

  • Real-Time Infocube

  • Virtual Provider

Erklärung

Frage 12 von 80

1

Models - Which properties are required to carry out currency translation for legal consolidation? There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • RATETYPE in the account type dimension

  • RATE_YEAR in the category dimension

  • RATE_PERIOD in the category dimension

  • CURRENCY in the entity type dimension

Erklärung

Frage 13 von 80

1

Models - For which of the following models do you have to create al least two "Drivers and Rates" type models?

Wähle eine der folgenden:

  • Ownership

  • Estándar

  • Consolidation

  • Finantial

Erklärung

Frage 14 von 80

1

Input forms and Reports - How do you change an EPM Report from read only to read/write using the EPM Offlice Add-in Excel?

Wähle eine der folgenden:

  • Switch the template to an input schedule

  • Activate "Use as input form" in the sheet options

  • Activate "Member recognition" in the sheet options

  • Switch the type from Report to Input form

Erklärung

Frage 15 von 80

1

MODELS - Which of the following rules are based on business rules? There are 3 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Eliminations and adjustments

  • Allocation

  • Currency translation

  • Account-based calculations

  • Driver-based calculations

Erklärung

Frage 16 von 80

1

Input forms and Reports - What information is needed when you configurate the interface between EPM Office Add-in Excel and Bex Query to enable the BW drill thought… There are 3 correct answers to this question

Wähle eine oder mehr der folgenden:

  • The technical field names of the dimensions

  • The FILTER_IOBJNM and FILTER_VALUE parameters

  • The OKCODE parameter

  • The URL of the Bex Query

  • The technical names of the InfoObjects

Erklärung

Frage 17 von 80

1

Administration - Which of the following steps are mandatory if you want to perform a transport from development system to the production system. There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Run the Transport-Create-Request (UJBPCTR) transaction

  • Take the environment offline

  • Select Planning and Consolidation Objects in the BW Transport Collector

  • Run a full optimization

Erklärung

Frage 18 von 80

1

Input forms and Reports - When you enter a new value into a cell manually, you want the cell color to switch to a different colour. How to configure the formatting sheet to achieve this?

Wähle eine der folgenden:

  • Select Apply for changed Member Default Format

  • Select Apply for inputable Member Default Format

  • Select Apply for Local Member Default Format

  • Select Apply for Calculated Member Default Format

Erklärung

Frage 19 von 80

1

Consolidation celtral - You have defined the global definitions in the business rules. Which of the following ownership accounts must contain data if you want to perform the ownership calculation? There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • PCON- Percent Consolidation

  • PCTRL - Percent Control

  • POWN - Percent Ownership

  • PCON_SYS - Percent Consolidation_System Calculation

  • POWN_SYS - Percent Ownership_System Calculation

Erklärung

Frage 20 von 80

1

Dimensions - (NO LA SE) You use INC account type for revenue accounts and the EXP account type for expense accounts. What is displayed in a Planning and Consolidation report when revenues are stored as negative values and expenses are stored as positive values? There are 2 correct answers to this question

Wähle eine der folgenden:

  • Negative revenue values

  • Positive expense values

  • Positive revenue values

  • Negative expense values

Erklärung

Frage 21 von 80

1

Administration - Which of the following steps do you need to follow to configure data audit?

Wähle eine der folgenden:

  • Activate the collection of the data by environment

  • Add a global parameter in Customizong (SPRO)

  • Add a parameter to Data Manager Packages

  • Activate the collection of the data by model

Erklärung

Frage 22 von 80

1

Dimensions - Which of the following dimensions types can be used as reference dimensions? There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • D - Audit

  • T- Time

  • G - Group

  • E - Entity

  • S - Subtables

Erklärung

Frage 23 von 80

1

Administration - Which step is mandatory if you want to check the data integrity of the incoming records?

Wähle eine der folgenden:

  • Configure controls

  • Activate the validations for the environment

  • Assign a driver dimension to the validation rule

  • Implement a Badi

Erklärung

Frage 24 von 80

1

Input forms and Reports - What do you have to create to capture the data from multiple planning iterations?

Wähle eine der folgenden:

  • Dimensions

  • Properties

  • Members

  • Models

Erklärung

Frage 25 von 80

1

"Logic and calcluations - What is missing in the following currency tranlation logic script if you want to translate local currency in a financial.
*RUN_PROGRAM CURR_CONVERSION
CATEGORY=%CATEGORY_SET%
TID_RA=%TIME_SET%
RATEENTITY=GLOBAL
ENTITY=%ENTITY_SET%
*ENDRUN_PROGRAM"

Wähle eine der folgenden:

  • Logic for the Entity type dimension

  • Logic for the Currency type dimension

  • Logic for the Group type dimension

  • Logic for the Account type dimension

Erklärung

Frage 26 von 80

1

Administration - What can you use to prevent the insetion of records into the database in SAP BPC

Wähle eine der folgenden:

  • Book publication

  • Work Status

  • Data audit

  • Controls

Erklärung

Frage 27 von 80

1

Business rules and controls - (NO LO SE)You have created the controls and a user has tested them for the current period. However, the user does not see the controls for the following period. How do you resolve this issue?

Wähle eine der folgenden:

  • Grant authorization to the user to view the controls for following period.

  • Assign the control level to the following period

  • Change the work staus in the Consolidation Monitor for the following period

  • Assign the control set to the following period

Erklärung

Frage 28 von 80

1

Administration - You want to use specific default values when you add data manually from Web Client. How can you achieve this?

Wähle eine der folgenden:

  • Specify the default members for data input

  • Select the "Activate Member Recognition" option

  • Select the "Use as Input Form" option

  • Specify the default members for reporting

Erklärung

Frage 29 von 80

1

Administration - Which of the folowing tasks are perdormed during a full optimization in SAP BPC version.. There are 2 correcto answers to this question

Wähle eine oder mehr der folgenden:

  • Aggregate rollups

  • Create a copy of the Multiprovider for the InfoCube

  • Check the BW dimension tables to see wheter these can be improved

  • Update DB statistics for the InfoCube

Erklärung

Frage 30 von 80

1

Administration - Which of the following journal parameters are available for a model? There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Balanced currency

  • Allow Journals to be Reopened

  • Enforce Balanced Journal

  • Balanced by entity

Erklärung

Frage 31 von 80

1

Busines rules and controls - You want to enable users to resolve the "out of balance" issue when blocking control fail. When you configure the controls, what do you attach to the blocking controls?

Wähle eine der folgenden:

  • An input schedule

  • A Web Report

  • An Excel Report

  • A journal

Erklärung

Frage 32 von 80

1

Administration - Which steps are mandatory if you want to implement the work status? There are 3 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Define the Reviewer property in the owner dimension

  • Enable data locking for the model

  • Enable data audit for the model

  • Define at least one hierarchy in the owner dimension

  • Define the Owner property in the owner dimension

Erklärung

Frage 33 von 80

1

Busines rules and controls - The parent company D owns 91% of company A, 51% of company B, and 49% of company C. Which company can use the equity method?

Wähle eine der folgenden:

  • D

  • A

  • B

  • C

Erklärung

Frage 34 von 80

1

"Logic and calculation - You execute the following Logic Script by running a Data Manager package without transfering any further parameters and without using the default logic
""WHEN ACCOUNT
IS ACCOUNT1
REC(FACTOR=1.5,ACCOUNT=ACCOUNT2)
ENDWHEN""
Which data is used by this calculation?"

Wähle eine der folgenden:

  • All accounts

  • Only the workspace context

  • Only the context default

  • Only ACCOUNT1 and ACCOUNT2

Erklärung

Frage 35 von 80

1

Web client and dashboards - Which prerequisites must be fullfilled if you want to display Planning and Consolidation data in the Dashboard Designer? There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • A runtime connection must exist between the Planning and Consolidation System and the Dashboard

  • A list of models must be generated in the EPM report

  • An EPM report must be created

  • A BPC data grid must be used in the Dashboard

Erklärung

Frage 36 von 80

1

Models - When does the DEFAULT.LGF logic script run?

Wähle eine der folgenden:

  • When business rules are executed

  • When data is sent from an input form

  • When table-based logic is executed

  • When data is refreshed

Erklärung

Frage 37 von 80

1

Business rules and controls - You select a parent in the detailed section of the control definition. Which of the following options do you choose to ensure that the control will be executed for each member of the selected parent?

Wähle eine der folgenden:

  • Breackdown Dimension

  • Control level

  • Threshold Tolerante

  • Equation type

Erklärung

Frage 38 von 80

1

Input forms and Reports - Which function do you use to calculate variances?

Wähle eine der folgenden:

  • EPMMemberProperty

  • EPMExecuteAPI

  • EPMComparision

  • EPMMemberOffset

Erklärung

Frage 39 von 80

1

Business rules and controls - Which of the following values can you use in the destionation flow to configure the currency translation business rule? There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Base Level Members

  • Blank

  • Property values

  • Descendants

Erklärung

Frage 40 von 80

1

Consolidation central - (NO TENGO LAS FOTOS) When executing the ownership calculation you receive and error message. You therefore analyze the group/entity structure in the attached screenshot. Which method type is missing in the consolidation method?

Wähle eine der folgenden:

  • N_A

  • N_

Erklärung

Frage 41 von 80

1

Models - When you create a new model from an existing model which items are copied?

Wähle eine der folgenden:

  • Controls Definitions

  • Data Manager Packages

  • Transaction Data

  • Journal Templates

Erklärung

Frage 42 von 80

1

Logic and calculation - (NO LO SE) What is entered in the destination group account when you configure AR/AP Intercompany Elimination using the Eliminations…

Wähle eine der folgenden:

  • The same values as in the destination minority account

  • The intercompany AP account

  • The intercompany AR account

  • The offset account

Erklärung

Frage 43 von 80

1

Web client and Dashboards - You want to create a PDF book that contaions PDF files by cost center for the current year based on an EPM report, and publish it in the library. Which of the following steps are required when you create the publication template? There are 2 corect anwers to this question

Wähle eine oder mehr der folgenden:

  • Include the cost center dimension in the page axis of the publication template

  • Assign the EPM report to the publication template

  • Assign a time variable to the publication template

  • Assign the cost center to the variable members of the publication template.

  • Include the cost center dimension in the fixed keys of the publication template

Erklärung

Frage 44 von 80

1

Administration - Which of the following delivered task profiles allows you to maintain environments?

Wähle eine der folgenden:

  • PrimaryAdmin

  • System Security

  • SystemAdmin

  • Secondary Admin

Erklärung

Frage 45 von 80

1

Data manager - How do you onfigure the Data Manager package to execute a specific logic script file?

Wähle eine der folgenden:

  • Define the logic script file in the package link

  • Define the logic script in the process chain

  • Define the logic script file in the advance package settings

  • Define the logic script file as a variable in package parameters

Erklärung

Frage 46 von 80

1

Consolidation central - Which hierarchy is used in the consoliation monitor?

Wähle eine der folgenden:

  • Intercompany based hierarchy

  • Entity hierarchy

  • Group hierarchy

  • Ownership-based hierarchy

Erklärung

Frage 47 von 80

1

Logic and calculation - Which of the following calculations uses only logic script?

Wähle eine der folgenden:

  • Allocation

  • Ownership calculation

  • Currency translation

  • Reclassification

Erklärung

Frage 48 von 80

1

Logic and calculation - You want to calculate revenues as a product of the units sold and price per unit and save the reslts in the database. How can you achieve this?

Wähle eine der folgenden:

  • Use the logic script

  • Use business rule

  • Use theworksheet logic

  • Use the dimension member formulas

Erklärung

Frage 49 von 80

1

Logic and calculation - Which package groups are delivered by SAP by SAP BPC for NetWeaver? Note: There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Data Manager

  • Other function

  • Reporting Management

  • Financial Process

Erklärung

Frage 50 von 80

1

Web client and Dashboards - You want to specify a model and a dimension members that are usedevery time you created Web Reports. Where do you set these values?

Wähle eine der folgenden:

  • EPM Context

  • Context default

  • Preferences

  • Workspace

Erklärung

Frage 51 von 80

1

Logic and calculation - You use DESTINATION_APP keyword in your logic script. If the source model contains fewer dimension than the target, which operator do you use to derive the missing dimensions?

Wähle eine der folgenden:

  • *SKIP_DIM

  • *ADD_NAME

  • *RENAME_DIM

  • *XDIM_MEMBERSET

Erklärung

Frage 52 von 80

1

Input forms and reports - Which tool can you use in the EPM Office Add-In Excel to email a list of static files? Note: There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Distribution

  • Book publication

  • Portal publication

  • Worksheet generation

Erklärung

Frage 53 von 80

1

Logic and calculation - Which property of the currency dimension is required for currency translation?

Wähle eine der folgenden:

  • PARENT_GROUP

  • STORE_GROUP_CURR

  • GROUP_CURRENCY

  • CURRENCY_RATE

Erklärung

Frage 54 von 80

1

Web client and dashboards - Which of the following dimensions is automatically selected when you create a Business Process Flow template?

Wähle eine der folgenden:

  • Time

  • Account

  • Entity

  • Category

Erklärung

Frage 55 von 80

1

Data manager - Which of the following functions do you use to load data from a flat file to a model?

Wähle eine der folgenden:

  • Organize package

  • Data preview

  • Run package

  • Download data

Erklärung

Frage 56 von 80

1

Dimensions - How do you model cost center rollups by profit center?

Wähle eine der folgenden:

  • Create a user-define dimension for the profit center

  • Create a user-define dimension for the cost center

  • Create a profilt center hierarchy by cost center

  • Create a cost center hierarchy by profit center

Erklärung

Frage 57 von 80

1

Input forms and reports - Where do you activate the parameter that is used to automatically refresh the input form when you open it?

Wähle eine der folgenden:

  • EPM - User options

  • EPM - Command Display Options

  • EPM - Context Options

  • EPM - Sheet Options

Erklärung

Frage 58 von 80

1

Web client and Dashboards - You reopen a step in a Business Process Flow. What will the staus of the next step be?

Wähle eine der folgenden:

  • Reopened

  • Open

  • Delayed

  • Rejected

Erklärung

Frage 59 von 80

1

"ADMINISTRATION - Which value is assigned ti ACCOUNT3 in the following logic script?
ACCOUNT1=10, ACCOUNT2=20
""WHEN ACCOUNT3
""IS ACCOUNT2,ACCOUNT1
""REC (FACTOR=2,ACCOUNT3=ACCOUNT),
""ENDWHEN"

Wähle eine der folgenden:

  • 60

  • 20

  • 30

  • 10

Erklärung

Frage 60 von 80

1

Models - Which of the following methods does the SHARE QUERY ENGINE (SQE) use to retrieve data from the database? Note: There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Cell query

  • RSDRI query

  • MDX query

  • Axis query

Erklärung

Frage 61 von 80

1

Consolidation central - Which of the following tasks can you perform using the Consolidator monitor? Note: There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Run Data Manager Packages

  • Run Currency translation

  • Run controls

  • Run ownership calculation

  • Run consolidation

Erklärung

Frage 62 von 80

1

Business rules and controls - Which of the following business rules can you use in a financial model?

Wähle eine der folgenden:

  • Methods

  • Methods - based Multipliers

  • Elimination and Adjustments

  • Currency Translation

Erklärung

Frage 63 von 80

1

Dimensions - What is the maximum lenght of a dimension member in SAP BPC version for Netweaver?

Wähle eine der folgenden:

  • 500 characters

  • 20 characters

  • 256 characters

  • 32 characters

Erklärung

Frage 64 von 80

1

Models - When using US Eliminations, which dimension must you include in the model?

Wähle eine der folgenden:

  • Group

  • Entity

  • Flow

  • Time

Erklärung

Frage 65 von 80

1

Dimensions - Which of the following dimension types are required for an ownership model? Note: There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • I - Intercompany

  • D - Audit

  • G - Group

  • A - Account

  • R - Currency

Erklärung

Frage 66 von 80

1

Web client and Dashboards - Which of the following interfaces can you use when you define actions using Business Process Flow template?

Wähle eine oder mehr der folgenden:

  • EPM Office Add-in Excel

  • EPM Office Add-in Word

  • Journal

  • BW Application Server

  • Planning and Consolidation Administration

Erklärung

Frage 67 von 80

1

Dimensions - Which dimensions can you use to configure the Carry-Forward business rule? Note: There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Account

  • Flow

  • Time

  • Entity

  • Data source

Erklärung

Frage 68 von 80

1

Data manager - After running a Data Manager package link with 5 packages, you notice that package 3 failed. What happened to the other packages?

Wähle eine der folgenden:

  • Package 1,2,4 and 5 ran

  • Package 1 and 2 were rolled back, 4 and 5 did not run

  • Package 1 and 2 were rolled back, 4 and 5 run

  • Package 1 and 2 ran, package 4 and 5 did not run

Erklärung

Frage 69 von 80

1

Input forms and reports - For the budgeting process, you need to distribute a base amount across 12 month with a growth factor of 3%. Which modelling function do you use?

Wähle eine der folgenden:

  • WEIGHT

  • TREND

  • FORECAST

  • SPREAD

Erklärung

Frage 70 von 80

1

MODELS - You want to set up a consolidation model. Which of the following dimenions should be the same for consolidation, rate and ownership models? Note: There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Entity

  • Account

  • Category

  • Time

  • Data Source

Erklärung

Frage 71 von 80

1

Data manager - Which of the following tasks can you perform using a Data manager package delivered by SAP? Note: There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Export master data to SAP ECC

  • Execute a BADI

  • Load master data and texts from BW InfoObject

  • Export transaction data to a flat file

  • Load transaction data from BW InfoProvider

Erklärung

Frage 72 von 80

1

Data manager - Which transformation file parameter do you use for filtering when you import data from an infoprovider?

Wähle eine der folgenden:

  • SELECTION

  • AMOUNTDECIMALPOINT

  • SKIP

  • MAXREJECTCOUNT

Erklärung

Frage 73 von 80

1

Administration - Which user account do you need to log onto SAP BPC version for Netweaver?

Wähle eine der folgenden:

  • Window Ad users

  • ECC users

  • BW users

  • CMS users

Erklärung

Frage 74 von 80

1

Dimesnions - Which of the following conventions apply to dimension property ID? Note: There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • They must contain less than 33 characters

  • They must begin with a character

  • They must contain less than 21 characters

  • They must begin with a number

Erklärung

Frage 75 von 80

1

"Input forms and reports - (NO LO SE) You use account by entity report and whatn to frill down on parent account for one entity at a time, as in the attached screenshot. How do you achieve this drill down behaviour?
Before Picture … After Picture"

Wähle eine der folgenden:

  • Activate Member an children

  • Activate Expand / Collapse on Single Member

  • Activate Keep / Exclude on Single Member

  • Activate Member and Descendants

Erklärung

Frage 76 von 80

1

Input forms and reports - Your EPM report is enable to send data and comments. You type in a revenue and a comment in the EPM report and save the sata. Where is the data stored?

Wähle eine der folgenden:

  • The revenue value in a Infocube and the comment in a DataStore Object

  • Both the revenue value and the comment in a DataStore Object

  • The revenue value in an InfoCube and the coment in another database table.

  • Both the revenue and the comment in a n InfoCube

Erklärung

Frage 77 von 80

1

Business rule and controls - Which rule type is required if you want to perform consolidation of investments?

Wähle eine der folgenden:

  • Eliminations and Adjustments

  • US Eliminations

  • Account-bassed Calculations

  • Intercompany Bookings

Erklärung

Frage 78 von 80

1

Dimensions - Which models types is required to consolidate investments? Note: There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Ownership

  • Standard

  • Consolidation

  • Financial Process

  • Exchange Rates

Erklärung

Frage 79 von 80

1

Data manager - From which of the following objects can you import data using the "Load Transaction Data from BW InfoProvider" Data Manager Package? Note: There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • InfoCube

  • InfoObject

  • MultiProvider

  • DataStore

  • InfoArea

Erklärung

Frage 80 von 80

1

Input forms and reports - You enter data using EPM Office Add-in Excel. When you attemp to save data, you receive an error message saying that the member you wan… What can you use to resolve this issue? Note: There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Change the header dimensions to base members

  • Set the Expand option to "Member and children"

  • Restrinct rows and columns to base members

  • Change the calc property of the parent members to N

Erklärung