Introducing the Longview Add-In for Office
Introducing the Longview Add-In for OfficeThe Longview Add-In for Office is a fully integrated Add-In that allows you to make use of the familiar interface of Microsoft Excel in conjunction with the database used by your Longview system. You can use the Longview Add-In for Office to access Longview data servers to query data and other aspects of the data server repository and submit data to the...
Managing connections
Managing connectionsBefore you can start working with the Longview Add-In for Office, you must use the Manage Connections dialog to add a connection to the Longview data server. For more information, see the following:“Understanding authentication methods”“Adding a connection”In addition, you can use the Manage Connections dialog to complete several tasks involving data server connections, incl...
Querying data
Querying dataOnce you are connected to the Longview data server, you are ready to work with the data contained within it. This chapter explains how to use the Longview Add-In for Office to query data. For information on analyzing data queries, see “Analyzing data query results”.In this section, you can find information on the following topics:“Understanding data query output”“Querying base data...
Querying symbols
Querying symbolsYou can use the Longview Add-In for Office to query symbol data such as the balance type, weight, and priority of a specified symbol or symbols from the data server repository.In this chapter, you can find information on symbol query tasks, including the following:“Understanding symbol query output”“Querying symbol information”“Rerunning a symbol query”“Saving and loading symbol...
Querying attributes
Querying attributesYou can use the Longview Add-In for Office to query attribute data from the data server repository.In this chapter, you can find information on attribute query tasks, including the following:“Understanding attribute query output”“Querying attribute information”“Rerunning an attribute query”“Saving and loading attribute query selections”Understanding attribute query outputAn a...
Extracting data
Extracting dataYou can use the Longview Add-In for Office to extract data from the data server repository and output it to a Microsoft Excel spreadsheet. Output data appears as a flat table where each data value is represented as a row and each dimension is represented as an intersecting column. This output format can be conveniently used in a Microsoft Excel Table or a PivotTable, which can fu...
Analyzing data query results
Analyzing data query resultsYou can further investigate the results of a data query by reorienting them or drilling into them multiple times in succession. In addition, you can revert to previous reorientations and data drills.In this chapter, you can find information on data query results analysis tasks, including the following:“Reorienting data query results”“Drilling into data query results”...
Formatting query results
Formatting query resultsWhen you run a data, symbol, or attribute query using the Longview Add-In for Office, default Longview formatting is applied to the query results. You can make changes to the query results in the Microsoft Excel workbook. However, depending on the type of change that you make, you may invalidate the query. If a query is invalidated, it cannot be rerun. In the case of dat...
Longview Function Syntax
Longview Function SyntaxWhen you are working with Longview Functions, keep the following general syntax rule in mind. For each function parameter, you can either specify the required value, or specify a cell location that contains the required value. If you specify a value, enclose the parameter in double quotation marks ("Parameter"). If you specify a cell location, do not enclose the paramete...
Working with data using Longview Functions
Working with data using Longview FunctionsThe Longview Add-In for Office includes Longview Functions that allow you to query different types of data into worksheet cells and submit data from worksheet cells to the Longview data server repository. In this chapter, you can find information on the following topics:“Using Longview Functions”“Using multiple Longview Functions in a single cell”“Refre...
Working with Longview Add-In for Office APIs
Working with Longview Add-In for Office APIsAutomation APIs are available in the Longview Add-In for Office for automating common operations such as refreshes and submissions and orchestrating those processes across many sheets in a workbook. You can use VBA to call these Automation APIs.Caution: The Longview Add-In for Office APIs are supported for Longview connections only. APIs are not supp...
Getting Started with Automation APIs
Getting Started with Automation APIsBefore you can use the Automation APIs in your workbooks, you will need to ensure that the Longview Excel Add-In Reference is added to your VBA Project. Note: The library name may appear as Longview or Longview Excel Add-InOnce in VBA, you may use the Object Browser to browse the objects in the API.
API Class
API ClassThe API class is the main class used to implement the Automation APIs. This section describes the Functions and Properties of the API class.API.ConnectThe API.Connect function connects to the Longview data server with specified parameters.ParametersDescriptionconnectionType: string or Type: connectionThis parameter is the name of a defined Connection or a Connection object.userType: st...
Connection Class
Connection Class The Connection class represents the connection parameters used to connect to the Longview server. Use the Connection class in conjunction with API.Connect to create a connection to the Longview system.Connection PropertiesThe following table lists the properties of the Connection class:NameTypeDescriptionHostOrProxystringHostOrProxy specifies the host name or proxy of the data ...
DataExtract Class
DataExtract ClassThe DataExtract class represents a data extract query that is built from the menu option: Data Extract. The functions and properties of this class can be used to build a new data extract query, modify an existing data extract query and output the results to a worksheet.Property SummaryProperty AdjustedDetail As AdjustedDetailProperty DataMode As DataModeProperty Schedule As Str...
DataQuery Class
DataQuery ClassThe DataQuery class represents a data query that is built from the menu option: Data Query. The functions and properties of this class can be used to build a new data query, modify an existing data query and output the results to a worksheet.Note: A symbol spec must be added for every base dimension.Property SummaryProperty AdjustedDetail As AdjustedDetailProperty ApplyFormatting...
ErrorCode Class
ErrorCode ClassThe ErrorCode class represents a set of common return values. Use the ErrorCode class to create relevant error messages for common errors that may be encountered.ErrorCode Return ValuesThe following table lists some of the common return values for the ErrorCode class:NameTypeDescriptionAlreadyConnectedlongReturn value to indicate that the user is already connected.ConnectServerFa...
HierarchyQuery Class
HierarchyQuery ClassThe HierarchyQuery class represents a hierarchy of symbols in a dimension that can be used in memory or output to a worksheet.Property SummaryProperty IncludeDescriptions As BooleanSub/Function SummarySub AddSymbolSpec(symbolSpec As String, [root As String])Function Run() As QueryResultSub RunToWorksheet([worksheetName As String], [cell As String])PropertiesParameterDescript...
Query Result Class
Query Result ClassThe QueryResult class contains the results to a HierarchyQuery. The results are structured as a table where each row represents a symbol entry, and the columns represent the properties for that symbol.Property SummaryProperty ColumnCount As LongProperty RowCount As LongSub/Function SummaryFunction GetCellValue(row As Long, column as Long) As StringPropertiesParameterDescript...
Session Class
Session ClassThe Session class represents various aspects of a session such as the user id, host, port, and identifier of the currently connected Longview system.Use the Session class in conjunction with API.GetSession to retrieve information for the current session.Session PropertiesThe following table lists the properties of the Session classNameTypeDescriptionGroupstringGroup is the Longview...
Symbol Class
Symbol ClassThe Symbol class contains the results to API.SymbolInfo. Property SummaryProperty AcceptRollup As BooleanProperty BalanceType As StringProperty Children As Symbol()Property ChildSort As StringProperty Description As StringProperty Index As LongProperty IsLeaf As BooleanProperty Level As LongProperty Name As StringProperty NumOfChildren As LongProperty Parent As SymbolProperty Priori...
SymbolQuery Class
SymbolQuery ClassThe SymbolQuery class represents a symbol query that is built from the menu option: Symbol Query. The functions and properties of this class can be used to build a new symbol query, modify an existing symbol query and output the results to a worksheet.Property SummaryProperty SymbolOutput As SymbolOutputSub/Function SummarySub AddSymbolSpec(symbolSpec As String, [root As String...