Spreadsheet Add-in User's Guide for Excel

Index

Special Characters
A B C D E F G H I K L M N O P Q R S T U V W X Z

Special Characters

? wildcard character (2220)
* wildcard character (2219)
#Missing strings, suppressing (2074)
#NoAccess strings, suppressing (2075)

access
- to databases (1917), (2262)
- to Essbase data (1918), (2263)
- to linked partitions (2538)
- to linked reporting objects (2511)
- to multiple databases (2528)
- to online help (1861)
- using Essbase commands (1903)
- with drill-through (2685)
Acrobat Reader (1756) See also Adobe Acrobat Reader
ad hoc reports (1765), (1936), (2347), (2643)
Add button (2732)
Add-in Manager (1850)
adding members (2203) See also members, adding
adjusting columns (1904), (2335) See also columns, adjusting width, columns, adjusting width
administrators (1770)
Adobe Acrobat Reader (1754)
advanced interpretation engine (2453)
Advanced Interpretation mode (2452), (2468)
aliases
- definition of (2151)
- displaying
  - process of (2153)
  - with member names (2163)
  - with Query Designer results (2199)
- in tables (2152)
alternate dimensions (1808) See also dimensions, alternate
alternate names (2149) See also aliases
ancestors, definition of (1832)
AND operators (2210)
API (1795)
application designer (1771)
application partitions (2542) See also linked partitions
application programming interface (1796)
applications/databases
- Sample Basic (1849), (1906), (1929), (2273)
- sample for drill-through (2677)
- Sample Interntl (2633)
- Sample Xchgrate (2634)
ascending sort order
- with drill-through (2726)
- with Query Designer (2298)
asymmetric reports
- definition of (2306)
- pivoting (2311)
- retrieving data into (2304)
Attach Linked Object dialog box (2483), (2495), (2507)
attaching reporting objects to cells (2478) See also linking
attaching to databases (1914) See also connecting
attributes, drill down (1983)
auditing updates (2576)
auto logouts (2257)
Auto Sort Rows option (2463)

blank
- columns (2320)
- rows (2317)
blocks, locking data (2564)
Boolean operators (2206), (2226)

Calculation command (2587)
Calculation dialog box (2589)
calculations
- database status (2593)
- databases (2417), (2585)
- dynamic (2412)
- reducing calculation time (2413)
- scripts (2590)
- specifying latest time period (2434)
- substitution variables (2442)
- with Dynamic Time Series (2437)
canceling data retrievals (1950)
Cascade command (2599)
Cascade Information page (2608)
Cascade Options dialog box (2605)
cascading sheets
- creating table of contents (2624)
- destination (2612)
- format (2621)
- level of detail (2609)
- names (2619)
- output type (2613)
cell notes
- accessing linked (2516)
- linking to cells (2493)
cell ranges
- keeping (2029)
- removing (2049)
- retrieving (2396)
- selecting nonadjacent (2040)
- with drill-through (2692)
cells
- accessing linked partitions (2541)
- applying styles (2088), (2123)
- attaching reports (2474) See also linking
- attaching URLs (2496) See also linking
- EssCell function in (2400)
- formatting (2090), (2128), (2485)
  - in data cells (2127)
  - of dimension members (2119)
  - of Dynamic Calculation members (2422)
  - of parent members (2098)
