| Oracle® Smart View for Office開発者ガイド E88265-01 |
|
 前 |
 次 |
表2-3 VBA関数 - アルファベット順のリスト
| VBA関数 | 適用可能なデータ・ソース |
|---|---|
| AnalysisProperties | Oracle Business Intelligence Enterprise Edition |
| CopyView | Oracle BI EE |
| CreateJournal | Oracle Hyperion Financial Management、およびFinancial ManagementのOracle Journals拡張機能 |
| DeleteView | Oracle BI EE |
| DirProperties | Oracle BI EE |
| EditPagePrompts | Oracle BI EE |
| EditPrompts | Oracle BI EE |
| GetPagePrompts | Oracle BI EE |
| HypAddLRO | Oracle Essbase |
| HypCalculate | Financial Management |
| HypCalculateContribution | Financial Management (アド・ホックのみ) |
| HypCell | Essbase、Oracle Hyperion Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypConnect | Essbase、Planning、Financial Management |
| HypConnected | Essbase、Planning、Financial Management |
| HypConnectionExists | Essbase、Planning、Financial Management |
| HypConsolidate | Financial Management (アド・ホックのみ) |
| HypConsolidateAll | Financial Management (アド・ホックのみ) |
| HypConsolidateAllWithData | Financial Management (アド・ホックのみ) |
| HypCreateConnection | Essbase、Planning、Financial Management、Oracle Hyperion Reporting and Analysis |
| HypCreateConnectionEx | Essbase、Planning、Financial Management、Reporting and Analysis |
| HypCopyMetaData | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypDeleteAllLROs | Essbase |
| HypDeleteAllMRUItems | すべて |
| HypDeleteCalc | Essbase |
| HypDeleteLROs | Essbase |
| HypDeleteMetaData | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management、Reporting and Analysis |
| HypDisconnect | Essbase、Planning、Financial Management |
| HypDisconnectAll | Essbase、Planning、Financial Management |
| HypDisconnectEx | Essbase、Planning、Financial Management |
| HypDisplayToLinkView | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypExecuteCalcScript | Essbase |
| HypExecuteCalcScriptEx | Essbase、Planning、Oracle Planning and Budgeting Cloud |
| HypExecuteCalcScriptString | Essbase |
| HypExecuteMenu | すべて |
| HypExecuteDrillThroughReport | Essbase |
| HypExecuteMDXEx | Essbase |
| HypExecuteQuery | Essbase |
| HypFindMember | Essbase |
| HypFindMemberEx | Essbase |
| HypForceCalculate | Financial Management |
| HypForceCalculateContribution | Financial Management (アド・ホックのみ) |
| HypForceTranslate | Financial Management (アド・ホックのみ) |
| HypFreeDataPoint | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetActiveMember | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetAncestor | Essbase |
| HypGetBackgroundPOV | Essbase、Planning、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management |
| HypGetCalcScript | Essbase |
| HypGetCellRangeForMbrCombination | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetChildren | Essbase |
| HypGetColCount | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetColItems | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetConnectionInfo | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetDatabaseNote | Essbase |
| HypGetDataPoint | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetDimensions | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetDimMbrsForDataCell | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetDrillThroughReports | Essbase |
| HypGetGlobalOption | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetLastError | すべて |
| HypGetLinkMacro | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetMemberInformation | Essbase |
| HypGetMemberInformationEx | Essbase |
| HypGetMembers | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetNameRangeList | Essbase |
| HypGetOption | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetPagePOVChoices | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetParent | Essbase |
| HypGetPOVCount | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetPOVItems | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetRowCount | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetRowItems | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetSharedConnectionsURL | Essbase、Planning、Financial Management |
| HypGetSheetInfo | すべて |
| HypGetSheetOption | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypGetSourceGrid | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypGetSubstitutionVariable | Essbase |
| HypGetVersion | すべて |
| HypHideRibbonMenu | すべて |
| HypHideRibbonMenuReset | すべて |
| HypInvalidateSSO | Essbase、Planning、Financial Management |
| HypIsAncestor | Essbase |
| HypIsAttribute | Essbase |
| HypIsCellWritable | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypIsChild | Essbase |
| HypIsConnectedToSharedConnections | Essbase、Planning、Financial Management |
| HypIsDataModified | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypIsDescendant | Essbase |
| HypIsExpense | Essbase |
| HypIsFreeForm | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypIsParent | Essbase |
| HypIsSmartViewContentPresent | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypIsUDA | Essbase |
| HypKeepOnly | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypListApplications | Essbase、Financial Management、Planning |
| HypListCalcScripts | Essbase |
| HypListCalcScriptsEx | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypListDatabases | Essbase、Planning |
| HypListLROs | Essbase |
| HypMenuVAbout | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVAdjust | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVBusinessRules | Planning、Oracle Planning and Budgeting Cloud |
| HypMenuVCalculation | Essbase、Financial Management (アド・ホックのみ) |
| HypMenuVCascadeNewWorkbook | Essbase、Planning、Oracle Planning and Budgeting Cloud |
| HypMenuVCascadeSameWorkbook | Essbase、Planning、Oracle Planning and Budgeting Cloud |
| HypMenuVCellText | Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVCollapse | Planning (フォームのみ)、Oracle Planning and Budgeting Cloud (フォームのみ) |
| HypMenuVConnect | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVCopyDataPoints | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVExpand | Planning (フォームのみ)、Oracle Planning and Budgeting Cloud (フォームのみ) |
| HypMenuVFunctionBuilder | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVInstruction | Planning (フォームのみ)、Oracle Planning and Budgeting Cloud (フォームのみ)、Financial Management (フォームのみ) |
| HypMenuVKeepOnly | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVLRO | Essbase |
| HypMenuVMemberInformation | Essbase |
| HypMenuVMemberSelection | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVMigrate | Financial Management |
| HypMenuVOptions | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVPasteDataPoints | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVPivot | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVPOVManager | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVQueryDesigner | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVRedo | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVRefresh | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVRefreshAll | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVRefreshOfflineDefinition | Planning、Oracle Planning and Budgeting Cloud |
| HypMenuVRemoveOnly | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVRulesOnForm | Planning (フォームのみ)、Oracle Planning and Budgeting Cloud (フォームのみ) |
| HypMenuVRunReport | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVSelectForm | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVShowHelpHtml | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVSubmitData | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypMenuVSupportingDetails | Planning、Oracle Planning and Budgeting Cloud |
| HypMenuVSyncBack | Planning、Oracle Planning and Budgeting Cloud |
| HypMenuVTakeOffline | Planning、Oracle Planning and Budgeting Cloud |
| HypMenuVUndo | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVVisualizeinExcel | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVZoomIn | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypMenuVZoomOut | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypModifyConnection | Essbase、Planning、Financial Management |
| HypModifyRangeGridName | Essbase |
| HypOpenForm | Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypOtlGetMemberInfo | Essbase |
| HypPerformAdhocOnForm | Planning、Oracle Planning and Budgeting Cloud |
| HypPivot | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypPivotToGrid | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypPivotToPOV | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypPreserveFormatting | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypQueryMembers | Essbase |
| HypRedo | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypRemoveConnection | Essbase、Planning、Financial Management |
| HypRemoveOnly | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypRemovePreservedFormats | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypResetFriendlyName | Essbase、Planning、Financial Management |
| HypRetrieve | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypRetrieveAllWorkbooks | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypRetrieveLRO | Essbase |
| HypRetrieveNameRange | Essbase |
| HypRetrieveRange | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypSetActiveConnection | Essbase、Planning、Financial Management |
| HypSetActiveMember | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSetAliasTable | Essbase、Planning、Oracle Planning and Budgeting Cloud |
| HypSetAsDefault | Essbase、Planning、Financial Management |
| HypSetBackgroundPOV | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSetCellsDirty | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSetColItems | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypSetConnAliasTable | Essbase、Planning |
| HypSetConnectionInfo | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypSetDimensions | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypSetGlobalOption | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSetLinkMacro | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypSetMembers | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSetMenu | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSetOption | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSetPages | Planning (フォームのみ)、Oracle Planning and Budgeting Cloud (フォームのみ)、Financial Management (フォームのみ) |
| HypSetPOV | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypSetPOVItems | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypSetRowItems | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypSetSharedConnectionsURL | Essbase、Planning、Financial Management |
| HypSetSheetOption | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSetSSO | シングル・サインオン(SSO)をサポートするすべてのプロバイダ |
| HypSetSubstitutionVariable | Essbase |
| HypShowPanel | すべて |
| HypShowPov | すべて |
| HypSubmitData | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management |
| HypSubmitSelectedDataCells | Essbase |
| HypSubmitSelectedRangeWithoutRefresh | Essbase |
| HypTranslate | Financial Management (アド・ホックのみ) |
| HypUIConnect | Essbase、Planning、Oracle Planning and Budgeting Cloud、Financial Management、Oracle BI EE |
| HypUndo | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypUpdateLRO | Essbase |
| HypUseLinkMacro | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypZoomIn | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| HypZoomOut | Essbase、Planning (アド・ホックのみ)、Oracle Planning and Budgeting Cloud (アド・ホックのみ)、Financial Management (アド・ホックのみ) |
| InsertView | Oracle BI EE |
| InvokeMenu | Oracle BI EE |
| ListJournals | Financial Management、およびFinancial ManagementのOracle Journals拡張機能 |
| ListTemplates | Financial Management、およびFinancial ManagementのOracle Journals拡張機能 |
| OpenJournal | Financial Management、およびFinancial ManagementのOracle Journals拡張機能 |
| PasteView | Oracle BI EE |
| PerformAction | Financial Management、およびFinancial ManagementのOracle Journals拡張機能 |
| SaveJournal | Financial Management、およびFinancial ManagementのOracle Journals拡張機能 |
| SetJournalProperty | Financial Management、およびFinancial ManagementのOracle Journals拡張機能 |
| ValidateJournal | Financial Management、およびFinancial ManagementのOracle Journals拡張機能 |
