dbTalk Databases Forums  

Help AS2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Help AS2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JoseMejias_DSO
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.