1Z0-531 · Question #31
Assuming Sales and Year are sparse and Actual is dense, what two actions will the following calc script perform? FIX (Actual, @CY, Sales) DATAEXPORT "BINFILE" "data.txt"; ENDFIX
The correct answer is A. Export the data for actual, current year, sales into a text file called data.txt C. Export data blocks in a compressed encrypted format. The FIX...ENDFIX command block restricts database calculations to a subset of the database. All commands nested between the FIX and ENDFIX statements are restricted to the specified database subset. FIX (fixMbrs)COMMANDS ;ENDFIX fixMbrs: A member name or list of members from…
Question
Assuming Sales and Year are sparse and Actual is dense, what two actions will the following calc script perform? FIX (Actual, @CY, Sales) DATAEXPORT "BINFILE" "data.txt"; ENDFIX
Options
- AExport the data for actual, current year, sales into a text file called data.txt
- BExport the data for actual, current year into a text file called data.txt
- CExport data blocks in a compressed encrypted format
- DCreate a text file that can be imported using the DATAIMPORTBIN calc command in another database
How the community answered
(30 responses)- A77% (23)
- B17% (5)
- D7% (2)
Explanation
The FIX...ENDFIX command block restricts database calculations to a subset of the database. All commands nested between the FIX and ENDFIX statements are restricted to the specified database subset. FIX (fixMbrs)COMMANDS ;ENDFIX fixMbrs: A member name or list of members from any number of database dimensions. DATAEXPORT writes data to a text file, binary file, or as direct input to a relational file using ODBC. The data blocks will be saved in a compressed encrypted format to a text file. For a binary output file:DATAEXPORT "Binfile" "fileName"
Topics
Community Discussion
No community discussion yet for this question.