IBM Apptio

https://www.ibm.com/docs/en/apptio-commercial
Admin
IBM Apptio is a suite of commercial software products for technology business management, including...
Tokens:172,396
Snippets:1,301
Trust Score:10
Update:10 months ago
Show doc for...
Tokens:
Raw
### Platform API

Source: https://www.ibm.com/docs/en/apptio-commercial/tbm-studio/saas_topic=tbm-studio

This section outlines the Platform API, which allows for programmatic interaction with the Apptio platform. It includes details on API URLs for uploading tables, examples of upload operations, downloading data, and uploading/editing user data. It also references tutorials and examples for using the API with tools like Postman and curl.

```APIDOC
## APIs - Platform API

### API URL for uploading a table
Details on how to use the API to upload data tables.

### API URL upload examples
Illustrative examples of table upload requests.

### API: Downloading data
Information on how to download data from the Apptio platform using the API.

### API URL for uploading and editing user data in pre-Access Administration systems
Specifics for managing user data via the API in older administration systems.

### API tutorial: Download and upload v.12 Costing Standard table using Postman tool
A step-by-step guide using Postman for common data operations.

### How to access R12 API through Access Administration via curl
Instructions for accessing the R12 API using curl.

### Apptio API demo scripts
Sample scripts for demonstrating Apptio API capabilities.

### License for examples
Information regarding the licensing of provided API examples.
```

--------------------------------

### API Integration Examples

Source: https://www.ibm.com/docs/en/apptio-commercial/tbm-studio/saas_topic=reports-group-components-in-box

Examples demonstrating how to interact with IBM Apptio APIs for data retrieval, manipulation, and integration with other systems. These snippets typically involve HTTP requests and JSON payloads.

```JavaScript
fetch('/api/v1/data')
  .then(response => response.json())
  .then(data => console.log(data));
```

--------------------------------

### AI Cost Model Driver Logic Example

Source: https://www.ibm.com/docs/en/apptio-commercial/costing-standard/saas_topic=ai-tco-configuration-guide

Illustrates the conditional logic for calculating AI Cost based on cost source master data. It filters for AI expenditure and applies specific conditions for fixed and variable costs.

```Formula
If(Cost Source Master Data.Cost Source Model Driver IN ("OPEX – ACTUALS – FIXED", "OPEX – ACTUALS – VARIABLE"), Cost Source Master Data. AI Amount),0)
```

--------------------------------

### Link to Default Report (Go Home)

Source: https://www.ibm.com/docs/en/apptio-commercial/tbm-studio/saas_topic=reports-code-links-other

Produces a link with the text 'Go Home' that navigates to the default report of the current context. This is typically used for providing a quick way to return to a starting or main view.

```plaintext
[[/|Go Home]]
```

--------------------------------

### IBM Apptio APIs Overview

Source: https://www.ibm.com/docs/en/apptio-commercial/tbm-studio/saas_topic=reports-group-components-in-box

This section provides a general overview of the APIs available within IBM Apptio. It may include information on authentication, general usage, and common endpoints.

```APIDOC
## IBM Apptio APIs

This section outlines the available APIs for interacting with IBM Apptio. These APIs allow for programmatic access to data, reporting features, and administrative functions.

### General Information

*   **Authentication**: Details on how to authenticate API requests (e.g., API keys, OAuth).
*   **Rate Limiting**: Information on API usage limits.
*   **Versioning**: How API versions are managed and how to specify a version.

### Available API Categories

*   **Data APIs**: For acquiring, transforming, and managing data within Apptio.
*   **Reporting APIs**: For creating, accessing, and managing reports and dashboards.
*   **Administration APIs**: For managing users, roles, and system configurations.
```

--------------------------------

### Formulas and Functions

Source: https://www.ibm.com/docs/en/apptio-commercial/tbm-studio/saas_topic=tbm-studio

This section details the syntax and usage of formulas and functions within the Apptio platform, covering data lookups, column referencing, operators, string concatenation, and updated evaluation formulas. It also provides an annotated list of available functions categorized by type, with explanations and examples of their use.

```APIDOC
## Formulas and Functions

### Introduction
Provides an overview of formulas and functions in Apptio.

### Syntax
Details the syntax for constructing formulas and using functions, including:
* Data lookup
* Referencing column names
* Operators
* String concatenation
* Updated eval formulas

### Functions
An annotated list of available functions, including:
* Functions - Where used matrix
* Annotated list of functions by type
* Specific functions such as Abs, Annual, Annualize, Average, Bullet, CapFirstLetter, ColumnExists, ConvertCurrencyFromBase, ConvertCurrencyToBase, CopyTable, Currency, CurrentDate, DateFormat, DateSum, Days, DomainName, DurationOfMonth, DynamicColumn, Elapsed, Eval, EvalWiki, Find, GetGroupbyColumn, GetInfo, GetLastFilterColumn, GetLastFilterValue, GetLastPublishTime, GetNextPublishTime, GetReportName, GetReportPath, GetTimeOffset, Hours, Icon, If, IPLookup, IsNumeric, Key, Large, LargeIf, Left, Len, Lookup, Lookup_Wild, LookupContains, LookupEx, LookupFromEditable, LookupFromPath, LookupMetric, LookupObjectTotalAllocated, LookupObjectTotalValue, LookupObjectUnitAllocated, LookupObjectUnitValue, Lower, Max, Mid, Min, Minutes, Mod, Months, Now, NumberFormat, ObjectName, Percentile, Period, PeriodsInHalf, PeriodsInQuarter, PeriodsInYear, Plural, Pluralize, Power, PreviousMonth, PreviousYear, ProjectExists, ProjectName, Quarter, QuarterToDate, Rand, Ratio, Replace, ReplaceRegex, Right, Round, Row, RowCount, RowCount_EditableTable, Search, SLN, Small, SmallAcrossTime, SmallIf, Sparkline, Split, SplitEx, StatusIcon, Substitute, Sum, SumIf, SumIfHierarchy, TableInfo, TableMatch, TimePeriod, Trim, Trunc, Undrill, UniqueCount, UniqueValues, Untag, Upper, Use_Map_Grid, Use_Map_Table, Value, YearToDate.
```

--------------------------------

### HTML Text Box Examples in TBM Studio

Source: https://www.ibm.com/docs/en/apptio-commercial/tbm-studio/saas_topic=reports-html-text-box

Demonstrates various ways to use dynamic text syntax within HTML text boxes in TBM Studio. This syntax allows for the insertion of live data, formatted values, and conditional logic.

```html
<%=Cost%>
```

```html
<%=Currency(Cost)%>
```

```html
<%=NumberFormat(Table.Column,"$#,###.00")%>
```

```html
<%=Server.ServerName%>
```

```html
<%=LEFT(Servers.ServerOS,3)%>
```

```html
<a href=http://cmdb.company.com/report?server=<%=Server.ServerId%>>
```

```html
<%=CurrentDate()%>
```

```html
<%=$CurrentUser:Users.Id%>
```

```html
<%=$CurrentUser:Users.FullName%>
```

```html
<%=IF(IsNumeric(SRM Debits and Credits),Currency({SRM Debits and Credits},#,###),$0)%>
```
Tokens:
Raw