• This widget could not be displayed.
  • ">Knowledge
  • This widget could not be displayed.
  • ">Discussions
  • Data & Schemas Knowledgebase
    A solid data foundation leads to analytics. Build that foundation here.
    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    Knowledge Base Articles

    Date Dimension

    Date is a common dimension used in most application deployments.  It is primarily used to roll up data so it can be viewed across a broad time range, facilitating trend analysis.

    calendar.jpg
    VinayR by Employee Alumni
    • 1413 Views
    • 0 comments
    • 0 kudos

    Organizing Business Schemas

    Introduction Business Schemas are a useful way to group content for business users that can be used in one or more dashboards.  They also remove the need to understand all of the underlying data relationships even when they span several source data ...

    Screen Shot 2022-03-11 at 1.36.46 PM.png

    Formula Columns

     An expression can consist of built-in functions, built-in system variables, and other referenceable objects valid for the expression context.

    Screen Shot 2022-03-11 at 1.45.08 PM.png

    Performance of Materialized Views (MV)

    Introduction Incorta Materialized Views are a powerful way to enrich data contained in Incorta tables.  Leveraging Spark's processing engine, Materialized Views (MVs) can be defined to introduce enrichments and advanced analytics to reshape your dat...

    spark.jpg
    Tristan by Employee
    • 2571 Views
    • 0 comments
    • 0 kudos

    Regular vs. Analyzer Views

    Introduction Incorta offers two types of business schema views- regular and analyzer (Runtime or Incorta) views and both are useful to support various use cases. What you should know before reading this article We recommend that you be familiar with...

    tile.jpg

    Using Formula Columns in Business Views

    Introduction A formula column contains an expression that, depending on the expression and the expression context, returns a scalar or an array of values of a specific data type. An expression can consist of built-in functions, built-in system variab...

    Screen Shot 2022-03-03 at 3.11.45 PM.png
    RichC by Employee
    • 1256 Views
    • 0 comments
    • 0 kudos

    Handling Hierarchical Data

    IntroductionIf you need to represent hierarchical data in Incorta, we provide several features that make this data modeling technique easier. Common use cases for hierarchy include HR org chart, chart of accounts, and even your Incorta dashboards' fo...

    hier.jpg
    DustinB by Employee
    • 1925 Views
    • 0 comments
    • 1 kudos
    Best Practices Index
    Best Practices

    Just here to browse knowledge? This might help!