Help AS2005 -
10-05-2006
, 02:26 PM
Hi peope Microsoft,
Actually the cube present the dimension TYPE TIME not ordered, how resolved
this problem? And as I indicate to the system what I using a dimension type
time?
I solved it using the following:
CREATE GLOBAL CUBE [25019] STORAGE 'c:\25019.cub'
FROM [SAM_PREVENTA]
(
MEASURE [SAM_PREVENTA].[MontoReportesFacturados],
MEASURE [SAM_PREVENTA].[MontoPautaFuturaAvisos],
MEASURE [SAM_PREVENTA].[MontoReclamosAprobadosPorFact],
MEASURE [SAM_PREVENTA].[MontoConsumosAvisosPorFacturar],
MEASURE [SAM_PREVENTA].[MontoReclamosEnProceso],
MEASURE [SAM_PREVENTA].[MontoConsumOtrosProducPorFact],
MEASURE [SAM_PREVENTA].[MontoPautaFuturaOtrosProd],
MEASURE [SAM_PREVENTA].[MontoReman_SobregPVanteriores],
DIMENSION [SAM_PREVENTA].[CLIENTE]
(
LEVEL [(All)],
LEVEL [Cliente],
MEMBER [Cliente].[All Cliente].[ADVANCE POS TECHNOLOGY, C.A.]
),
DIMENSION [SAM_PREVENTA].[FechaPublicacion]
(
LEVEL [(All)],
LEVEL [Ano],
LEVEL [Nombre Mes],
LEVEL [Dia],
MEMBER [FechaPublicacion].[All FechaPublicacion].[2005]
),
DIMENSION [SAM_PREVENTA].[FechaFacturacion]
(
LEVEL [(All)],
LEVEL [Nombre Mes]
)
)
Thank You
Jose Luis |