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).