About Factdata in Cubes

 

A PowerOLAP database can support either String or Numeric Fact Data in any cell at the intersection of Dimension members. As you will see, when you create a Cube you can specify whether it can contain only numeric data.

Once a Cube is created, it can be populated with Fact Data in the following ways:

  • Typing or copying numeric values or ASCII strings into a Slice
    —entering data directly in to the Slice (see Section on, Working with Slices).
  • Typing or copying numeric values or ASCII strings into a dynamically connected Excel worksheet (see Section on, Excel Integration).
  • Using PowerOLAP’s import features (see Section on, Import and Export).
  • Via Comma-Delimited Value text file imported through Excel (see topic Import From a Tab-Delimited Text File in Excel in Section Import and Export).
  • Using the Cube Transfer feature (discussed in this section).
  • Via Cube Formulas (see next section, Formulas).
  • Via PowerOLAP’s OLAP Exchange® component (see the OLAP Exchange® section).
  • Via PowerOLAP’s Synchronization Server component (see the Synchronization Server section).