Configuring AtScale
- Viewing and Updating Licenses
- Adding Data Warehouses
- Engine Level Configuration Settings
Managing AtScale
- Managing User Access and Security
  - Connecting to an LDAP Server
  - Configuring Kerberos
- Managing Git
  - About Git Integration
  - Managing Git Repositories in AtScale
- Managing AtScale APIs
  - Accessing the AtScale API
  - AtScale OpenAPI
- Managing Aggregates
  - Aggregate Data Security
  - Working With Aggregate Partitions
  - Dimensionally Modified Aggregates
  - Inbound SQL Hints to Control the Use and Generation of Aggregate Tables
  - Inbound SQL Session Parameters
- Monitoring Queries
  - Using the Queries Page
Working with Data Models
- AtScale Model Design Concepts

Connecting to AtScale From Business-Intelligence Software
- BI Tool Connection Support
- Getting Model Connection Information

Loading search results...

Working with Data ModelsCreating ModelsModeling MetricsAdd Calculated MetricsMDX ReferenceFIRSTCHILD

FirstChild

Syntax

Member_Expression.FirstChild

Input Parameters

Member_Expression: A valid Multidimensional Expressions (MDX) expression that returns a member.

Return Value

Returns the first child of an input member.

Example

Return the Sales Amount for the date dimension currentMember's first child.

([DateCustom].[Retail445].CurrentMember.FirstChild, [Measures].[Internet Sales Amount Local])