### 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 > ``` ```html <%=CurrentDate()%> ``` ```html <%=$CurrentUser:Users.Id%> ``` ```html <%=$CurrentUser:Users.FullName%> ``` ```html <%=IF(IsNumeric(SRM Debits and Credits),Currency({SRM Debits and Credits},#,###),$0)%> ```