OLAP Question: Date problem!!

[FlavioT]

Hi!!

I've made an OLAP Cube to get data from my Access database.

I use that function infopivotfields (I don't know the name in English... in portuguese is INFODADOSTABELADINÂMICA)

Well... I'd like my Dates not to have those levels the Cube Suggests... I'd like them to be displayed as TEXT...

Do I need to change my database to Text istead of Time???

Please HELP ME!!!


Here is the OLAP (Working but with the LEVELS)

QueryType=OLEDB
Version=1
CommandType=Cube
Connection=Provider=MSOLAP; Initial Catalog=[OCWCube]; CreateCube=CREATE CUBE [OCWCube] ( DIMENSION [Data] TYPE TIME, LEVEL [Tudo] TYPE ALL, LEVEL [Ano] TYPE YEAR, LEVEL [Mês] TYPE MONTH, LEVEL [Dia] TYPE DAY, DIMENSION [Loja], LEVEL [Tudo] TYPE ALL, LEVEL [Loja], MEASURE [Soma de Valor] FUNCTION SUM ); InsertInto=INSERT INTO OCWCube([Data], [Soma de Valor], [Loja].[Loja]) OPTIONS ATTEMPT_DEFER, ATTEMPT_ANALYSIS SELECT Consulta1.Data, Consulta1.Valor, Consulta1.Loja FROM `F:\Funcionarios\Flavio BACKUP\Caixa\Caixa`.Consulta1 Consulta1; Source_DSN="DSN=Banco de dados MS Access;DBQ=F:\Funcionarios\Flavio BACKUP\Caixa\Caixa.mdb;DefaultDir=F:\Funcionarios\Flavio BACKUP\Caixa;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;";
CommandText=OCWCube