- formulas in (2324), (2342), (2361), (2401)
- linked reporting objects (2476), (2498)
- linking files to (2477)
- linking notes to (2490)
- linking URLs to (2499)
- retrieving a range (2397)
- retrieving single values (2399)
- selecting nonadjacent (2041)
- with nondatabase values (2321)
Change Password dialog box (1933)
changing
- passwords (1932)
- row and column orientation (2016)
- spreadsheet format (2082)
- styles (2087)
children (defined) (1827)
Clear All button (2741)
Clear button (2740)
Clear command (1962)
clearing styles (2140)
click (defined) (1872)
client
- components (1777)
- software (1847)
- upgrading with server (1763)
client-server environment (1776)
collapsing data views (1987) See also drill
colors, setting (2086)
columns
- adjusting width (1905), (2334)
- blank (2319)
- displaying as rows (2009)
- displaying selected (2032)
- filtering by (2291)
- keeping selected (2034)
- nested (1974)
- pivoting (2015)
- removing selected (2052)
- retrieving into (1978)
columns, drill-through
- choosing (2717)
- selecting display order (2718)
- selecting for retrieval from relational source (2715)
- sorting (2728)
commands
- Calculation (2588)
- Cascade (2600)
- Clear (1963)
- Connect (1921), (2265), (2529)
- Currency Report (2631), (2647)
- Disconnect (2245)
- FlashBack (1955)
- Keep Only (2031)
- Linked Objects (2481), (2505)
- Lock (2568)
- Member Selection (2211)
- Navigate Without Data (2061), (2066)
- Pivot (2011)
- Remove Only (2051)
- Retrieve (1949)
- Retrieve & Lock (2566)
- Send (2570)
- Undo (1960)
- Unlock (2575)
- Zoom In (1970)
- Zoom Out (1990), (1994)
comparison operators (2207), (2293)
computing environment (1748)
concurrent
- database access (1926), (2525)
- updates to server (2560)
conditional retrievals (2285)
Connect command (1920), (2264), (2530)
connecting (1913) See also disconnecting
- to a database (1916), (2261)
- to a relational data source (2656), (2684), (2702)
- to Essbase (1924), (2268)
- to Essbase Integration Server (2683), (2703)
- to multiple databases (2526)
- viewing current connections (2535)
Connection Information text box (2536), (2591)
consolidations (defined) (1841)
conversions, currency (2627)
creating queries (2179)
creating reports (1937) See also reports, creating
Currency Conversion product (1799)
currency conversions
- modifying exchange rates (2649)
- reporting (2644)
- sample databases (2641)
- settings (2650)
Currency Report command (2630), (2646)
Currency Report dialog box (2648)
current time period (2435) See also Dynamic Time Series
cursors (Essbase) (1942)
custom applications (1798), (1803)
Customize button (2712)
customizing drill-through reports (2701)

data
- calculating (2584)
- changing orientation (2007)
- comparison operators (2292)
- displaying (1811), (1947)
- dynamically calculating (2416)
- filtering (2287)
- filtering, with drill-through (2738)
- formatting (2080)
- locking (2562)
- missing (2076)
- modifying (2559)
- navigating (1846), (2055)
- pivoting (2012)
- relational, with drill-through (2653)
- removing subsets (2044)
- retaining subsets (2025)
- retrieving (1910) See also retrieving
- sorting (2288)
- unlocking (2573)
- updating (2558), (2577)
data sort order, with drill-through (2724)
data source, relational (2704)
databases
- calculating (2586) See also calculations
- connecting (2527) See also connecting
- consolidations (1840)
- defined (1805)
- dimensions (1818)
- disconnecting from (2246)
- linked (2544) See also linked partitions
- loading (1930), (2274)
- locking (2561)
- members (1822)
- organization (1815)
- outlines (1845)
- queries (2173) See also queries
- restoring previous views (1954)
- rules (1816)
- sample (1909), (2635), (2679)
- selecting (2272) See also connecting
- switching (2531)
- viewing connections (2534)
deleting
- filters, drill-through (2742)
- selected members (2047)
- styles (2138)
descendants (defined) (1831)
descending sort order
- with drill-through (2727)
- with Query Designer (2300)
Destination Options page (2615)
destinations
- cascaded sheets (2614)
- Query Designer queries (2191)
detaching (2239) See also disconnecting
dialog boxes, Help buttons (1865)
dimensions
- alternate (1806)
- applying styles (2121)
- currency conversion and (2637)
- described (1807), (1817)
- drilling down on (1969), (1982)
- drilling up on (1995)
- naming elements (1819)
- pivoting (2018)
disabling data retrieval (2057) See also navigating without data
Disconnect
- command (2244)
- dialog box (2249)
disconnecting
- forced logouts (2256)
- from Essbase (2247)
- from Essbase Integration Server (2744)
discontinuous rows and columns (2037)
disk space, effect on Dynamic Calculation (2419)
display
- options (2081)
- order of columns, drill-through (2719)
Display page (Essbase Options dialog box) (1893), (2672)
Display Unknown Member option (2344), (2355)
displaying data (1812), (1946)
distributed sheets (2597) See also cascading sheets
double-clicking
- defined (1873)
- enabling
  - for drilling (1886)
  - for linked object browsing (2513), (2551), (2693), (2708)
