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