• Home
  • Visit Our Website
  • Home
  • Visit Our Website
Visit Our Website

Users

144
  • Getting Started
    • The Assette Navigation Bar
    • The Assette Home Page
    • How to Log into Assette
    • Glossary
  • Authoring Center
    • Smart Docs
      • How to Create a Smart Doc
      • Smart Doc Troubleshooting
      • Tracking Changes with Life Events
      • Copying and Restoring from Version History
      • Smart Docs
      • Smart Docs X-Ray View
      • Troubleshooting
        • Troubleshooting Smart Docs
    • Smart Pages
      • Creating & Editing Smart Pages
      • Tracking Changes with Life Events
      • Copying and Restoring from Version History
      • How to Insert Blank Columns and Rows
      • Changing a Smart Page’s Size
      • Compliance Tags
      • Deleting Smart Pages
      • Supported PowerPoint Charts
      • Smart Page Content Classifications
      • Smart Pages
      • How to Unlock a Smart Page
      • Smart Page X-Ray View
      • Assette Editors
        • PowerPoint Editor
          • How to Insert Images Using the Assette Ribbon
          • How to Add New Series to a Chart
          • Assette Ribbon
            • The “Un-Fabricate” Button
          • Troubleshooting
            • How to Check Your Microsoft PowerPoint Version
            • Installing the Assette PowerPoint Editor
          • Advanced Settings
            • Zigzag Tab
            • Margin Tab
            • General Tab
            • Advanced Settings Overview
    • Fixed Content
      • Fixed Content
    • Data Docs
      • Data Docs
    • Smart Shells
      • How to Preview Smart Shells
      • Coupled Shells
      • Tracking Changes with Life Events
      • Creating an “As of Date” Smart Shell
      • Copying and Restoring from Version History
      • Performance History Chart
      • Deleting Smart Shells
      • Smart Shell Content Classifications
      • Creating Smart Shells via Assette’s PowerPoint Editor
      • Editing Smart Shells Using the Smart Shell Library
      • Renaming Smart Shells
      • Smart Shells X-Ray View
      • How to Refresh Smart Shells
      • Creating Smart Shells Using the Smart Shell Library
      • Smart Shells Frequently Asked Questions (FAQ)
      • Smart Shells
    • Brand Themes
      • Assette Dynamic Brand Theme Setup
      • Brand Themes
      • Managing Multiple Themes Within a Single Brand Theme
      • Dynamic Brand Themes
      • Master Slide Layouts for Dynamic Brand Themes
      • Changing a Smart Page’s Size
      • Creating a Brand Theme
      • Shell Styling
    • Email Templates
      • Using Variables in Assette Email Templates
      • Email Templates
    • Additional Features
      • Automatic Extension Correction
      • X-Ray View Overview
      • The Generation Screen
  • Content Hub
    • Library
      • Saved Trays in the Assette Library
      • Content Generation and Sharing with Content Library
      • Content Library
    • My Workspace
      • Copying Content to My Workspace
      • My Workspace
    • Workrooms
      • How to Edit Content in a Workroom
      • Copying Content to a Workroom
      • Workroom
    • Assette Viewer
      • Disabling or Removing the Assette Outlook Add-in
      • Assette Viewer Basics
      • Assette Viewer Overview
    • Content Center
      • How to Add a New Organization to the Organization Master
      • Content Plan Data Model
      • Content Plans
      • Content Types
      • Using Advanced Search in the Content Library
  • Data Engine
    • Input Center
      • Input Center Overview
      • External Content Overview
      • Recipients
      • Data Files Overview
    • Qualitative Data
      • Ownership Data
      • Firm Overview
      • People Data
      • Master Questionnaire
      • Qualitative Data
    • Developer Center
      • Developer Tools Overview
  • Analytics
    • Component Analytics
    • Content Sharing Analytics
  • Administration
    • Creating & Editing Work Groups
    • Workbox
      • Workbox Basics
    • Content Type Master
      • Content Filename Aliases
    • Users
      • Work Group Basics
      • Internal Users
        • SSO Internal User Roles & Tasks
        • Internal User Roles & Responsibilities
        • Reset or Unlock User’s Accounts
        • Manually Creating Users in Assette
      • Work Groups
        • Creating Subgroups
        • Creating & Editing Work Groups
    • Workflows
      • Workflows Basics
      • Workflow Frequently Asked Questions (FAQ)
      • Workflow Management
        • Workflow Management Overview
        • Workflow Reassignment
      • Workflow Design
        • Creating Conditional Workflows
        • Editing or Deleting a Workflow
        • Creating a Workflow
    • Product Master
      • Deactivating & Deleting Products
      • Product Master Overview
      • Troubleshooting Product Master Errors
    • Classification Master
      • Data Ingredients Overview
      • Labels
      • Compliance Tags
      • Limitations
      • How to Manage Content Classifications
      • Classification Master Overview
      • Creating & Managing Labels
  • Client Portal
    • Security Overview for the Assette Client Portal
    • Creating Notifications for Client Portal Users
    • Client Portal Overview
    • Client Portal Users
      • Client Portal Frequently Asked Questions (FAQ)
      • Client Portal Session Handling
      • Log into the Assette Client Portal
      • Deleting a Client Portal User
      • Creating a New Portal User
      • Managing User Access in the Client Portal
      • Monitoring and Accessing User Login Activity for Client Portal
      • Editing or Creating Portal Users
  • Tutorials
    • When to Create a New Artefact in Assette
    • Creating a Fixed-Row Zigzag Table
  • Legacy Support
    • Data Validations [Legacy]
    • Assette Roles Overview [Legacy]
    • Internal Users Management [Legacy]
    • Create & Manage Attributes [Legacy]
    • Assette Centers [Legacy]
    • Legacy Authoring Center
      • Data Object Library [Legacy]
      • Data Docs [Legacy]
      • Smart Shells [Legacy]
      • How to Create a New Smart Page [Legacy]
      • Legacy Smart Pages
        • Creating and Editing Smart Pages [Legacy]
      • Legacy Smart Docs
        • Creating a Smart Doc [Legacy]