downloading Acrobat Reader (1755)
drag, defined (1874)
drag-and-drop operations (2021)
drill
- by double-clicking (1881)
- down on attributes (1984), (1985)
- down on consolidations (1844)
- Formula Fill (2366)
- retain formulas during (2365)
- to less detail (1989)
drill-through
- accessing (2661), (2686)
- cells, defining styles for (2688)
- described (2655), (2657)
- installing (2666)
- multiple reports (2660)
- requirements (2664)
- sample
  - database (2676)
  - drill-through report (2680)
  - file (2690), (2691)
- styles for cells (2662)
- tutorial guidelines (2667)
Drill-Through Wizard
- dialog box (2713)
- introductory screen (2714)
duplicating sheets (2596) See also cascading sheets
Dynamic Calculation members, applying styles to (2423), (2426)
Dynamic Time Series
- defined (2430)
- specifying latest time period (2439), (2440)

Edit Cell Note dialog box (2518)
Edit menu (1961)
Edit URL dialog box (2523)
editing
- cell notes (2517)
- linked files (2515)
- URLs (2520), (2522)
editing in cells (1880)
Enable Hybrid Analysis option in Zoom page (Essbase Options dialog box) (1896)
enabling
- FlashBack setting (1965)
- mouse actions (1877), (2512), (2550)
- Navigate Without Data (2063)
environment (computing) (1746)
Essbase
- API (1794)
- architecture (1774)
- Cascade Options dialog box (2604)
- computing environment (1747)
- connecting to (1919) See also connecting
- Disconnect dialog box (2248)
- disconnecting from. See disconnecting (2243)
- Member Selection dialog box (2214), (2232)
- Member Selection dialog box, from Query Designer (2183)
- menu (1858)
- migration information (1759)
- Options dialog box (1890), (2276), (2669)
- starting a session (1854)
- System Login dialog box (1922), (2266)
- upgrades (1760)
Essbase Integration Server (1802), (2652)
Essbase Integration Server drill-through (2654) See also drill-through
EssCell function (2405)
- error messages (2411)
- syntax (2406)
exchange rates (2636)
Execute button (2711)
executing drill-through reports (2695), (2699)
expanding data views (1967) See also drill down
expanding formulas when drilling (2389)
external files (2471)

files
- accessing linked (2514)
- destinations
  - cascaded sheets (2617)
- linking to data cells (2480)
- sample for tutorial (1758), (2258)
filtering data (2282)
filters
- operators (2734)
- with drill-through (2739)
Find Member dialog box (2221)
finding members (2202), (2216)
FlashBack command (1956)
font
- formats (2106)
- style list (2109)
Font dialog box (2108)
forced logouts (2255)
formatted sheets
- pivoting in (2345)
- retrieving data into (2315)
formatting
- data cells
  - linked objects (2484), (2547)
  - read-only (2125)
  - read/write (2126)
- dimension members (2117)
- displaying aliases (2147)
- displaying aliases and names (2158)
- Dynamic Calculation members (2425)
- enabling styles (2113)
- linked object cells (2487), (2546)
- options for cascaded sheets (2620)
- parent members (2093)
- repeating member labels (2167)
- spreadsheets (2083)
- text and cell styles (2133)
Formula Fill option (2381), (2391)
Formula Preservation mode
- Formula Fill (2359)
- pivoting in (2352)
- restrictions with (2350), (2375)
- Retain on Keep and Remove Only (2358)
- Retain on Retrieval (2338), (2356)
formulas
- EssCell (2404)
- expanding when drilling (2388)
- in cells (2326), (2374)
- preservation
  - effects on other operations (2373)
  - enabling (2337), (2360)
  - restrictions with (2351)
