Was this page helpful?

Olap cube processing

    Table of contents
    No headers
    The aggressiveness of the cube processing is based on two elements: 
     
    the number of elements to process and the connection pool.
     
    The number of elements include:
     
    1. The number of dimensions
    2. The number of cubes 
    • The number of fact tables in cubes 
    • The number of partition per fact tables
    • The number of data sources
    •  
    In the NRS/NBI OALP base, we use a single data source and we are partitioned for fact tables more or less aggressively depending on the version: 
     
    In version 2.2.1 
     
    • Two partitions per fact tables for the raw results/messages/statusranges 
     
    In version 3.0.0 
     
    • 24 partitions per fact tables for the raw results/messages/statusranges 

     

    By default we allow 10 simultaneous connections to a data source.

    To tune the aggressiveness of the cube processing you can modify the "maximum Number of connections" parameter of the data source through the data source properties in SSAS.

     

    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    1844 view(s), 2 edit(s) and 1436 character(s)

    Comments

    You must login to post a comment.

    Attach file

    Attachments