Developers

195
  • Getting Started
    • The Assette Navigation Bar
    • User Login & Creation
      • Permission Groups Overview
      • How to Create & Assign Permission Groups
      • Add Assette Users with Azure AD
      • Developer Roles & Permissions
    • Implementation Overview
      • Connecting to Source Systems with Assette
      • Fields Synchronized with Assette
      • Essential Data Blocks
      • Introduction to Assette Implementation
      • The Assette Implementation Approach
      • What Data is Required to Start?
  • Developer Tools
    • Tool Setup
      • Prohibited Data Block Keywords and Built-ins
      • Master Data Scheduler
      • Python Data Block Libraries & Keywords
      • Developer Center Configurations
      • Assette Development Stack
      • Troubleshooting
        • Troubleshooting AxiosError: 500
        • Assette VS Code Extension Troubleshooting
      • Visual Studio Code
        • Assette Visual Studio Code Extension
        • How to Find Where a Component is Used in the VS Code Extension
        • Error and Status Messages Reference
        • Signing Into the Assette VS Code Extension
        • VS Code Frequently Asked Questions (FAQs)
        • Assette VS Code Extension Troubleshooting
        • Installing the Assette Block Editor VS Code Extension
    • Data Block Editor
      • Using Nested Functions in Data Blocks
      • Importing Python Libraries
      • Import & Export Data Blocks
      • Data Block Unit Testing in Python
      • Data Block Editor Basics
        • Calculation Operators and Precedence
        • How to Freeze Data Blocks
        • Creating & Editing Data Blocks
        • How to Copy & Delete Data Blocks
        • Secret Management
        • Introduction to the Data Block Editor
      • Data Block Editor Metadata
        • How to Update Data Block Metadata
      • Data Block Editor Troubleshooting
        • Troubleshooting API Authentication Issues
    • Data Object Editor
      • Applying Row Filtration with Data Objects
      • Locking a Data Object
      • Force Unlocking a Data Object
      • Dynamic Row Numbering
      • Introduction to the Data Object Editor
      • Data Object KeyError
      • Editing Data Objects
      • Creating Data Objects
      • How to Copy & Delete Data Objects
      • Generation Time Data Settings
      • Importing & Exporting Data Objects
      • Design View
        • Data Settings Tab
          • Data Settings Tab
        • General Info Tab
          • Styling Classes
          • General Info
        • Data Source Tab
          • Data Source Tab
        • Columns Tab
          • Date Formats
          • Columns Tab
        • Groupings Tab
          • Creating Group Summary Rows
          • Creating Group Header Rows
          • Group Expressions & Group Ordering
          • How to Create “Group By” Data Settings
          • Grouping Tab
        • Sorting Tab
          • Sorting Tab
        • Summary Tab
          • Summary Tab
        • Row Types Tab
          • Row Types Tab
        • Title & Footnotes Tab
          • Title & Footnotes Tab
        • Legend Tab
          • Legend Tab
        • Output Variables Tab
          • Output Variable Tab
        • No Data Message Tab
          • No Data Message Tab
      • Expressions
        • The “round(value, n)” Expression
        • The “Contains()” Function
        • The “HasValue()” Function
        • The “NOT” Operator
        • The “OR” Operator
        • The “<> Not Equal To” Operator
        • The “>= Greater Than or Equal To” Operator
        • The < Less Than Operator
        • The “<= Less Than or Equal to” Operator
        • The > Greater Than Operator
        • The “==” Equals Operator
        • The Grouping Operator “()”
        • The “Divide” Expression
        • The “Multiply” Expression
        • The “Minus” Expression
        • The “ADD” Expression
        • The “AND” Expression
        • Expressions, Operators, & Functions
    • Dynamic Fields
      • Dynamic Fields
    • Footnote Editor
      • Footnote X-Ray View
      • Import Variables & Columns
      • How to Create & Edit Footnotes
      • Footnote Editor Overview
    • Tenant Manager
      • Deployment Statuses
      • Deployment Processing & Error Logging
      • Review Artifacts
      • Tenant Manager Troubleshooting
      • Deploy Content Using the Assette Tenant Manager
      • Tenant Manager Overview
      • Tenants in the Tenant Manager
  • Data Blocks
    • Data Block Basics
      • Data Block Request Parameters
      • Data Block Categories
      • Data Block Basics
    • Account Master
      • Filtering the Account Master Using Account Codes
      • Account Master Data Block
    • Data Blocks by Category
      • Understanding Assette Data Blocks
      • System Data Blocks
        • Organization Add Data Block
        • Organization Master Data Block
        • Get Recipient Info Salesforce Transform Data Block
        • Get Recipient Info Salesforce Data Blocks
        • Get Recipients LocalDB Data Block
        • Get Recipient Info Local Data Block
        • Recipient Master Data Block
        • Attribute Type Values Local Data Block
        • Brand Theme Selector Data Block
        • Brand Theme Extract Data Block
        • Asset Classes Local Data Block
        • Sub Accounts Client Database Data Block
        • Sub Accounts Local Database Data Block
        • Sector Schemes Data Blocks
        • Sectors Data Block
        • Currency Codes Data Blocks
        • Countries Data Block
        • Sub Accounts Data Block
        • As of Dates Data Block
        • Account Master Data Block
        • Product Master Data Block
        • System Data Blocks Overview
      • Sync Data Blocks
        • Country List Sync Data Block
        • Product Master Sync Data Block
        • Sync Data Block Overview
        • Attribute Type Values Sync Data Block
      • Source Data Blocks
        • Source Product Offer Countries Data Block
        • Source Sub-Accounts Relationship Data Block
        • Source List of Attribute Type Values Data Block
        • Source Product Master Extract Data Block
        • Source List of Currency Codes Data Block
        • Source Account Attributes Values Data Block
        • Source Extract Accounts Details Data Block
      • Transform Data Blocks
        • Assette Get Valid Periods Data Block
        • System Period Information Data Block
        • Assette Get Begin & End Date Data Block
        • Source Extract Accounts Details Data Block
      • Interface Data Blocks
        • Organization Read Local Data Block
        • Sectors Local Database Data Block
        • Assette Period Code Map Data Block
        • Account Attribute Mapping Local Database Data Block
        • Account Attributes Local Database Data Block
        • Source Product Master Extract Data Block
        • Source List of Currency Codes Data Block
        • Source Account Attributes Values Data Block
        • Product Master Local Data Base Data Block
      • Configuration Data Blocks
        • Salesforce Settings Data Block
        • Calculation Python Environment Data Block
        • Python Data Calculation Modules Data Block
        • Python Environment for Date Calculation Data Block
        • Demo Snowflake Setting Data Block
        • Snowflake Demo Certificate Data Block
        • Calculation Environment Data Block
        • Configuration Data Block Overview
    • Data Blocks by Functionality
      • Get Major Minor Ticker Data Block
  • Data Objects
    • Data Objects
    • Data Object X-Ray View
    • Introduction to Data Objects
  • Integrations
    • Connecting Salesforce with Assette
    • Snowflake
      • Source Account Attributes Values Data Block
      • Snowflake Integration
    • Aprimo
      • Modifying the Aprimo API Records Data Block
      • Inserting Content with Aprimo
      • Aprimo Image Library Data Block
      • Assette-Aprimo Integration Overview
      • Aprimo Thumbnail Image Library API Data Block
      • Aprimo Data Blocks
        • Aprimo API Post Order Data Block
        • Aprimo API Order Status
        • Image Content Data Block
        • Aprimo API Single Record Data Block
        • Aprimo Image Thumbnail Data Block
        • Aprimo API Records Data Block
  • Developer FAQ
    • How to Add a New Product to the Product Master
    • How to Add New Attributes to the Attribute Master
    • TLS Email Encryption via SendGrid
    • Data Block Cheat Sheet
    • Data Object Frequently Asked Questions (FAQ)
    • Tenant Manager Frequently Asked Questions (FAQ)
    • Why Can’t I Edit a Data Object?
    • Data Blocks Frequently Asked Questions (FAQ)
    • Period Codes
    • How Do I Log into Snowflake?
    • How Do Unit Tests Work in Assette?
    • Enable Assette Add-In in Case of Failure
    • Developer Tools FAQs
      • How to Display Different Values in the Account Code Dropdown in the Data Object Editor Preview
      • When and Why You See an Impact Change Message in the Developer Center
  • Tutorials
    • Creating a Correlation Matrix Table
    • Data Block Tutorials
      • Structuring Data for Time-Series Charts in PowerPoint
      • How to Cache Data Using Data Blocks
      • Creating a Certificate Data Block
      • Making Public API Calls Using Assette Data Blocks
      • Using Data Blocks to Make API Calls
    • Data Object Tutorials
      • Creating Dynamic Column Headings
  • Home
  • Docs
  • Developers
  • Developer FAQ
  • Data Block Cheat Sheet