free-form reporting
- entering generation and level names in (2465)
- in Advanced Interpretation mode (2451)
- in Free-Form mode (2455)
- retrieving data (2445)
Free-Form retrieval mode (2456)
- guidelines (2462)
functions (1867) See also macro functions

generations
- defined (1835)
- entering names in spreadsheet (2470)
Global page (Essbase Options dialog box) (1884)

Help, accessing (1860)
Help buttons (1864)
Hybrid Analysis
- Enabling in the Zoom page (Essbase Options dialog box) (1897)
Hyperion Essbase
- intended audience (1768)
- products of (1787)
Hyperion Essbase Spreadsheet Add-in
- accessing drill-through from (2687)
- logging data updates (2582)
- retrieval cursors (1944)
- starting (1851)
- users, described (1773)

in-cell editing (1879)
installation, drill-through (2665)
Integration Server drill-through (1800) See also drill-through
Internet, linking cells to URLs (2503)
Interntl sample database (2638)

Keep Only command
- described (2030)
- in Formula Preservation mode (2367)

labels
- applying styles (2118)
- displaying with aliases (2162)
- entering in spreadsheet (2447), (2457)
- member names (2322) See also member names
- repeating (2170)
LAN (1744) See also networks
latest time period, specifying (2429)
Latest Time Period option (2438)
levels
- cascading by (2610)
- defined (1837)
- drilling down (1998)
- drilling in (2004)
- entering names (2469)
linked objects
- partitions (2132) See also linked partitions
- reporting objects (2131) See also linked reporting objects
Linked Objects Browser dialog box (2524), (2552), (2694), (2709)
- LROs (2473)
Linked Objects command (2482), (2494), (2506)
linked partitions
- access privileges (2553)
- accessing from spreadsheet (2543)
- cells, applying styles (2549)
Linked Reporting Objects
- accessing from spreadsheet (2510)
- applying styles (2486)
- cell notes (2491)
- creating (2472)
- external files (2479)
- URLs (2500)
linking
- cell notes (2489)
- external files (2475)
- partitions (2537)
- URLs to data cells (2497)
list, cascaded sheets (2626)
local area network (1745) See also networks
Lock command (2567)
locking data blocks, with multiple users (2563)
logging
- off of Essbase (2241) See also disconnecting
- on to a relational data source (2706)
- on to Essbase (1915) See also connecting
- on to Essbase Integration Server (2707)
logging data updates from spreadsheet (2580)
logical operators (2228)
logouts, forced or auto (2254)
Lotus 1-2-3
- mouse actions (1878)

macro functions
- EssCell (2403)
- Spreadsheet Toolkit (1751), (1789), (1866)
main menu (Essbase) (1856)
manual calculation mode (2409)
Member Information dialog box (2215)
member names
- aliases for (2146)
- alternate (2145) See also aliases
- applying styles (2099)
- displaying with aliases (2161)
- entering in spreadsheet (2448), (2458)
- formatted sheets (2323)
- indenting (1842)
- repeating (2171)
- with EssCell function (2408)
Member Preview dialog box (2230), (2231)
Member Retention option (2005)
Member Selection, with Query Designer (2184)
Member Selection command (2212)
Member Selection dialog box (2213)
Member Selection Preview dialog box (2187)
members
- adding (2185)
- aliases for (2150)
- ancestors (1833)
- applying styles (2091), (2114), (2116)
- children (1826)
- collapsing (1992)
- defined (1821)
- deleting (2045)
- descendants (1830)
- deselecting (2233)
- drilling down on (1975), (1981)
- drilling up on (1993)
- Dynamic Calculation (2415)
- Dynamic Time Series (2431)
- finding (2201), (2217)
- generations (1834)
- levels (1836)
- names (1843) See also member names
- parents (1824)
- retaining (2027)
- selecting (2186), (2205)
- siblings (1828)
menu, Essbase (1857)
messages (Essbase)
- database calculation status (2594)
- display options (2353)
- EssCell (2410)
- unknown member (2343)
migrating to release 6 (1762)
missing values
- suppressing (2069)
- suppressing disabled (2383)
missing values, suppressing
- in cascaded sheets (2623)
- unavailable (2386)
Mode page (Essbase Options dialog box) (1900), (2280), (2376)
money (2628) See also currency conversions
mouse actions, enabling (1868)
moving
- rows and columns (2017) See also pivot
- through worksheets (2054)
multidimensional databases (1809) See also databases
multiple filter conditions, with drill-through (2737)

