I do wown a copy of PivotCubeVCL and get the message "Could not load dimension data!" when I run the program.
I have just 1 SQL SERVER 2000 FACT TABLE and use ADO to read data.
I have the following fields:
CREATE TABLE [dbo].[Custo] (
-- DIMENSIONS
[Tipo] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[Rede] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[Periodo] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[Localidade] [varchar] (10) COLLATE Latin1_General_CI_AS NULL ,
[Idade] [varchar] (20) COLLATE Latin1_General_CI_AS NULL ,
-- MEASURES
[MED1] [numeric](9, 2) NULL ,
[DES1] [numeric](9, 2) NULL ,
[OCO1] [int] NULL ,
[FRE1] [numeric](9, 2) NULL ,
[MED2] [numeric](9, 2) NULL ,
[DES2] [numeric](9, 2) NULL ,
[OCO2] [int] NULL ,
[FRE2] [numeric](9, 2) NULL ,
[MED3] [numeric](9, 2) NULL ,
[DES3] [numeric](9, 2) NULL ,
[OCO3] [int] NULL ,
[FRE3] [numeric](9, 2) NULL
) ON [PRIMARY]
GO
As dimensions have indexes.
What is happening ?
Thanks