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.E: In Planning applications, when you delete supporting detail for a cell, you affect the associated
value in the relational database. You specify how to handle the stored Essbase value.
Note (on A and E): To synchronize supporting detail with Essbase:
1 Open a data form in Excel
2 In the data form, click the cell that has the supporting detail you want to remove.
3 Select Hyperion > Supporting Detail. For Office 2007, click Supporting Detail in the Task section
of the
Hyperion ribbon.
4 In the Supporting Detail window, delete the information, then click OK.
5 Select an option from the displayed message to specify how to handle the aggregate value of
the deleted
supporting detail stored in Essbase:
To delete the value from Essbase, click Yes, set the value(s) to #Missing.
To leave the data value in Essbase as is, click No, leave the value(s) as is.
ACD
A,C,D.
Not E. Support details are stored in Planning’s RDBMS, not in Essbase.
I think only C,D are correct.
so, importing Supporting Details from excel are supporting ??
Check beneath, are some completely unrelated web-sites to ours, on the other hand, they may be most trustworthy sources that we use.
I think A,C because:
1: Yes – Supporting details is suported by excel;
2: NO – Is possible entry value for multiple cells;
3: Yes – Supporting details can contain a hierarchy;
4: NO – Supporting datails is supported by Smart view Planning Provider not by Smart view Essbase Provider;
5: NO – The result of supporting detail is stored im Essbase not the supporting details, the supporting detail is stored in Planning database;