OLAP 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
  • attributes, drill down (2199)
  • creating queries (2397)
  • filtering data (2503)
  • Options dialog box (2109), (2898)
  • Query Designer
  • data sorting panel (2518)
  • filtering data (2505)
  • sorting data (2517)
  • reports, creating
  • ad hoc (2153)
  • retaining
  • formulas (2549)
  • spreadsheets
  • displaying member names (2375)
  • styles
  • overlapping (2351)
  • zero values
  • suppressing (2288)
  • #Missing strings, suppressing (2290)
  • #NoAccess strings, suppressing (2291)
  • * wildcard character (2438)
  • ? wildcard character (2439)
    • A
  • access
  • to linked partitions (2763)
  • using Essbase commands (2118)
  • to databases (2132), (2483)
  • to Essbase data (2133), (2484)
  • to linked reporting objects (2736)
  • to multiple databases (2753)
  • to online help (2078)
  • with Hyperion Integration Server Drill-Through (2915)
  • Acrobat Reader (1934) See also Adobe Acrobat Reader
  • ad hoc reports (1948), (2151), (2571), (2868)
  • Add button (2967)
  • add database wizard (3010)
  • Add-in Manager (2036)
  • adding members (2422) See also members, adding
  • adjusting columns (2119), (2559) See also columns, adjusting width, columns, adjusting width
  • administrators (1953)
  • Adobe Acrobat Reader (1935)
  • advanced interpretation engine (2678)
  • Advanced Interpretation mode (2677), (2693)
  • aliases
  • definition of (2369)
  • displaying
  • process of (2371)
  • with member names (2381)
  • with Query Designer results (2418)
  • in tables (2370)
  • alternate dimensions (1993) See also dimensions, alternate
  • alternate names (2367) See also aliases
  • ancestors, definition of (2019)
  • AND operators (2429)
  • API (1980)
  • application designer (1954)
  • application partitions (2767) See also linked partitions
  • application programming interface (1981)
  • applications/databases
  • Sample Basic (2035), (2121), (2144), (2494)
  • sample for Hyperion Integration Server Drill-Through (2905)
  • Sample Interntl (2858)
  • Sample Xchgrate (2859)
  • ascending sort order
  • with Hyperion Integration Server Drill-Through (2958)
  • with Query Designer (2519), (2523)
  • asymmetric reports
  • definition of (2530)
  • pivoting (2535)
  • retrieving data into (2528)
  • Attach Linked Object dialog box (2708), (2720), (2732)
  • attaching reporting objects to cells (2703) See also linking
  • attaching to databases (2129) See also connecting
  • auditing updates (2801)
  • auto logouts (2476)
  • Auto Sort Rows option (2688)
    • B
  • back up database wizard (3012)
  • blank
  • columns (2544)
  • rows (2541)
  • blocks, locking data (2789)
  • books (2982), (2995)
  • Boolean operators (2425), (2445)
    • C
  • Calculation command (2812)
  • Calculation dialog box (2814)
  • calculations
  • database status (2818)
  • databases (2642), (2810)
  • dynamic (2637)
  • reducing calculation time (2638)
  • scripts (2815)
  • specifying latest time period (2659)
  • substitution variables (2667)
  • with Dynamic Time Series (2662)
  • with EssCell (2633)
  • canceling data retrievals (2165)
  • Cascade command (2824)
  • Cascade Information page (2833)
  • Cascade Options dialog box (2830)
  • cascading sheets
  • creating table of contents (2849)
  • destination (2837)
  • format (2846)
  • level of detail (2834)
  • names (2844)
  • output type (2838)
  • cell notes
  • accessing linked (2741)
  • linking to cells (2718)
  • cell ranges
  • keeping (2245)
  • removing (2265)
  • retrieving (2620)
  • selecting nonadjacent (2256)
  • with Hyperion Integration Server Drill-Through (2922)
  • cells
  • accessing linked partitions (2766)
  • applying styles (2304), (2339)
  • attaching reports (2699) See also linking
  • attaching URLs (2721) See also linking
  • EssCell function in (2624)
  • formatting (2306), (2344), (2710)
  • in data cells (2343)
  • of dimension members (2335)
  • of Dynamic Calculation members (2647)
  • of parent members (2314)
  • formulas in (2548), (2566), (2585), (2625)
  • linked reporting objects (2701), (2723)
  • linking files to (2702)
  • linking notes to (2715)
  • linking URLs to (2724)
  • retrieving a range (2621)
  • retrieving single values (2623)
  • selecting nonadjacent (2257)
  • with nondatabase values (2545)
  • Change Password dialog box (2148)
  • changing
  • passwords (2147)
  • row and column orientation (2232)
  • spreadsheet format (2298)
  • styles (2303)
  • children (defined) (2013)
  • Clear All button (2976)
  • Clear button (2975)
  • Clear command (2177)
  • clearing styles (2356)
  • click (defined) (2089)
  • client
  • components (1961)
  • software (2033)
  • upgrading with server (1942)
  • client-server environment (1959)
  • collapsing data views (2203) See also drill
  • colors, setting (2302)
  • columns
  • filtering by (2512)
  • adjusting width (2120), (2558)
  • blank (2543)
  • displaying as rows (2225)
  • displaying selected (2248)
  • keeping selected (2250)
  • nested (2190)
  • pivoting (2231)
  • removing selected (2268)
  • retrieving into (2194)
  • columns, Hyperion Integration Server Drill-Through
  • choosing (2945)
  • selecting display order (2946), (2951)
  • selecting for retrieval from relational source (2943)
  • sorting (2960)
  • sorting multiple columns (2963)
  • commands
  • Calculation (2813)
  • Cascade (2825)
  • Clear (2178)
  • Connect (2136), (2486), (2754)
  • Currency Report (2856), (2872)
  • Disconnect (2464)
  • FlashBack (2170)
  • Keep Only (2247)
  • Linked Objects (2706), (2730)
  • Lock (2793)
  • Member Selection (2430)
  • Navigate Without Data (2277), (2282)
  • new in release 6 (1947)
  • Pivot (2227)
  • Remove Only (2267)
  • Retrieve (2164)
  • Retrieve & Lock (2791)
  • Send (2795)
  • Undo (2175)
  • Unlock (2800)
  • Zoom In (2186)
  • Zoom Out (2206), (2210)
  • comparison operators (2426), (2514)
  • computing environment (1927)
  • concurrent
  • database access (2141), (2750)
  • updates to server (2785)
  • conditional retrievals (2506)
  • configure multisite update wizard (3014)
  • Connect button (2065)
  • Connect command (2135), (2485), (2755)
  • connecting (2128) See also disconnecting
  • to a database (2131), (2482)
  • to a relational data source (2881), (2914), (2925)
  • to Essbase (2139), (2489)
  • to Hyperion Integration Server (2913), (2926)
  • to multiple databases (2751)
  • viewing current connections (2760)
  • Connection Information text box (2761), (2816)
  • consolidations (defined) (2027)
  • conversions, currency (2852)
  • create database wizard (3016)
  • create table space wizard (3020)
  • create table wizard (3018)
  • creating reports (2152) See also reports, creating
  • Currency Conversion product (1984)
  • currency conversions
  • modifying exchange rates (2874)
  • reporting (2869)
  • sample databases (2866)
  • settings (2875)
  • Currency Report command (2855), (2871)
  • Currency Report dialog box (2873)
  • current time period (2660) See also Dynamic Time Series
  • cursors (Essbase) (2157)
  • custom applications (1983), (1988)
  • Customize button (2940)
  • customizing Hyperion Integration Server Drill-Through reports (2889), (2937)
    • D
  • data
  • calculating (2809)
  • changing orientation (2223)
  • comparison operators (2513)
  • displaying (1997), (2162)
  • dynamically calculating (2641)
  • filtering (2508)
  • filtering, with Hyperion Integration Server Drill-Through (2973)
  • formatting (2296)
  • locking (2787)
  • missing (2292)
  • modifying (2784)
  • navigating (2032), (2271)
  • pivoting (2228)
  • relational, with Hyperion Integration Server Drill-Through (2878)
  • removing subsets (2260)
  • retaining subsets (2241)
  • retrieving (2125) See also retrieving
  • sorting (2509)
  • unlocking (2798)
  • updating (2783), (2802)
  • data sort order, with Hyperion Integration Server Drill-Through (2956)
  • data source, relational (2927)
  • databases
  • calculating (2811) See also calculations
  • connecting (2752) See also connecting
  • consolidations (2026)
  • defined (1991)
  • dimensions (2004)
  • disconnecting from (2465)
  • linked (2769) See also linked partitions
  • loading (2145), (2495)
  • locking (2786)
  • members (2008)
  • organization (2001)
  • outlines (2031)
  • queries (2391) See also queries
  • restoring previous views (2169)
  • rules (2002)
  • sample (2124), (2860), (2907)
  • selecting (2493) See also connecting
  • switching (2756)
  • viewing connections (2759)
  • DB2 library
  • books (2981)
  • Information Center (3003)
  • language identifier for books (2986)
  • late-breaking information (2988)
  • online help (2996)
  • ordering printed books (2994)
  • printing PDF books (2991)
  • searching online information (3029)
  • setting up document server (3027)
  • structure of (2980)
  • viewing online information (2998)
  • wizards (3006)
  • deleting
  • filters, Hyperion Integration Server Drill-Through (2977)
  • selected members (2263)
  • styles (2354)
  • descendants (defined) (2017)
  • descending sort order
  • with Hyperion Integration Server Drill-Through (2959)
  • with Query Designer (2521), (2525)
  • Destination Options page (2840)
  • destinations
  • cascaded sheets (2839)
  • Query Designer queries (2409)
  • detaching (2458) See also disconnecting
  • dialog boxes, Help buttons (2082)
  • dimensions
  • alternate (1992)
  • applying styles (2337)
  • currency conversion and (2862)
  • described (1994), (2003)
  • drilling down on (2185), (2198)
  • drilling up on (2211)
  • naming elements (2005)
  • pivoting (2234)
  • disabling data retrieval (2273) See also navigating without data
  • Disconnect
  • command (2463)
  • dialog box (2468)
  • disconnecting
  • forced logouts (2475)
  • from Essbase (2466)
  • from Hyperion Integration Server (2979)
  • discontinuous rows and columns (2253)
  • disk space, effect on Dynamic Calculation (2644)
  • display
  • options (2297)
  • order of columns, Hyperion Integration Server Drill-Through (2947)
  • Display page (Essbase Options dialog box) (2111), (2900)
  • Display Unknown Member option (2568), (2579)
  • displaying data (1998), (2161)
  • distributed sheets (2822) See also cascading sheets
  • double-clicking
  • defined (2090)
  • enabling
  • for drilling (2104)
  • for linked object browsing (2738), (2776), (2923)
  • downloading Acrobat Reader (1933)
  • drag, defined (2092)
  • drag-and-drop operations (2237)
  • drill
  • down on attributes (2201)
  • by double-clicking (2099)
  • down on attributes (2200)
  • down on consolidations (2030)
  • Formula Fill (2590)
  • retain formulas during (2589)
  • to less detail (2205)
  • Drill-Through Wizard
  • described (2888)
  • dialog box (2941)
  • introductory screen (2942)
  • Drill-Through, Hyperion Integration Server
  • Drill-Through Wizard (2890)
  • tutorial guidelines (2895)
  • Drill-Through, Hyperion Integration Server
  • installing (2894)
  • accessing (2886), (2916)
  • cells, defining styles for (2918)
  • described (2880), (2882)
  • multiple reports (2885)
  • requirements (2892)
  • sample
  • database (2904)
  • Drill-Through report (2908)
  • file (2920), (2921)
  • styles for cells (2887)
  • tasks (2910)
  • using (2909)
  • duplicating sheets (2821) See also cascading sheets
  • Dynamic Calculation members, applying styles to (2648), (2651)
  • Dynamic Time Series
  • defined (2655)
  • specifying latest time period (2664), (2665)
    • E
  • Edit Cell Note dialog box (2743)
  • Edit menu (2176)
  • Edit URL dialog box (2748)
  • editing
  • cell notes (2742)
  • linked files (2740)
  • URLs (2745), (2747)
  • editing in cells (2098)
  • enabling
  • Essbase toolbar (2055)
  • FlashBack setting (2181)
  • mouse actions (2094), (2737), (2775)
  • Navigate Without Data (2279)
  • environment (computing) (1925)
  • Essbase
  • Cascade Options dialog box (2829)
  • Disconnect dialog box (2467)
  • Member Selection dialog box, from Query Designer (2401)
  • Options dialog box (2497)
  • System Login dialog box (2487)
  • API (1979)
  • architecture (1957)
  • computing environment (1926)
  • connecting to (2134) See also connecting
  • disconnecting from. See disconnecting (2462)
  • Member Selection dialog box (2433), (2451)
  • menu (2050)
  • new features (1946)
  • Options dialog box (2108), (2897)
  • starting a session (2046)
  • System Login dialog box (2137)
  • toolbar
  • described (2062)
  • installing (2060)
  • upgrades (1939)
  • EssCell function (2629)
  • error messages (2636)
  • syntax (2630)
  • Excel
  • Add-in Manager, installing Essbase menu (2041)
  • clearing formats (2179), (2359)
  • manually adding Spreadsheet Add-in (2038)
  • mouse actions (2095)
  • sample tutorial files (2477)
  • status bar (2052)
  • Excel Spreadsheet Add-in (2037) See also Hyperion Essbase Spreadsheet Add-in
  • exchange rates (2861)
  • Execute button (2939)
  • executing Hyperion Integration Server Drill-Through reports (2931), (2935)
  • expanding data views (2183) See also drill down
  • expanding formulas when drilling (2613)
  • external files (2696)
    • F
  • features, Spreadsheet Add-in (1945)
  • files
  • accessing linked (2739)
  • destinations
  • cascaded sheets (2842)
  • Query Designer queries (2410)
  • linking to data cells (2705)
  • sample for tutorial (1937), (2479)
  • filters
  • operators (2969)
  • with Hyperion Integration Server Drill-Through (2974)
  • Find Member dialog box (2440)
  • finding members (2421), (2435)
  • FlashBack button (2073)
  • FlashBack command (2171)
  • font
  • formats (2322)
  • style list (2325)
  • Font dialog box (2324)
  • forced logouts (2474)
  • formatted sheets
  • pivoting in (2569)
  • retrieving data into (2539)
  • formatting
  • data cells
  • linked objects (2709), (2772)
  • read-only (2341)
  • read/write (2342)
  • dimension members (2333)
  • displaying aliases (2365)
  • displaying aliases and names (2376)
  • Dynamic Calculation members (2650)
  • enabling styles (2329)
  • linked object cells (2712), (2771)
  • options for cascaded sheets (2845)
  • parent members (2309)
  • repeating member labels (2385)
  • spreadsheets (2299)
  • text and cell styles (2349)
  • Formula Fill option (2605), (2615)
  • Formula Preservation mode
  • Formula Fill (2583)
  • pivoting in (2576)
  • restrictions with (2574), (2599)
  • Retain on Keep and Remove Only (2582)
  • Retain on Retrieval (2562), (2580)
  • formulas
  • EssCell (2628)
  • expanding when drilling (2612)
  • in cells (2550), (2598)
  • preservation
  • effects on other operations (2597)
  • enabling (2561), (2584)
  • restrictions with (2575)
  • free-form reporting
  • entering generation and level names in (2690)
  • in Advanced Interpretation mode (2676)
  • in Free-Form mode (2680)
  • retrieving data (2670)
  • Free-Form retrieval mode (2681)
  • guidelines (2687)
  • functions (2084) See also macro functions
    • G
  • generations
  • defined (2021)
  • entering names in spreadsheet (2695)
  • Global page (Essbase Options dialog box) (2102)
    • H
  • Help buttons (2081)
  • Help, accessing (2077)
  • HTML
  • sample programs (2985)
  • Hyperion Essbase
  • intended audience (1951)
  • migration information (1938)
  • products of (1972)
  • Hyperion Essbase Spreadsheet Add-in
  • accessing Hyperion Integration Server Drill-Through from (2917)
  • installing toolbar (2061)
  • installing, manually adding (2039)
  • logging data updates (2807)
  • retrieval cursors (2159)
  • starting (2043)
  • users, described (1956)
  • Hyperion Integration Server (1987), (2877)
  • Hyperion Integration Server Drill-Through (2879) See also Drill-Through, Hyperion Integration Server
    • I
  • in-cell editing (2097)
  • index wizard (3022)
  • Information Center (3004)
  • installation
  • Hyperion Integration Server Drill-Through (2893)
  • manually adding Spreadsheet Add-in (2040)
  • toolbar (2057)
  • installing
  • Netscape browser (3001)
  • Integration Server Drill-Through (1985) See also Drill-Through, Hyperion Integration Server
  • Internet, linking cells to URLs (2728)
  • Interntl sample database (2863)
    • K
  • Keep Only button (2068)
  • Keep Only command
  • described (2246)
  • in Formula Preservation mode (2591)
    • L
  • labels
  • applying styles (2334)
  • displaying with aliases (2380)
  • entering in spreadsheet (2672), (2682)
  • member names (2546) See also member names
  • repeating (2388)
  • LAN (1923) See also networks
  • language identifier
  • books (2987)
  • late-breaking information (2989)
  • Latest Time Period option (2663)
  • latest time period, specifying (2654)
  • levels
  • cascading by (2835)
  • defined (2023)
  • drilling down (2214)
  • drilling in (2220)
  • entering names (2694)
  • linked objects
  • partitions (2348) See also linked partitions
  • reporting objects (2347) See also linked reporting objects
  • Linked Objects Browser dialog box (2749), (2777), (2924)
  • LROs (2698)
  • Linked Objects command (2707), (2719), (2731)
  • linked partitions
  • access privileges (2778)
  • accessing from spreadsheet (2768)
  • cells, applying styles (2774)
  • Linked Reporting Objects
  • accessing from spreadsheet (2735)
  • applying styles (2711)
  • cell notes (2716)
  • creating (2697)
  • external files (2704)
  • URLs (2725)
  • linking
  • cell notes (2714)
  • external files (2700)
  • partitions (2762)
  • URLs to data cells (2722)
  • list, cascaded sheets (2851)
  • local area network (1924) See also networks
  • Lock command (2792)
  • locking data blocks, with multiple users (2788)
  • logging
  • off of Essbase (2460) See also disconnecting
  • on to a relational data source (2929)
  • on to Essbase (2130) See also connecting
  • on to Hyperion Integration Server (2930)
  • logging data updates from spreadsheet (2805)
  • logical operators (2447)
  • logouts, forced or auto (2473)
  • Lotus 1-2-3
  • clearing formats (2360)
  • mouse actions (2096)
  • sample tutorial files (2478)
  • status bar (2053)
    • M
  • macro functions
  • EssCell (2627)
  • Spreadsheet Toolkit (1930), (1974), (2083)
  • main menu (Essbase) (2048)
  • manual calculation mode (2634)
  • Member Information dialog box (2434)
  • member names
  • aliases for (2364)
  • alternate (2363) See also aliases
  • applying styles (2315)
  • displaying with aliases (2379)
  • entering in spreadsheet (2673), (2683)
  • formatted sheets (2547)
  • indenting (2028)
  • repeating (2389)
  • with EssCell function (2632)
  • Member Preview dialog box (2449), (2450)
  • Member Retention option (2221)
  • Member Selection button (2075)
  • Member Selection command (2431)
  • Member Selection dialog box (2432)
  • Member Selection Preview dialog box (2405)
  • Member Selection, with Query Designer (2402)
  • members
  • adding (2403)
  • aliases for (2368)
  • ancestors (2018)
  • applying styles (2307), (2330), (2332)
  • children (2012)
  • collapsing (2208)
  • defined (2007)
  • deleting (2261)
  • descendants (2016)
  • deselecting (2452)
  • drilling down on (2191), (2197)
  • drilling up on (2209)
  • Dynamic Calculation (2640)
  • Dynamic Time Series (2656)
  • finding (2420), (2436)
  • generations (2020)
  • levels (2022)
  • names (2029) See also member names
  • parents (2010)
  • retaining (2243)
  • selecting (2404), (2424)
  • siblings (2014)
  • menu, Essbase (2049)
  • messages (Essbase)
  • database calculation status (2819)
  • display options (2577)
  • EssCell (2635)
  • unknown member (2567)
  • migrating to release 6 (1941)
  • missing values
  • suppressing (2285)
  • suppressing disabled (2607)
  • missing values, suppressing
  • in cascaded sheets (2848)
  • unavailable (2610)
  • Mode page (Essbase Options dialog box) (2115), (2501), (2600)
  • money (2853) See also currency conversions
  • mouse actions, enabling (2085)
  • Move Down button (2953)
  • Move Up button (2952)
  • moving
  • through worksheets (2270)
  • rows and columns (2233) See also pivot
  • multidimensional databases (1995) See also databases
  • multiple filter conditions, with Hyperion Integration Server Drill-Through (2972)
    • N
  • Named Pipes protocol (1969)
  • names
  • alternate (2024) See also aliases
  • applying styles (2310)
  • displaying with aliases (2378)
  • entering generation (2691)
  • entering level (2692)
  • repeating (2387)
  • Navigate With or Without Data button (2066)
  • Navigate Without Data command (2274), (2281)
  • nested columns or rows (2188)
  • Netscape browser
  • installing (3002)
  • networks (1966), (1968)
  • Next Level option (2219), (2836)
  • nonadjacent cells (2252)
  • notes, linking to data cells (2717)
  • null values (2631)
  • numeric values, preserving (2553)
    • O
  • Objects product (1989)
  • ODBC clients (1978)
  • OLAP
  • defined (1949)
  • server (1962) See also server
  • online analytical processing (1950)
  • online help (2997)
  • displaying for spreadsheet (2079)
  • online information
  • searching (3031)
  • viewing (3000)
  • opening
  • Essbase (2045)
  • operating systems (1965)
  • operators, comparison (2427), (2515)
  • options
  • Cascade (2831)
  • Display (2110), (2498), (2899)
  • Global (2103), (2116), (2502), (2903)
  • Mode (2114), (2500), (2601), (2902)
  • settings for advanced tutorial (2496)
  • settings for basic tutorial (2106)
  • settings for Drill-Through tutorial (2896)
  • Style (2318)
  • Zoom (2113), (2215), (2499), (2901)
  • Options button (2074)
  • OR operators (2428)
  • Order By button (2964)
  • Order By dialog box (2965)
  • ordering
  • columns, Hyperion Integration Server Drill-Through (2948), (2950)
  • rows, Hyperion Integration Server Drill-Through (2954)
  • outlines
  • consolidations (2025)
  • described (2000)
  • dimensions (2006)
  • Dynamic Calculation members (2643)
  • Dynamic Time Series members (2661)
  • members (2009)
  • output, cascaded sheets (2832)
  • overlapping styles (2350)
    • P
  • parent members
  • applying styles to (2312)
  • defined (2011)
  • Partitioning product (1975) See also linked partitions
  • partitions (1976) See also linked partitions
  • passwords
  • changing (2149)
  • entering (2492)
  • pattern matching (2446)
  • PDF (2992)
  • performance configuration wizard (3024)
  • pivot
  • asymmetric reports and (2534)
  • by dragging (2238)
  • described (2091), (2235)
  • effect on text (2557)
  • formatted sheets and (2570)
  • formula preservation and (2573)
  • rows or columns (2230), (2536)
  • unavailable (2556)
  • without retrieving data (2280)
  • Pivot command (2226)
  • power loss (2469)
  • preferences (2101) See also options
  • preserving formulas (2563), (2616)
  • primary mouse button (2086)
  • printer destination, cascaded sheets (2843)
  • printing PDF books (2993)
  • programming interface (1982)
    • Q
  • queries
  • applying styles (2411)
  • creating (2398)
  • defining (2392)
  • deleting (2412)
  • retrieving (2393)
  • saving (2406)
  • Query Designer
  • applying option settings (2415)
  • connecting to multiple databases (2414)
  • creating queries (2399)
  • data filtering panel (2510)
  • hint panel (2395)
  • layout panel (2400)
  • messages (2522)
  • messages and confirmations (2413)
  • navigation panel (2394)
  • properties panel (2396)
  • save as query dialog box (2408)
  • Query Designer icon (2072)
    • R
  • read-only cells (2345)
  • read/write cells (2346)
  • relational data source (2928)
  • relational databases, accessing with Hyperion Integration Server Drill-Through (2884)
  • release 6 (Essbase), new features (1944)
  • release notes (2990)
  • remote databases (2764) See also linked partitions
  • Remove Only button (2069)
  • Remove Only command
  • described (2266)
  • in Formula Preservation mode (2592)
  • Remove Unselected Groups option (2611)
  • removing (2262) See also deleting
  • Repeat Member Labels option (2384)
  • report script commands (2685), (2689)
  • reports
  • ad hoc (2150), (2572)
  • ad hoc currency (2870)
  • asymmetric (2527)
  • creating multiple (2823)
  • formatted (2538)
  • free-form (2669)
  • methods of generating (1928)
  • saving (2455)
  • reports, creating
  • ad hoc (2867)
  • Cascade (2820)
  • Member Selection (2419)
  • methods (1929)
  • Query Designer (2390)
  • reports, Hyperion Integration Server Drill-Through
  • selecting to view or customize (2934)
  • reports, Hyperion Integration Server Drill-Through
  • accessing (2912)
  • customizing (2891), (2936)
  • disconnecting from (2978)
  • executing (2932)
  • restore wizard (3026)
  • restoring database views (2167)
  • restrictions, with Formula Preservation (2596)
  • Retain on Keep and Remove Only option (2603)
  • Retain on Retrieval option
  • enabled (2564)
  • disabled (2609)
  • enabled (2602)
  • Retain on Zooms option (2604), (2614)
  • retaining
  • data subsets (2242)
  • formulas (2555)
  • when drilling (2588)
  • when retaining data (2587)
  • when retrieving (2560), (2586)
  • selected members (2244)
  • Retrieve & Lock command (2790)
  • Retrieve button (2067)
  • Retrieve command (2163)
  • retrieving
  • Advanced Interpretation mode and (2679)
  • canceling (2166)
  • conditional (2504)
  • currency conversion (2854)
  • cursors (2158)
  • data (2127)
  • Dynamic Calculation members (2639)
  • formula preservation and (2593)
  • Free-Form mode and (2684)
  • functions (2626)
  • increasing speed (2358), (2533), (2622), (2646)
  • into asymmetric reports (2526)
  • into columns (2195)
  • into formatted sheets (2540)
  • rules for (2552)
  • into rows (2193)
  • less detail (2202)
  • modes (2675)
  • more detail (2182)
  • performance impact (2357), (2532), (2645)
  • range of cells (2619)
  • retaining formulas and (2565), (2594)
  • selected cells (2617)
  • starting process and (2155)
  • suppressing data and (2276)
  • reverting to previous database view (2173)
  • rows
  • blank (2542)
  • deleting during pivot (2537)
  • displaying as columns (2224)
  • displaying selected (2249)
  • filtering by (2511)
  • keeping discontinuous (2254)
  • nested (2189)
  • pivoting (2236)
  • removing selected (2269)
  • retrieving into (2192)
  • sorting within (2520), (2524)
  • suppressing values in (2284), (2847)
    • S
  • sample
  • databases
  • connecting to (2142), (2865)
  • described (1936), (2123), (2857)
  • databases, in Hyperion Integration Server Drill-Though (2906)
  • files for tutorial, location (2480)
  • Sample Basic
  • connecting to (2143)
  • described (2122)
  • Sample directory (2481)
  • sample programs
  • cross-platform (2984)
  • HTML (2983)
  • Save As command (2454)
  • Save command (2453)
  • saving
  • queries (2407)
  • worksheets (2456)
  • searching
  • online information (3005), (3030)
  • secondary mouse button (2087)
  • select (defined) (2088)
  • Select Calc Script option (2817)
  • Select Columns and Display Order dialog box (2944), (2949)
  • Select Data Filters dialog box (2966)
  • Select Data Sort Order dialog box (2957)
  • Select Drill-Through Report dialog box (2933), (2938)
  • Select Filter Values from the List dialog box (2970), (2971)
  • selecting
  • cells to keep (2251)
  • cells to remove (2264)
  • latest time period (2653)
  • members (2423)
  • nonadjacent cells (2255)
  • range of cells for retrieval (2618)
  • Send command (2794)
  • sending
  • data to server (2780)
  • log file (2803)
  • server (1960)
  • changing password (2146)
  • client-server environment (1958)
  • connecting to (2140), (2490)
  • described (1963)
  • disconnecting from (2461)
  • Essbase OLAP, described (1964)
  • Hyperion Integration Server (1986), (2876)
  • logging updates to (2782)
  • migrating to release 5, with client (1943)
  • name (2138), (2488)
  • on network (1967)
  • sending data to (2781)
  • Set Filter on Column dialog box (2968)
  • setting up document server (3028)
  • shared members, applying styles to (2321)
  • sheet destination, Cascade option (2841)
  • sheets (2154) See also worksheets
  • shortcuts, mouse actions (2093)
  • shortcuts, toolbar buttons (2063)
  • siblings (defined) (2015)
  • SmartGuides
  • wizards (3007)
  • sort order
  • with Hyperion Integration Server Drill-Through (2955)
  • sorting multiple columns (2962)
  • with Query Designer (2516)
  • with Hyperion Integration Server Drill-Through (2961)
  • sorting criteria (2507)
  • Spreadsheet Toolkit product (1973)
  • spreadsheets
  • applying styles (2301)
  • cascading (2826)
  • creating multiple (2828)
  • data update log file (2804)
  • described (1996)
  • displaying aliases (2373), (2374)
  • distributing (2827)
  • drilling options (2213)
  • global options (2100), (2180), (2578)
  • mode options (2595), (2674)
  • preserving formulas (2581)
  • repeating member labels (2383)
  • retrieving data (2126)
  • saving (2457)
  • setting options (2107)
  • style options (2300)
  • suppressing missing and zero values (2283)
  • zoom options (2218)
  • SQL Interface (1977)
  • starting
  • data retrieval (2160)
  • Hyperion Essbase (2047)
  • Hyperion Essbase Spreadsheet Add-in (2044)
  • Hyperion Integration Server Drill-Through (2911)
  • status bar, enabling and disabling (2054)
  • status of database connections (2757)
  • Style page (Essbase Options dialog box) (2317)
  • styles
  • applying
  • to data cells (2340)
  • to dimension members (2331)
  • to dimensions (2336)
  • to Hyperion Integration Server Drill-Through cells (2919)
  • to linked partition cells (2773)
  • to linked reporting object cells (2713)
  • to members (2311)
  • to parent members (2308)
  • to Query Designer results (2417)
  • to shared members (2320)
  • clearing (2362)
  • defining (2313), (2316)
  • hierarchy of (2353)
  • removing (2355)
  • selecting members (2319)
  • stored in ESSBASE.INI (2338)
  • turning off (2361)
  • turning on (2328)
  • Subset dialog box (2442), (2448)
  • subsets
  • defining members (2441)
  • removing (2258), (2259)
  • retaining (2239), (2240)
  • substitution variables (2666), (2668)
  • suppressing
  • data retrieval (2278)
  • disabled (2606)
  • missing and zero values (2286), (2287)
  • underscore characters (2289)
  • symmetric reports (2529)
  • system administrator (1952)
  • system failure (2470)
    • T
  • table of contents, with Cascade (2850)
  • TCP/IP protocol (1971)
  • terminating database connections (2459) See also disconnecting
  • termination, abnormal (2471), (2472)
  • text
  • entering free-form (2671)
  • formatting (2323)
  • hierarchy of styles (2352)
  • pivoting (2229) See also pivot
  • preserving formatted (2554)
  • time periods (2652)
  • title members, with drill-down (2196)
  • to-date calculations, specifying (2657)
  • toolbar (Essbase) (2076)
  • buttons on (2064)
  • installing (2059)
  • tracking data updates (2806)
  • transaction-level data, accessing with Hyperion Integration Server Drill-Through (2883)
  • transparent partitions (2770) See also linked partitions
  • transport protocol (1970)
  • tutorial
  • basic tasks (2034)
  • guidelines (2117)
  • preparing for (2105)
    • U
  • UDA (2444) See also user-defined attributes
  • underscore characters, suppressing (2294)
  • Undo command (2174) See also FlashBack command
  • undoing actions (2172)
  • Unlock command (2799)
  • unlocking data blocks (2797)
  • up-to-date calculations (2658)
  • Update Mode (2796)
  • updating
  • data (2779)
  • log file (2808)
  • upgrading (1940)
  • URLs
  • accessing linked (2744)
  • editing (2746)
  • length limits (2733)
  • linking to data cells (2726)
  • Use Aliases option (2372)
  • Use Both Member Names and Aliases option (2382)
  • Use Sheet Options with Query Designer option (2416)
  • Use Styles option (2327)
  • User-Defined Attributes (2443)
  • username, entering (2491)
  • users (1955)
    • V
  • V2.x mode (2686)
  • VBA functions (1932)
  • viewing
  • active connections (2758)
  • aliases (2366)
  • aliases and names (2377)
  • data in spreadsheet (2156)
  • Dynamic Calculation members (2649)
  • Essbase menu (2051)
  • Essbase toolbar (2056)
  • fewer members (2204) See also drill
  • linked partitions (2765)
  • linked reporting objects (2734)
  • more members (2184) See also drill
  • multidimensional data (1999)
  • online help (2080)
  • online information (2999)
  • repeated member labels (2386)
  • spreadsheet without data (2272)
  • styles (2326)
  • toolbar (2058)
  • views, restoring (2168)
  • Visual Basic for Applications (1931) See also VBA functions
  • visual cues (2305), (2551) See also styles, styles
    • W
  • Web Gateway product (1990)
  • Web resources, linking to data cells (2729)
  • wildcard characters (2437)
  • Windows NT Registry, changes to (2042)
  • Within Selected Group option (2222), (2531)
  • wizard
  • restore database (3025)
  • wizards
  • add database (3009)
  • back up database (3011)
  • completing tasks (3008)
  • configure multisite update (3013)
  • create database (3015)
  • create table (3017)
  • create table space (3019)
  • index (3021)
  • performance configuration (3023)
  • worksheets
  • formatting (2295)
  • navigating without data in (2275)
  • World Wide Web, linking to data cells (2727)
    • X
  • Xchgrate sample database (2864)
    • Z
  • zero values
  • suppressing (2293)
  • suppressing disabled (2608)
  • Zoom commands, customizing (2212)
  • Zoom In button (2070)
  • Zoom In command
  • drilling down options (2187)
  • selecting levels (2217)
  • Zoom Out button (2071)
  • Zoom Out command, drilling up options (2207)
  • Zoom page (Essbase Options dialog box) (2112), (2216)

    • [ Top of Page | Previous Page | Next Page ]