Data Block Cheat Sheet

13 min read

Data Block NameArticleDescriptionBlock CategoryBlock TypeData CategoryOutput TypeEditable
AccountAttributeMappingLocalDBhttps://learn.assette.com/docs/accountattributemappinglocaldb/The Account Attribute Mapping Local Database (AccountAttributeMappingLocalDB) Data Block is used map account attributes to Assette. This Data Block should not be edited.InterfaceLOCAL DATABASENoneVALUESFALSE
AccountMasterhttps://learn.assette.com/docs/account-master-data-block/The Account Master (AccountMaster) Data Block is an Assette System Data Block which houses account attribute data such as asset class, share class, whether the account is open or not, etc. The Account Master (AccountMaster) Data Block is a System Data Block and is not usually edited by end users, though the dependency GetAccountMetaDataForSystemBlock Data Block is expected to be edited.InterfaceNONENoneData TableTRUE
Aprimo_api_order_statushttps://learn.assette.com/docs/aprimo-api-order-status/The Aprimo API Order Status Data Block is used to make a GET request to the Aprimo API. The Data Block fetches information about a specific order by appending the order ID ({{id}}) to the path. InterfaceAPI CALLNoneData TableTRUE
Aprimo_api_post_orderhttps://learn.assette.com/docs/aprimo-api-post-order-data-block/The Aprimo API Post Order Data Block is an API forwarder and describes how to sends a request to an the Aprimo API and creates a request to download the latest version of a file without sending any notifications. The Aprimo API Post Order Data Block is not edited.InterfaceAPI CALLNoneData TableTRUE
Aprimo_api_recordshttps://learn.assette.com/docs/aprimo-api-records-data-block/The Aprimo API Records Data Block functions as an API key forwarder for the Assette-Aprimo integration. This block is set up by Assette after the client has provided a valid public API key from Aprimo. This Data Block is not edited.InterfaceAPI CALLNoneData TableTRUE
Aprimo_api_single_recordhttps://learn.assette.com/docs/aprimo-api-single-record-data-block/The Aprimo API Single Record (Aprimo_api_single_record) Data Block gets the thumbnail URL parameter for a single thumbnail.InterfaceAPI CALLNoneData TableTRUE
AsofDateshttps://learn.assette.com/docs/as-of-dates-system-data-block/The As of Date (AsofDates) Data Block is an Assette System Data Block that will return the previous 24 month ends, if a client wants to derive the As of Dates from an external data source, they will need to make the necessary changes to the Data Block, otherwise no changes to the As of Date (AsofDates) System Data Block or any dependencies.TransformPYTHONNoneData TableTRUE
AssetClassesLocalhttps://learn.assette.com/docs/asset-classes-local-data-block/The AssetClasses (AssetClasses) Data Block retrieves all data from the AssetClasses table without applying any filters. It fetches all columns and rows from the table and returns the results in a structured format. This Data Block cannot be edited.InterfaceLOCAL DATABASENoneData TableFALSE
AssetClassSynchttps://learn.assette.com/docs/asset-class-sync/Retrieves all asset class code and value pairs from Source List of Attribute Type Values Data Block (Source_ListofAttributeTypeValues) and returns the value as Data Table. This Data Block is not normally edited by end users. To update the available asset classes, see Source List of Attribute Type Values Data Block instead.TransformPYTHONNoneData TableTRUE
ast_fn_GetBeginEndDateshttps://learn.assette.com/docs/assette-period-date-calculation-data-block/The Assette Period Date Calculation (ast_fn_GetBeginEndDates) Data Block is a Demo Data Block which processes different period codes, such as MTD, QTD, YTD, etc., and calculates the appropriate begin_date and end_date for each code. It reads the period universe data and uses various date patterns and logic to determine the start and end dates for a given period code. After calculating the dates, the Assette Period Date Calculation (ast_fn_GetBeginEndDates) Data Block formats them and returns the result. As an open-source demo Data Block, this Data Block may be edited as needed.TransformPYTHONNoneData TableTRUE
ast_fn_GetValidPeriodshttps://learn.assette.com/docs/assette-get-valid-periods-data-block/The Assette Get Valid Periods (ast_fn_GetValidPeriods) Data Block processes a list of periods (e.g., MTD, QTD, YTD, etc.) based on parameters such as the reference date (AsofDate), fiscal year-end, and inception date. It retrieves the begin_date and end_date for each period and allows for optional filtering of not-applicable and duplicate periods. The  Assette Get Valid Periods (ast_fn_GetValidPeriods) Data Block then organizes and returns the calculated date ranges in a structured format. This Data Block is open-source and may be edited as desired.TransformPYTHON ENVIRONMENTNoneData TableTRUE
ast_period_code_maphttps://learn.assette.com/docs/assette-period-code-map-data-block/The Assette Period Code Map (ast_period_code_map) Data Block maps period codes (e.g., “QTD” for “Quarter to Date”) to their display name. These codes represent different time periods or financial reporting intervals such as months, quarters, years, and fiscal years. Some of the codes are for cumulative or annualized data over different periods, like the past 1, 5, or 10 years, while others are for specific quarters or fiscal years.InterfaceCONSTANTNoneVALUESTRUE
AttributeTypesLocalhttps://learn.assette.com/docs/attribute-types-local-data-block/The Attribute Types Local (AttributeTypesLocal) Data Block is used to get the list of asset classes from Assette. This Data Block cannot be edite.InterfaceLOCAL DATABASENoneData TableFALSE
AttributeTypeValuesSynchttps://learn.assette.com/docs/attribute-type-values-sync-data-block/The Attribute Type Values Sync (AttributeTypeValuesSync) Data Block aggregates the list of distinct strategies and vehicles and synchronizes them with Assette. The following information outlines the minimum quorum of data required for the basic functionality of Assette.

