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
  • 1380 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
  • 2502 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
  • 1214 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
  • 1877 Views
  • 0 comments
  • 1 kudos
Best Practices Index
Best Practices

Just here to browse knowledge? This might help!