dbTalk Databases Forums  

Newbie problem

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


Discuss Newbie problem in the microsoft.public.sqlserver.olap forum.



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

Default Newbie problem - 07-13-2004 , 12:45 PM






Hi all,
I have a bube like this:

2003 Sales 2004 Sales Dif. 2004-2003 Percent diff
(calc. member) (calc member)
Product a 1000 2000 1000 100 %
Product b 100 150 50 50 %
--------- ------ ------ ------ ------
totals 1100 2150 1150 150 %
ok ok ok wrong!!

The calculated memeber percent diff is defined as:
(([PeriodoTrimestre].[Totale PeriodoTrimestre].[2004] -
[PeriodoTrimestre].[Totale PeriodoTrimestre].[2003]) /
[PeriodoTrimestre].[Totale PeriodoTrimestre].[2003])*100

What's the problem ?
How I can solve it ?
Thanks
Gianluca

Reply With Quote
  #2  
Old   
Michael Barrett Jensen
 
Posts: n/a

Default Re: Newbie problem - 07-13-2004 , 04:08 PM






How and where are you calculating the totals?

--
Michael

"Gianluca" <gianluca.centulani (AT) jjsoft (DOT) it> wrote

Quote:
Hi all,
I have a bube like this:

2003 Sales 2004 Sales Dif. 2004-2003 Percent diff
(calc. member) (calc member)
Product a 1000 2000 1000 100 %
Product b 100 150 50 50 %
--------- ------ ------ ------ ------
totals 1100 2150 1150 150 %
ok ok ok wrong!!

The calculated memeber percent diff is defined as:
(([PeriodoTrimestre].[Totale PeriodoTrimestre].[2004] -
[PeriodoTrimestre].[Totale PeriodoTrimestre].[2003]) /
[PeriodoTrimestre].[Totale PeriodoTrimestre].[2003])*100

What's the problem ?
How I can solve it ?
Thanks
Gianluca



Reply With Quote
  #3  
Old   
AshVsAOD
 
Posts: n/a

Default Re: Newbie problem - 07-13-2004 , 08:19 PM



Try changing the solve order of the percentage change calculated member to
be higher. Default is 0. Make it say 10.

On the Advanced Tab of the calculated member you should see Solve Order as
an option.
"Gianluca" <gianluca.centulani (AT) jjsoft (DOT) it> wrote

Quote:
Hi all,
I have a bube like this:

2003 Sales 2004 Sales Dif. 2004-2003 Percent diff
(calc. member) (calc member)
Product a 1000 2000 1000 100 %
Product b 100 150 50 50 %
--------- ------ ------ ------ ------
totals 1100 2150 1150 150 %
ok ok ok wrong!!

The calculated memeber percent diff is defined as:
(([PeriodoTrimestre].[Totale PeriodoTrimestre].[2004] -
[PeriodoTrimestre].[Totale PeriodoTrimestre].[2003]) /
[PeriodoTrimestre].[Totale PeriodoTrimestre].[2003])*100

What's the problem ?
How I can solve it ?
Thanks
Gianluca



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.