TransformPYTHONNoneData TableTRUE
Calculation_Python_Envhttps://learn.assette.com/docs/calculation-python-environment-data-block/The Imports (Imports) Data Block defines the required Python libraries to be imported for the script. Each library is imported with or without an alias, depending on its usage within the code. This Data Block ensures that the necessary libraries are available for handling data manipulation, date operations, JSON parsing, and other tasks. This Data Block is not edited.

ConfigurationPYTHON ENVIRONMENTNoneSETTINGSTRUE
CalculationEnvhttps://learn.assette.com/docs/calculation-env-data-block/Used to import Python modules and libraries (e.g., “import numpy as np”)PYTHON ENVIRONMENT, PYTHONNoneNoneFALSE
Countrieshttps://learn.assette.com/docs/countries-data-block/The Countries Data Block surfaces the country codes and names. By default, this list is retrieved from Assette’s internal database. If a client desires to maintain their own countries list, the Data Block CountriesLocaldb must be modified.TransformPYTHONNoneData TableFALSE
CountryListSynchttps://learn.assette.com/docs/country-list-sync-data-block/The Country List Sync Data Block is used to synchronize the list of available countries and insert into Assette’s database. The Country List Sync Data Block is not normally edited by end users. To update the available countries, see Source_CountryList Data Block instead.TransformPYTHONNoneData TableTRUE
CurrencyCodeshttps://learn.assette.com/docs/currency-codes-data-blocks/The Currency Codes (CurrencyCodes) Data Block retrieves the values for all currency codes including the ID, Symbol, description, isDeleted, and short code from the Source List of Currency Codes Data Block— a Constant Data Block. The The Currency Codes (CurrencyCodes) Data Block is not normally edited by end user, to update Currency Code, see Source List of Currency Codes Data Block instead.

