You create a Trial Balance type report using Smart View. As you include all segments for the Chart of Accounts, you expect to see zero balance. Further with the Zoom Out function, you expect to see the balances in each account. Instead, IMTSSTNG is appearing in the report output. What is the issue with this report?

The GL Balances cube contains an Amount Type dimension (PTD, QTD, YTD, End Balance, etc.). In Smart View every dimension must have a member selected in either the grid or the POV. If Amount Type is omitted, Essbase substitutes the placeholder member “IMTSSTNG,” which is displayed exactly as retrieved. Because the report shows IMTSSTNG instead of balances, the issue is that no member of the Amount Type dimension was chosen.

A. If Currency were missing the system inserts the default reporting currency, not IMTSSTNG.
C. Balance Amount is not a dimension in the GL cube; balances are supplied by selecting the correct Amount Type member.

1. Oracle Fusion Cloud Financials: Using General Ledger, “Analyze Balances with Smart View,” p. 236–238 (24B edition).

2. Oracle Smart View for Office User Guide, “Ad Hoc Analysis - Required POV Members,” p. 49; note on placeholder ‘IMTSSTNG’.