BI Blend Database Table Creation and Structure
The output of BI Blend is an SQL Database table in a Column Store Index format. These are read only fact tables, optimized for reporting by having a high level of compression. The data is highly structured, containing the parent member values, much like Cubes. These tables do not need to be pre-defined or configured. The BI Blend process will create the data tables and corresponding error table automatically.