Named Pipes protocol (1786)
names
- alternate (1838) See also aliases
- applying styles (2094)
- displaying with aliases (2160)
- entering generation (2466)
- entering level (2467)
- repeating (2169)
Navigate Without Data command (2058), (2065)
nested columns or rows (1972)
networks (1782)
Next Level option (2003), (2611)
nonadjacent cells (2036)
notes, linking to data cells (2492)
null values (2407)
numeric values, preserving (2329)

Objects product (1804)
ODBC clients (1793)
OLAP
- defined (1766)
- server (1778) See also server
online analytical processing (1767)
online help
- displaying for spreadsheet (1862)
opening
- Essbase (1853)
operating systems (1781)
operators, comparison (2208), (2294)
options
- Cascade (2606)
- Display (1892), (2277), (2671)
- Global (1885), (1901), (2281), (2675)
- Mode (1899), (2279), (2377), (2674)
- settings for advanced tutorial (2275)
- settings for basic tutorial (1888)
- settings for drill-through tutorial (2668)
- Style (2102)
- Zoom (1895), (1999), (2278), (2673)
Options dialog box (1891), (2670)
OR operators (2209)
Order By dialog box (2730)
ordering
- columns, drill-through (2720)
- rows, drill-through (2722)
outlines
- consolidations (1839)
- described (1814)
- dimensions (1820)
- Dynamic Calculation members (2418)
- Dynamic Time Series members (2436)
- members (1823)
output, cascaded sheets (2607)
overlapping styles (2134)

parent members
- applying styles to (2096)
- defined (1825)
Partitioning product (1790) See also linked partitions
partitions (1791) See also linked partitions
passwords
- changing (1934)
- entering (2271)
pattern matching (2227)
pivot
- asymmetric reports and (2310)
- by dragging (2022)
- described (1875), (2019)
- effect on text (2333)
- formatted sheets and (2346)
- formula preservation and (2349)
- rows or columns (2014), (2312)
- unavailable (2332)
- without retrieving data (2064)
Pivot command (2010)
power loss (2250)
preferences (1883) See also options
preserving formulas (2339), (2392)
primary mouse button (1869)
printer destination, cascaded sheets (2618)
programming interface (1797)

queries
- applying styles (2192)
- creating (2180)
- defining (2174)
- deleting (2193)
- retrieving (2175)
- saving (2188)
Query Designer
- applying option settings (2196)
- connecting to multiple databases (2195)
- creating queries (2181)
- data filtering panel (2289)
- data sorting panel (2297)
- filtering data (2284)
- hint panel (2177)
- layout panel (2182)
- messages (2301)
- messages and confirmations (2194)
- navigation panel (2176)
- properties panel (2178)
- save as query dialog box (2190)
- sorting data (2296)

