101. RUN CONSOLIDATION only performs the eliminations, as Currency Translation has to be run before to populate the data in the Group Currencies . . TRUE OR FALSE
- TRUE .
102. the reverse amount is booked to a Plug account .
. TRUE OR FALSE
- TRUE .
103. Processing a dimension will execute the following steps:
• Validate Hierarchy.
• Validate Dimension member formulas.
• Update member data into BW.
• BW Attribute change run.
104. Plug Account should be balanced at group level (only Intercompany missmatches are left). TRUE OR FALSE
- TRUE
105. ACCTYPE is required for account type dimensions and is used to control sign display and aggregation behavior in reporting. TRUE OR FALSE
- TRUE
106. DIMLIST# properties are used as selection criteria in business rules. TRUE OR FALSE
- TRUE
107. Dimension member formulas are defined at the Application Set level, thus they are valid across all applications which use the dimension. TRUE OR FALSE
- TRUE
107.
Ø // denote comments.
Ø '*' indicates executable lines of code.
Ø No '.' at the end of statements.
Ø '#' is used in MDX statements to denote the receiver of the calculation
108. Use transaction code 'UJKT' to do logic debugging!
109. The NetWeaver logic files can be accessed by using the t-code UJFS.
110. Once the Consolidation User sees the validation account with a non zero value, they would know to run the Validation package which performs customer derived validation checks and sets the validation account back to zero. TRUE OR FALSE
- TRUE
111.In the conversion file : If you want to ignore external data (as listed in the External column), you can place the keyword *skip in the Internal column.
TRUE OR FALSE
- TRUE
-
112. You can use the asterisk (*) and question mark (?) wildcards in the External or Internal columns. An asterisk (*) stands for any character, while a question mark (?) stands for any single character. TRUE OR FALSE
- TRUE
113. If the source InfoCube has multiple key figures, the MVAL keyword can be used to import the data in only one data load.
. TRUE OR FALSE Ø TRUE .
114. By adding an ‘ENABLEJRN’ property to any dimension, only the members with a ‘Y’ in that property can be selected in journals.
. TRUE OR FALSE Ø TRUE .
115. If you have already created a journal template, creating a new template that changes the structure of the journal entries deletes the old template and all journal entries associated with that template.
. TRUE OR FALSE Ø TRUE .
116. The 'Driver' dimension is the one dimension per application whose members are used to compare against other dimension members to see if they are permissible. There is only one driver dimension per application but it can be used as a point of comparison with any other dimension in the application. . TRUE OR FALSE Ø TRUE .
117. "Validation:The only operators are '<>' and '='. But you can include multiple single values separated by commas.
. TRUE OR FALSE Ø TRUE .
118. Which of the following are true regarding the reversal of signs during data loads?
Choose the correct answer(s).
A If the source value is positive it will be reversed if it is an AST account type. B If the source value is positive or negative it will be reversed if it is an AST account type.
C If the source value is positive or negative it will be reversed if it is an LEQ account type.
D If the source value is positive or negative it will be reversed if it is an INC account type.
E If the source value is positive or negative it will be reversed if it is an EXP account type.
F If the source value is negative it will be reversed if it is an AST account type.
119. Team
A group of users. Fairly equivalent to a NW role.
One user can be designated as a team leader.
120. It is the combination of member access profiles & task profiles that determine overall BPC access.
TRUE OR FALSE
TRUE
121.some important programs:
UJA_COPY_APPSET
UJA_APPSET_BAK_RESTORE
UJ0_STATISTICS_DELETE
UJA3_WRITE_SYS_ADMIN_NO_CHECK
UJA_REFRESH_DIM_CACHE
UJK_SCRIPT_LOGIC_TESTER
UJKT
UJT_CHECK_TABLE_ENTRIES will allow you to check table entries for transports
MDX Test
122. 52. Tables within BW system:
Tables associated with cube fall under /B28/F or E namespace
Tables associated with the ABAP fall under UJ namespace All the BI objects would get created under /CPMB/ name space.
123.Comparison of Microsoft Analysis Server table to BW tables:
Open Request – Write Back table
Fact Table – Fac2 Table
E Table – Fact Table
124.You can find the tables through their technical names in Se16 TC.
TRUE OR FALSE
TRUE
125. Two types of Optimization:
Lite Optimize: will close the open request, compress and index the cube, and update database statistics for the BI Cube. Moves the data from F-Table to E-Table
Full Optimize: will perform the same operations as Lite Optimize, but will also check the NetWeaver BI data model. If the data model can be improved, Full Optimize will do so, and this could take a long time to run (for
cubes with large data volumes). Data moves from F-Table to E-Table and also closes the Request ID’s .
126. data remodel is done in full optimization .
TRUE OR FALSE
TRUE
127.Compression is done in Lite and Full optimization.
TRUE OR FALSE
TRUE
128.
BPC 7.5 SP05 patch 1 increased formatting performance by
40%
TRUE OR FALSE
TRUE
129.You can change the BPC dimensions in the backend which BW. TRUE OR FALSE FALSE .
130.
Cell queries have been moved to Axis Queries because they are faster even though they bring back more data.
TRUE OR FALSE
TRUE
131.
If multiple EVDRE’s are needed, the first EVDRE should be RSDRI in order to build the rows.
TRUE OR FALSE
TRUE
132. Work Status is set up from the Administrators at both the application set and application level.
TRUE OR FALSE
TRUE
133.Work Status is set only athe application level .
TRUE OR FALSE
FALSE
134. To use work state tracking, you must specify the hierarchy (H1, H2, H3, ..., Hn) within the owner dimension for which you want to use work status.
TRUE OR FALSE
TRUE
135. You specify the hierarchy for which you want to track the work status of deliverables in the APPROVALORG field on the Setting Application Parameters.
TRUE OR FALSE
TRUE
136. Work Status:You can define only one hierarchy for each application within an application set.
TRUE OR FALSE
TRUE
137.The work state “Locks Not Set” “is a Default work state” with internal code of “0” with “both” for Controlled by. This work state must be the first and cannot be changed.
TRUE OR FALSE
TRUE
138. SAP Business Planning and Consolidation 7.5, version for SAP NetWeaver allows setting any combination of between 3 and 5 dimensions as relevant for locking, despite the dimension type. So Work Status can also be configured for an Account type dimension. TRUE OR FALSE
TRUE
139. Email Notification is only available in SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver.
TRUE OR FALSE
TRUE
140. There is a reporting function EVLCK available as well. This function provides a read only comment retrieval for Work Status.
TRUE OR FALSE
TRUE
141. Script logic statements are case-insensitive.
TRUE OR FALSE
TRUE
142. You cannot use MDX keywords in *REC. TRUE OR FALSE
TRUE
143. REC always needs to be accompanied by WHEN / IS / ENDWHEN. Stand-alone REC statements do not have any effect.
TRUE OR FALSE
TRUE
144. *FOR / *NEXT
*FOR / *NEXT is used to repeat certain scripts written between a FOR and an immediate NEXT for a set of members. Sets of members can be provided either directly in the FOR statement or through variable. The Logic Module supports any number of FORNEXT loops in the body of the logic files. The *FOR Statement has to be accompanied by a variable. In the Example %KPI% is the user defined variable which was used for the Loop.
145. The SELECT statement is fairly limited, as it only supports the equal sign (=) , not equal to (<>) and cannot be used to combine multiple filter criteria with AND or OR keywords.
146. SELECTCASE structures currently CANNOT be nested.
147. WHEN/ENDWHEN which has a much better performance then *SELECTCASE.
148. The syntax for dimension member formulas requires a square bracket around the dimension and the member and separated by a period. The only exception is with the account dimension, where only the dimension member is needed. Standard arithmetic functions are available, such as addition (+), subtraction (-),multiplication (*) and division (/), as are the MDX keywords supported by SAP NetWeaver BW. New with SAP Business Planning and Consolidation, upper and lower case letter sensitivity becomes important for dimensions and dimension members, sobe careful in your formulas!.
148. The SAP Business Planning and Consolidation default Solve_Order is equal to 3 for measures and 5 for members.
149. SPREAD:The Spread modeling option allows you to take a value and allocate it among selected destination cells. The value can be allocated equally, or it can be weighted by a range of values. For example, you can take the value 100 and spread it across a number of columns that represent each month of the year.
150. TREND:The Trend modeling option takes a value or percentage and grows it by a factor among selected cells. This option places the source value in the first cell of the destination range. Each subsequent cell in the destination increases by the amount or percentage specified.
151. WEIGHTED:The Weighted modeling option lets you allocate a set of values by weighted factors in your spreadsheet. It allows you to take a set of values, grow them if desired, and then allocate the new amount based on the relative weights of the selected cells. The destination range is the same as the weight range. For example, you can weigh 12 months of revenue based on 12 months of cost of sales.
161. The comment feature must be turned on at the
Application level for both methods.
162. EVCOM - Add a comment to a cell .
163.Comments are stored in
Cube
DSO
Real time cube
Table
Answer: Table
164. What are the reporting commands updates the data base:
EVDRE
EVGTS
EVCOM
EVBT
Answer: EVDRE & EVCOM
165. To use the excel popup feature for comments, you need to turn that on via th workbook options.
TRUE OR FALSE
TRUE
166. System Reports are pre-designed web reports, that allow you to report on system information/activity, rather than transaction/master data in the system.You can report on:
• Activity Audit
• Data Audit
• Security
• Comments
• Work Status
167. A Distribution Template may contain the following fields:
• BOOK: the title of your distributed book.
• SECTION: denotes the beginning of a section.
• REPNAME: report filename, location and title (can also be for Input Schedules).
• FIXKEY: sets dimension members to the fixed values when generating the report
– For example, you can ensure that a report runs for 2008.TOTAL and ACTUAL.
• VARYKEYS: lists the dimensions and dimension members that should vary for each report that will get created.
– For example, if you want to create a new offline report for each Entity/Cost Center/etc, you would specify that dimension as a Vary Key.
– You then map a specific Vary Key to a User ID who should receive that report (for example, the Cost Center manager). This way, each user who gets a report has the required dimension(s) set to their individual values
Note: If you wish to distribute by email, make sure an email address has been maintained for each user.
• SECTIONEND: denotes the end of a section.
168. Validations configuration is performed in transaction UJ_VALIDATION.
TRUE OR FALSE
TRUE
169. One driver dimension for each application for validation.
TRUE OR FALSE
TRUE
170.Only one is correct.
There can be n driver dimension or 1 app.
There can be only 1 driver dimension for 1 app.
There can be n driver dimensions for m apps.
There can be max 5 driver dimensions for a single app.
Answer : There can be only 1 driver dimension for 1 app.
171. Rules and Members are a N:N relationship (1 rule can be assigned to multiple members, and 1 member can be assigned to multiple rules).
TRUE OR FALSE
TRUE
172. You can turn validations on or off by application.
TRUE OR FALSE TRUE
173. The EvUSR (User ID) function returns the name of the user who is logged on to the system.
174.The EvAST (Application set) function returns the name of the current application set.
175.The EvAPP (Application) function returns the current application name.
176.The EvDES (Description) function returns the description of a specified member.
177.The EvDIM (Dimension) function retrieves a dimension name of the specified type from the database.
178.The EVPRO function returns the value of a specified property for a specified member.
179.The EvRTI function returns the time and date of the last data refresh.
180.The EvCOM function references another cell and sends its value, a textual comment, to the database when specified.
181.The EvHOT (hot link) function sets up a hot link to another report or cell withi another report. Hot links can be used to guide a user through ad-hoc analysis.
182.The EvGTS (Get value and scale) function retrieves a data value based on the specified members, and scales the value if the scale property is enabled on the dimension.
183.This Send function references another cell and sends its value to the database when you select Send and Refresh Schedules.
184.The EvTIM (time period offset) function specifies an offset from a given time period.
185.You can double click on the EVCVW output to set the current view. EVDRE templates use the EVCVW function in the page key range.
186.EVPRO is being used below to pull in the account type property. EVBET performs
186.A variance calculation based on the acctype value. For example, if revenue actual is greater than plan, the variance if positive. However, if expense actual is higher than plan, the variance is negative.
187.EVBET is used to calculate variances in conjunction with the ACCTYPE property.
188. AVAILABLEFLAG Controls whether the system is offline or not. Yes means the system is online and available for sending data to the database. You can take the system
offline by changing the value to No. (Required)
189. YTDINPUT This parameter controls whether data is input in year-to-date format. Valid options are 1, which means ytd format; or 0, which means periodic format. (Optional) YTDInputTimeHir This parameter designates the time hierarchy that will be used by a YTD storage application. H1 is the default.
190. If an application parameter is required, you can leave it blank to accept the default, but if you delete the parameter, the system may not work correctly. If an application parameter is optional, you can delete it if you wantto.
191.if the application parameter is required and it is blank then
System will crash
Will throw an error message Gives a warning message
Leave it blank to accept the default.
192. You can set work status to top-down in the TOPDOWN field in the Application Parameters.
193. Work Status locks can allow you to lock down documents that have had the Application Context specified.
194. There is an AppSet web admin parameter called “LANDINGPAGEITEM”, which allows you to control what is viewed when you open the BPC Web “Getting Started” page (landing.aspx).
195. 'AS_IS' is key word that is supported in the formula field that means to leave a value untouched if it is already in the destination currency. 'AS_IS' cannot be combined with anything other than '-1'. 'AS_IS' is used when you need a historical rate.
196.
END - uses the end of month rate as stored in the rate application.
AVG - uses the average rate as stored in the rate application. COPYLC - translate the local currency to group or reporting currency with a factor of '1.
OPEEND - the end rate of the last period of the prior year. AS_IS - Leave untouched a value already in the target currency.
OPEAVG - the average rate of the last period of the prior year.
197.
Equity Method 30
Purchase method 86
Proportional Method 70
198. Generally speaking, if the ownership % is greater that 50% the purchase method will be used in the US but the equity method is used if the amount is less than 50%. The proportionate method is similar to the purchase method and is used more frequently in Europe.
199. A owns 80% of B company, 70% of C and 40 % of D.
Which company can use the quity method.
B
B & C
D
A
Answer : A company can use equity method.
200. The properties that begin with 'Org' all relate to the dynamic hierarchy editor.
No comments:
Post a Comment