Identify the true statements regarding Supporting Detail. Select all that apply.
A.
Importing Supporting Detail from Excel is supported.
B.
Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible
C.
Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy.
D.
Supporting Detail can be viewed using the Smart View Add-in Essbase Provider.
E.
Supporting Detail is stored in Essbase.
Explanation:
A: To add supporting detail that calculates values in a data form:
1 Open a data form in Excel,
2 In the data form, select the data cells for which you want to add detail.
3 Select Hyperion > Supporting Detail. For Office 2007, click Supporting Detail in the Task section of the
Hyperion ribbon.
4 Etc.
7. Enter data for the items for which you want to set or calculate values.
When you enter numbers into the Supporting Detail window, use the scaling that was set up for
the data values in the data form.
8 Click OK.
Values are dynamically calculated and aggregated before the data is saved.
C: Supporting detail can include text, values, and operators that define how data aggregates.
Supporting detail also provides a way to drill down into data to better understand its basis. For example, if the
bottom-level member in your outline is pens, you can add line items in supporting detail for ballpoint, fountain,
marker, and so on. Then you can aggregate the detail values to the pen member in the outline.
D:Oracle Hyperion Smart View for Office (Excel, PowerPoint, Word, and Outlook), are some of the various
Oracle tools that enable users to interact with an Oracle Essbase application.
Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart
View provides a common Microsoft Office interface designed specifically for Oracle’s Enterprise Performance
Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate,
distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for
accessing and integrating EPM and BI content from Microsoft Office products.Incorrect:
not E: Supporting details are stored in Planning Applications RDBMS not in Essbase.