TransformPYTHONNoneData TableFALSE
DEMO_SnowFlakeSettingBlockhttps://learn.assette.com/docs/demo-snowflake-setting-data-block/The Demo Snowflake Setting (DEMO_SnowFlakeSettingBlock) Data Block is used to facilitate access the Assette Demo Snowflake Data Warehouse by providing value for ‘user’, ‘account’, ‘warehouse’, etc. This Data Block must be edited or removed as dictated by the client’s data needs.ConfigurationSETTINGSNoneVALUESTRUE
DemoCertificatehttps://learn.assette.com/docs/snowflake-demo-certificate-data-block/The Snowflake Demo Certificate Data Block is a constant Data Block which contains the private key for the Snowflake Tutorial. It is expected that this Data Block either be changed or removed to conform to the needs of the specific implementation.ConfigurationNONENoneSETTINGSTRUE
ImageContenthttps://learn.assette.com/docs/image-content-data-block/The Image Content Data Block is used to retrieve the image from Aprimo API. Once the image is ready and available, the Data Block downloads the image and captures its content and format. If successful, the image data and its type are returned as a response. This Data Block is not edited. InterfacePYTHONNoneBINARYTRUE
ImageLibraryhttps://learn.assette.com/docs/image-library-data-block/The Aprimo Image Library Data Block is used to list of images according to given filter parameters within the Assette application.TransformPYTHONNoneData TableTRUE
ImageLibrary_Api_Thumbnail_Aprimohttps://learn.assette.com/docs/aprimo-thumbnail-image-library-api-data-block/The Aprimo Image Library API Data Block passes the URL which was received from the Aprimo API Order Status Data Block and sets the action to “Download”. InterfaceAPI CALLNoneBINARYTRUE
ImageThumbnailhttps://learn.assette.com/docs/aprimo-image-thumbnail-data-block/The Aprimo Image Thumbnail Data Block is used to retrieve a thumbnail image from Aprimo. This Data Block should not be edited.TransformPYTHONNoneBINARYTRUE
ProductMasterhttps://learn.assette.com/docs/product-master-system-data-block/The ProductMaster Data Block pulls product-related information from a database based on user-provided filters like ID, strategy, or country. It then refines the data using additional filters, if provided. After retrieving the product details, the function ensures all necessary fields are included, and if some data fields are missing (like country), it tries to fill in the gaps by looking up related information. Lastly, it checks the product’s country data and filters out any products that don’t match the given country filter, if one is provided.
InterfacePYTHONNoneData TableTRUE
ProductMasterLocalDBhttps://learn.assette.com/docs/product-master-local-data-base-data-block/InterfaceLOCAL DATABASENoneVALUESFALSE
PythonDataCalculationModuleshttps://learn.assette.com/docs/python-data-calculation-modules-data-block/The Python Data Calculation Modules (PythonDataCalculationModules) Data Block defines a set of Python libraries to be imported into a script. It includes common libraries like pandas, numpy, json, datetime, and calendar, each with their respective aliases. The Python Data Calculation Modules (PythonDataCalculationModules) Data Block ensures these libraries are available for use in the script under their specified aliases. This Data Block is not edited. If additional Python libraries or modules need to be imported create a new Data Block instead.ConfigurationPYTHON ENVIRONMENTNoneNoneTRUE
PythonEnvForDateCalculationhttps://learn.assette.com/docs/python-environment-for-date-calculation-data-block/The Python Environment for Date Calculation Data Block is used to import Python libraries and modules for date calculations. This Data Block should not be edited.ConfigurationPYTHON ENVIRONMENTNoneVALUESTRUE
Sectorshttps://learn.assette.com/docs/sectors-data-block/The Sectors Data Block retrieves sector-related data from Assette. The Data Block accepts optional input parameters AsOfDate, UseSectorMapTable, Category, and Language, with default values set if not provided. The Sectors Data Block is not edited.TransformPYTHONNoneData TableFALSE
SectorSchemeshttps://learn.assette.com/docs/sector-schemes-data-blocks/The Sector Schemes (SectorSchemes) Data Block retrieves sector scheme data from the local database. It checks if any data is available, and if so, it processes each row by extracting the Key and Value for each sector scheme. The Sector Schemes (SectorSchemes) Data Block then organizes this information into a list and sends it back as the response. This Data Block is not edited.InterfacePYTHONNoneData TableTRUE
Source_AccountAttributesValueshttps://learn.assette.com/docs/source-account-attributes-values-data-block/The Source Account Attributes Values Data Block is used to interface with a client’s data source (e.g., Snowflake) and must be edited by the end user during implementation.InterfaceSNOWFLAKE DATABASE CALLNoneData TableTRUE
Source_ExtractAccountsDetailshttps://learn.assette.com/docs/extract-accounts-details-interface-data-block/Source Extract Accounts Details is a Transform Data Block used to extract data related to the account master from client’s source data (e.g., Snowflake). This Data Block is expected to be edited by the client and therefore the name and output is subject to change.InterfaceSNOWFLAKE DATABASE CALLNoneData TableTRUE
Source_ListofAttributeTypeValueshttps://learn.assette.com/docs/source-list-of-attribute-type-values-data-block/In this block, Assette compile the list of distinct strategies and vehicles and insert them into Assette local database. The dependency block (e.g.: Source_ListofAttributeTypeValues) which referring client data source data should be populated with all strategies , Vehicles and AssetClass list along with associated attribute type values.InterfaceLOCAL DATABASENoneVALUESTRUE
Source_ProductMasterExtracthttps://learn.assette.com/docs/source-product-master-extract-data-block/The Source Product Master Extract (Source_ProductMasterExtract) Data Block retrieves data related to the Product Master from a client’s data source (e.g., Snowflake). The Source Product Master Extract Data Block has been configured to retrieve data from Assette’s Demo Snowflake instance. The Source Product Master Extract Data Block must be updated and edited to retrieve data from the client’s data source. It is important to note that changing the Output Type (Data Type) will break this Data Block.

