OLAP Spreadsheet Add-in User's Guide for 1-2-3

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

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