read-only cells (2129)
read/write cells (2130)
relational data source (2705)
relational databases, accessing with drill-through (2659)
remote databases (2539) See also linked partitions
Remove Only command
- described (2050)
- in Formula Preservation mode (2368)
Remove Unselected Groups option (2387)
removing (2046) See also deleting
Repeat Member Labels option (2166)
report script commands (2460), (2464)
reports
- ad hoc (1935), (2348)
- ad hoc currency (2645)
- asymmetric (2303)
- creating multiple (2598)
- formatted (2314)
- free-form (2444)
- methods of generating (1749)
- saving (2236)
reports, creating
- ad hoc (1938), (2642)
- Cascade (2595)
- Member Selection (2200)
- methods (1750)
- Query Designer (2172)
reports, drill-through
- accessing (2682)
- customizing (2663), (2700)
- disconnecting from (2743)
- executing (2696)
- selecting to view or customize (2698)
restoring database views (1952)
restrictions, with Formula Preservation (2372)
Retain on Keep and Remove Only option (2379)
Retain on Retrieval option
- disabled (2385)
- enabled (2340), (2378)
Retain on Zooms option (2380), (2390)
retaining
- data subsets (2026)
- formulas (2325), (2331)
  - when drilling (2364)
  - when retaining data (2363)
  - when retrieving (2336), (2362)
- selected members (2028)
Retrieve & Lock command (2565)
Retrieve command (1948)
retrieving
- Advanced Interpretation mode and (2454)
- canceling (1951)
- conditional (2283)
- currency conversion (2629)
- cursors (1943)
- data (1912)
- Dynamic Calculation members (2414)
- formula preservation and (2369)
- Free-Form mode and (2459)
- functions (2402)
- increasing speed (2142), (2309), (2398), (2421)
- into asymmetric reports (2302)
- into columns (1979)
- into formatted sheets (2316)
  - rules for (2328)
- into rows (1977)
- less detail (1986)
- modes (2450)
- more detail (1966)
- performance impact (2141), (2308), (2420)
- range of cells (2395)
- retaining formulas and (2341), (2370)
- selected cells (2393)
- starting process and (1940)
- suppressing data and (2060)
reverting to previous database view (1958)
rows
- blank (2318)
- deleting during pivot (2313)
- displaying as columns (2008)
- displaying selected (2033)
- filtering by (2290)
- keeping discontinuous (2038)
- nested (1973)
- pivoting (2020)
- removing selected (2053)
- retrieving into (1976)
- sorting within (2299)
- suppressing values in (2068), (2622)

sample
- databases
  - connecting to (1927), (2640)
  - described (1757), (1908), (2632)
- databases, in drill-through (2678)
- files for tutorial, location (2259)
Sample Basic
- connecting to (1928)
- described (1907)
Sample directory (2260)
Save As command (2235)
Save command (2234)
saving
- queries (2189)
- worksheets (2237)
secondary mouse button (1870)
select (defined) (1871)
Select Calc Script option (2592)
Select Columns and Display Order dialog box (2716), (2721)
Select Data Filters dialog box (2731)
Select Data Sort Order dialog box (2725)
Select Drill-Through Report dialog box (2697), (2710)
Select Filter Values from the List dialog box (2735), (2736)
selecting
- cells to keep (2035)
- cells to remove (2048)
- latest time period (2428)
- members (2204)
- nonadjacent cells (2039)
- range of cells for retrieval (2394)
Send command (2569)
sending
- data to server (2555)
- log file (2578)
server
- changing password (1931)
- client-server environment (1775)
- connecting to (1925), (2269)
- described (1779)
- disconnecting from (2242)
- Essbase Integration Server (1801), (2651)
- Essbase OLAP, described (1780)
- logging updates to (2557)
- migrating to release 5, with client (1764)
- name (1923), (2267)
- on network (1783)
- sending data to (2556)
Set Filter on Column dialog box (2733)
shared members, applying styles to (2105)
sheet destination, Cascade option (2616)
sheets (1939) See also worksheets
shortcuts, mouse actions (1876)
siblings (defined) (1829)
sort order
- with drill-through (2723), (2729)
- with Query Designer (2295)
sorting criteria (2286)
Spreadsheet Toolkit product (1788)
spreadsheets
- applying styles (2085)
- cascading (2601)
- creating multiple (2603)
- data update log file (2579)
- described (1810)
- displaying aliases (2155), (2156)
- displaying member names (2157)
- distributing (2602)
- drilling options (1997)
- global options (1882), (1964), (2354)
- mode options (2371), (2449)
- preserving formulas (2357)
- repeating member labels (2165)
- retrieving data (1911)
- saving (2238)
- setting options (1889)
- style options (2084)
- suppressing missing and zero values (2067)
- zoom options (2002)
SQL Interface (1792)
starting
- data retrieval (1945)
- drill-through (2681)
- Hyperion Essbase (1855)
- Hyperion Essbase Spreadsheet Add-in (1852)
status of database connections (2532)
Style page (Essbase Options dialog box) (2101)
styles
- applying
  - to data cells (2124)
  - to dimension members (2115)
  - to dimensions (2120)
  - to drill-through cells (2689)
  - to linked partition cells (2548)
  - to linked reporting object cells (2488)
  - to members (2095)
  - to parent members (2092)
  - to Query Designer results (2198)
  - to shared members (2104)
