You need to calculate average units sold by the customer dimension within an ASO database. The member formula should calculate correctly regardless of level within the customer dimension. Identify the correct syntax for the member formula.
With an average block density greater than 90%.
You are performing incremental loads to an ASO database during the day, providing near real time data to the SaleDtl ASO database. Before the incremental load, you need to clear a specific set of data in the fastest amount of time possible.What is the best solution?
Identify the two true statements about materialization in ASO.
You need to tune a block storage option database for calculations on a 32bit Essbase server. Identify the two starting point tuning steps that you might take(assuming no direct I/O).
Which six files are involved in database recovery for block storage option after a database crash?
