Welcome to our training materials! We're excited to have you here and hope that this training will provide you with valuable knowledge and skills. Below, you can find the complete table of contents, this will give you an overview of what topics will be covered and in what order. Be sure to check back regularly for any updates, as we make changes or additions to the training materials.

If you want to make additional adjustments it's possible to copy & paste and change the order of the elements.

With the use of the UX placeholder, you can also retrieve the alias of elements. This is done by using the syntax: $<<(Instance_Name).(Dimensions name).(Hierarchy name)-alias>>

Those variables can be used in every text field in the view definition: info tool-tips, page titles etc. as well as in MDX query.

This configuration will work for global filters as well as for dimensions selected in rows or columns.

{[Product].[$<<UX_Demo.}Hierarchies_Product.}Hierarchies_Product>>].[$<<UX_Demo.Product.$<<UX_Demo.}Hierarchies_Product.}Hierarchies_Product>>>>]}

Adding new rows works the same way. After right clicking on the row element, context menu appears and we will have the option to add row above or below selected element.

Spreading & Holds shortcut can be entered directly in the cell without using the right-click options or spreading dialog.

Every update that occurs in settings also gets codded and we can check it in the code tab, which is another place where the widget can be customized.

Name of the elements that can be drilled are marked in bold. Use breadcrumbs to navigate back to previous step on the drill path.

As the waterfall chart dynamically calculates the variance between 2 series, "Comment Row: 1" means that the chart will display comments for 1st series.

"parameters": {
      "pLogoutput": {
        "hidden": true,
        "value": 0
      },
      "pCube": {
        "label": "Cube Name",
        "type": "subnm",
        "instance": "UX_Samples",
        "dimension": "}Cubes",
        "tm1Mdx": "{ [}Cubes].[}Cubes].Members }",
        "tm1Attribute": ""
      },
      "pView": {
        "hidden": true
      },
      "pFilter": {
        "hidden": true
      },
      "pFilterParallel": {
        "hidden": true
      },
      "pParallelThreads": {
        "hidden": true,
        "value": 0
      },
      "pDimDelim": {
        "label": "Dimension Delimiter",
        "disabled": true,
        "value": "&"
      },
      "pEleStartDelim": {
        "label": "Element Start Delimiter",
        "disabled": true,
        "value": ":"
      },
      "pEleDelim": {
        "label": "Element Delimiter",
        "disabled": true,
        "value": "+"
      },
      "pSuppressZero": {
        "label": "Suppress Zero",
        "type": "checkbox",
        "trueValue": 1,
        "falseValue": 0
      },
      "pSuppressConsol": {
        "label": "Suppress consolidation",
        "type": "checkbox",
        "trueValue": 1,
        "falseValue": 0
      },
      "pSuppressRules": {
        "label": "Suppress rules",
        "type": "checkbox",
        "trueValue": 1,
        "falseValue": 0
      },
      "pZeroSource": {
        "label": "Clear Source Data",
        "type": "checkbox",
        "trueValue": 1,
        "falseValue": 0
      },
      "pCubeLogging": {
        "label": "Cube Logging",
        "type": "checkbox",
        "trueValue": 1,
        "falseValue": 0
      },
      "pTemp": {
        "label": "Use Temp Views",
        "type": "checkbox",
        "trueValue": 1,
        "falseValue": 0
      },
      "pFilePath": {
        "label": "File Path",
        "disabled": true,
        "value": "C:\\"
      },
      "pFileName": {
        "label": "File Name",
        "type": "input"
      },
      "pDelim": {
        "label": "File delimiter",
        "disabled": true,
        "value": ","
      },
      "pQuote": {
        "label": "File quote",
        "disabled": true,
        "value": "\""
      },
      "pTitleRecord": {
        "label": "Title Records",
        "disabled": true,
        "value": "1"
      },
      "pSandbox": {
        "hidden": true
      }
    },

{[Currency].[Currency].[$<<UX_Demo.Region.Region::Currency>>]}

{StrToMember("[Currency].[Currency].["+[}ElementAttributes_Region].([Region].[Region].[$<<UX_Demo.Region.Region>>], [}ElementAttributes_Region].[Currency])+"]")}

{
  Filter( 
    { TM1SubsetAll ( [Region] ) }
    , [General Ledger_C3UX].(
          [Version].[$<<UX_Demo.Version.Version>>],
          [T Year-Month].[2012],
          [Currency].[Local],
          [Region].CurrentMember,
          [Department].[Corporate],
          [Account].[$<<UX_Demo.Account.Account>>],
          [General Ledger Measure].[Amount]
        )
        > 1000000 ) 
}

UX Placeholders ($<<Insatnce.Dimension.Hierarchy>>for Version ($<<UX_Demo.Version.Version>>) and Account dimensions ($<<UX_Demo.Account.Account>>) were added to enable the dynamic change of selected elements.

SELECT
{TM1SubsetToSet( [Region].[Region], 'All Countries')} ON COLUMNS,
{TM1FILTERBYLEVEL({[Account].[Account].Members},
1 )} ON ROWS
FROM [General Ledger]
WHERE (
 [Period].[Period].[$<<UX_Demo.Period.Period>>],
 [General Ledger Measure].[General Ledger Measure].[Amount],
 [Department].[Department].[1],
 [Currency].[Currency].[Local],
 [Year].[Year].[2012],
 [Version].[Version].[$<<UX_Demo.Version.Version>>]
)

Period and Version dimension where defined dynamically with the use of settings service placeholder to facilitate dynamic data update based on selected value.

WITH
MEMBER [Region].[Region].[All Countries SUM] AS
Sum(TM1SubsetToSet( [Region].[Region], "All Countries" ) )
SELECT {[Region].[Region].[ All Countries SUM],{TM1SubsetToSet( [Region].[Region], "All Countries")}} ON COLUMNS,
 NON EMPTY {TM1FILTERBYLEVEL(
{TM1ToggleExpandMode({[Account].[Account].Members}, EXPAND_BELOW )},
1 )} ON ROWS
FROM [General Ledger]
WHERE (
 [Period].[Period].[$<<UX_Demo.Period.Period>>],
 [General Ledger Measure].[General Ledger Measure].[Amount],
 [Department].[Department].[1],
 [Currency].[Currency].[Local],
 [Year].[Year].[2012],
 [Version].[Version].[$<<UX_Demo.Version.Version>>]
)

Using WITH MEMBER query you added an additional column, which is not part of the cube, that will show the sum of previously selected elements from the Region dimension (sum of all elements from the “All Countries” subset).