- clearing (2144)
- defining (2097), (2100)
- hierarchy of (2137)
- overlapping (2135)
- removing (2139)
- selecting members (2103)
- stored in ESSBASE.INI (2122)
- turning off (2143)
- turning on (2112)
Subset dialog box (2223), (2229)
subsets
- defining members (2222)
- removing (2042), (2043)
- retaining (2023), (2024)
substitution variables (2441), (2443)
suppressing
- data retrieval (2062)
- disabled (2382)
- missing and zero values (2070), (2071)
- underscore characters (2073)
symmetric reports (2305)
system administrator (1769)
system failure (2251)

table of contents, with Cascade (2625)
TCP/IP protocol (1785)
terminating database connections (2240) See also disconnecting
termination, abnormal (2252), (2253)
text
- entering free-form (2446)
- formatting (2107)
- hierarchy of styles (2136)
- pivoting (2013) See also pivot
- preserving formatted (2330)
time periods (2427)
title members, with drill-down (1980)
to-date calculations, specifying (2432)
tracking data updates (2581)
transaction-level data, accessing with drill-through (2658)
transparent partitions (2545) See also linked partitions
transport protocol (1784)
tutorial
- basic tasks (1848)
- guidelines (1902)
- preparing for (1887)

UDA (2225) See also user-defined attributes
underscore characters, suppressing (2078)
Undo command (1959) See also FlashBack command
undoing actions (1957)
Unlock command (2574)
unlocking data blocks (2572)
up-to-date calculations (2433)
Update Mode (2571)
updating
- data (2554)
- log file (2583)
upgrading (1761)
URLs
- accessing linked (2519)
- editing (2521)
- length limits (2508)
- linking to data cells (2501)
Use Aliases option (2154)
Use Both Member Names and Aliases option (2164)
Use Sheet Options with Query Designer option (2197)
Use Styles option (2111)
User-Defined Attributes (2224)
username, entering (2270)
users (1772)

V2.x mode (2461)
VBA functions (1753)
viewing
- active connections (2533)
- aliases (2148)
- aliases and names (2159)
- data in spreadsheet (1941)
- Dynamic Calculation members (2424)
- Essbase menu (1859)
- fewer members (1988) See also drill
- linked partitions (2540)
- linked reporting objects (2509)
- more members (1968) See also drill
- multidimensional data (1813)
- online help (1863)
- repeated member labels (2168)
- spreadsheet without data (2056)
- styles (2110)
views, restoring (1953)
Visual Basic for Applications (1752) See also VBA functions
visual cues (2089), (2327) See also styles, styles

Web resources, linking to data cells (2504)
wildcard characters (2218)
Within Selected Group option (2006), (2307)
worksheets
- formatting (2079)
- navigating without data in (2059)
World Wide Web, linking to data cells (2502)

Xchgrate sample database (2639)

zero values
- suppressing (2072), (2077)
- suppressing disabled (2384)
Zoom commands, customizing (1996)
Zoom In command
- drilling down options (1971)
- selecting levels (2001)
Zoom Out command, drilling up options (1991)
Zoom page (Essbase Options dialog box) (1894), (2000)
- Enable Hybrid Analysis option (1898)

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]