dbTalk Databases Forums  

Time Dimension in AS2005

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


Discuss Time Dimension in AS2005 in the microsoft.public.sqlserver.olap forum.



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

Default Time Dimension in AS2005 - 10-25-2006 , 10:32 PM






Dear all,
Actually, I have posted these questios before. It seems that no one reply.
Are the following questions problems in AS 2005? They cannot be solved now?
If not, please help me. It's really an urgent matter. Thanks!

1. Year to Date
This field value is "#value". The error message is "The following system
error occured: Type Mismatch..MDXScript (Cube Name) (12,5) There is a Type
mismatch for the '-' operator." I tried to search for the 12th row and the
5th columns, I found that it is the MDX expression for Net Sales:
"[Measures].[Sales]-[Measures].[Discount]". What happen to my expression?

2. Last Year
This field can capture correct last year figures at month level. However, it
is wrong at year level. For example, at year level, the current figure is the
sum from 2006 Jan to 2006 Oct(up to 2006-10-16). However, the last year
figure is the sum from 2005 Jan to 2005 Dec. These two figures are not
comparable! I think that the last year figure should be the sum from 2005 Jan
to Oct (up to 2005-10-16). How to solve this problem?

Thanks!


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.