InterfaceSNOWFLAKE DATABASE CALLNoneData TableTRUE
Source_SubAccountsRelationshiphttps://learn.assette.com/docs/source-sub-accounts-relationship-data-block/The Source Sub-Accounts Relationship Data Block (Source_SubAccountsRelationship) Data Block retrieves portfolio group associations from the DEMO_DB database. It returns the MEMBERPORTFOLIOCODE as Code and the PortfolioCode as GroupAccountCode based on a specified AccountCode. The Source Sub-Accounts Relationship Data Block (Source_SubAccountsRelationship) Data Block filters the data using the provided AccountCode and returns the associated portfolio details. This Data Block is expected to be edited.InterfaceSNOWFLAKE DATABASE CALLNoneData TableTRUE
Strategieshttps://learn.assette.com/docs/strategies-data-block/The Strategies Data Block retrieves a list of strategies from Assette. It checks if any data is returned, and if so, it processes each row by extracting the Key, whether the strategy is active (IsActive), and the Value. The Strategies (Strategies) Data Block then organizes this information into a list and sends it back as the response. This Data Block is not edited.InterfacePYTHONNoneData TableFALSE
SubAccountshttps://learn.assette.com/docs/subaccounts-system-data-block/The SubAccounts (SubAccounts) Data Block retrieves subaccount information from Assette or client database, based on the specified interface method (Local or BYOD). This Data Block is not edited.TransformPYTHONNoneData TableTRUE
SubAccountsClientDBhttps://learn.assette.com/docs/sub-accounts-client-database-data-block/The Sub Accounts Client Database (SubAccountsClientDB) Data Block retrieves subaccount data along with associated attributes like strategy and vehicle from Assette’s Demo Snowflake instance. It first fetches subaccount relationships, then merges them with account details and attribute values to generate a comprehensive view of each subaccount. The Sub Accounts Client Database (SubAccountsClientDB) Data Block processes the data, fills in missing fields, and organizes the output by adding strategy and vehicle details for each subaccount. Finally, it returns the structured subaccount information in the response. This Data Block is expected to be edited in order to retrieve data from the client’s source.TransformPYTHONNoneData TableTRUE
SubAccountsLocalDBhttps://learn.assette.com/docs/subaccounts-system-data-block/The Sub Accounts Local Database (SubAccountsLocalDB) Data Block retrieves subaccount information from Assette. This Data Block is not edited.InterfaceLOCAL DATABASENoneVALUESFALSE
sys_period_informationhttps://learn.assette.com/docs/system-period-information-data-block/The System Period Information (sys_period_information) Data Block defines a set of periods using period codes and their respective details, such as the display name, number of years, months, and quarters for each period. Each period is categorized based on its duration, such as month-to-date, quarter-to-date, year-to-date, prior years, or prior quarters. This Data Block is used to manage the calculation and display of time periods for various financial or reporting purposes. This Data Block is open-source and may be edited as needed.TransformCONSTANTNoneData TableTRUE
VehiclesLocaldbhttps://learn.assette.com/docs/vehicles-local-database-data-block/The Vehicles Local Database (VehiclesLocalDB) Data Block retrieves a list of vehicles from Assette by selecting vehicle-related attribute values. It joins the AttributeTypeValues and AttributeTypes tables to filter out attributes where the name is ‘Vehicle’. The Vehicles Local Database (VehiclesLocalDB) Data Block returns this data as a structured list of key-value pairs. This Data Block is not edited.InterfaceLOCAL DATABASENoneVALUESTRUE
TLS Email Encryption via SendGridWhy Can’t I Edit a Data Object?
Still stuck? How can we help?

How can we help?

Updated on November 12, 2024
  • Platform
  • Modules
  • AssetteAI
  • Who We Are
  • Who We Work With
  • Platform
  • Modules
  • AssetteAI
  • Who We Are
  • Who We Work With
  • Platform
  • Modules
  • AssetteAI
  • Who We Are
  • Who We Work With
  • Platform
  • Modules
  • AssetteAI
  • Who We Are
  • Who We Work With
  • Blog
  • News
  • Events
  • Contact
  • Blog
  • News
  • Events
  • Contact
  • Blog
  • News
  • Events
  • Contact
  • Blog
  • News
  • Events
  • Contact
X-twitter Linkedin Youtube

4 Faneuil Hall, 4th Floor
Boston, MA
02109 USA
Tel: +1.617.723.6161

Book a Demo
  • Privacy Policy
  • © 2025 Assette. All Rights Reserved
  • Powered By Artrivo (PVT) Ltd.