Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

Approach: “IMA-DRC”

Please see the DRC Vectors section on DRC Vectors length and density.

IMA-DRC: Dataset Size Breakdown

WITH
 Member [Measures].[Trades] AS Count(
  Descendants(
    [Booking].[Trades].CurrentMember,
    [Booking].[Trades].[TradeId]
  ),
  EXCLUDEEMPTY
), FORMAT_STRING = "#,###"
 Member [Measures].[Obligors] AS Count(
  Descendants(
    [Default Risk Charge].[DRC Obligor].CurrentMember,
    [Default Risk Charge].[DRC Obligor].[DRC Obligor]
  ),
  EXCLUDEEMPTY
), FORMAT_STRING = "#,###"
SELECT
  NON EMPTY {
    [Measures].[contributors.COUNT],
    [Measures].[Trades],
    [Measures].[Obligors]
  } ON COLUMNS
  FROM [IMADRCCube]
Fact LevelSmall Dataset FactsMedium Dataset FactsLarge Dataset Facts
Obligors24,90137,30949,651
Trades296,025577,1271,124,400
Count440,461861,2631,683,211

IMA-DRC: Environment Memory Usage

Heap Memory Usage

CPUsSmall DatasetMedium DatasetLarge Dataset
Average30.62 GiB41.62 GiB50.93 GiB

Direct Memory Usage

CPUsSmall DatasetMedium DatasetLarge Dataset
Average72.46 GiB121.35 GiB183.56 GiB

IMA-DRC: Initial Data Load Times

Number Of CPUsSmall DatasetMedium DatasetLarge Dataset
1630 Min 9 Sec29 Min 58 Sec1 Hour 6 Min 15 Sec
3214 Min 49 Sec25 Min 58 SecN/A
6413 Min 10 Sec23 Min 52 SecN/A

Approach: “SA-SBM”

SA-SBM: Dataset Size Breakdown

WITH
 Member [Measures].[Trades] AS Count(
  Descendants(
    [Booking].[Trades].CurrentMember,
    [Booking].[Trades].[TradeId]
  ),
  EXCLUDEEMPTY
), FORMAT_STRING = "#,###"
 Member [Measures].[Risk Factors] AS Count(
  Descendants(
    [Risk].[Risk Factors].CurrentMember,
    [Risk].[Risk Factors].[Risk Factor]
  ),
  EXCLUDEEMPTY
), FORMAT_STRING = "#,###"
 Member [Measures].[Underlyings] AS Count(
  Descendants(
    [Market Data].[Underlying].CurrentMember,
    [Market Data].[Underlying].[Underlying]
  ),
  EXCLUDEEMPTY
), FORMAT_STRING = "#,###"
SELECT
  NON EMPTY {
    [Measures].[contributors.COUNT],
    [Measures].[Trades],
    [Measures].[Risk Factors],
    [Measures].[Underlyings]
  } ON COLUMNS
  FROM (
    SELECT
    Except(
      [Risk].[Risk Measures].[Risk Measure].Members,
      {
        [Risk].[Risk Measures].[ALL].[AllMember].[DRC]
      }
    ) ON COLUMNS
    FROM [StandardisedApproachCube]
  )
Number Of CPUsSmall DatasetMedium DatasetLarge Dataset
160.02 Sec0.02 Sec0.02 Sec
320.02 Sec0.02 SecN/A
640.02 Sec0.02 SecN/A

SA-SBM: Environment Memory Usage

Heap Memory Usage

CPUsSmall DatasetMedium DatasetLarge Dataset
Average8.60 GiB8.20 GiB14.85 GiB

Direct Memory Usage

CPUsSmall DatasetMedium DatasetLarge Dataset
Average50.82 GiB87.66 GiB167.34 GiB

SA-DRC: Environment Memory Usage

Heap Memory Usage

CPUsSmall DatasetMedium DatasetLarge Dataset
Average10.23 GiB17.54 GiB30.69 GiB

Direct Memory Usage

CPUsSmall DatasetMedium DatasetLarge Dataset
Average18.86 GiB37.16 GiB73.87 GiB

SA-DRC: Initial Data Load Times

Number Of CPUsSmall DatasetMedium DatasetLarge Dataset
161 Min 37 Sec3 Min 18 Sec5 Min 52 Sec
322 Min 6 Sec3 Min 18 Sec7 Min 15 Sec
641 Min 23 Sec3 Min 20 Sec5 Min 14 Sec