dbTalk Databases Forums  

Semiadditive Meassures as in Essbase

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


Discuss Semiadditive Meassures as in Essbase in the microsoft.public.sqlserver.olap forum.



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

Default Semiadditive Meassures as in Essbase - 08-04-2004 , 07:54 PM






Hello Group:

Do anybody have idea of how to manage semiadditive meassures in an AS2000
cube?.

Thinks like:

1. when a member does not adds up to itīs parent
2. a shared member
3. a member that comes after a calculation (division) of another two member
and it is shown at the same level in a dimension

Thanks in advanced!



Reply With Quote
  #2  
Old   
Deepak Puri
 
Posts: n/a

Default Re: Semiadditive Meassures as in Essbase - 08-04-2004 , 09:12 PM






This Microsoft paper should help you, though there are also more
specific issues when converting from Essbase to AS:

http://msdn.microsoft.com/library/de.../en-us/dnsql2k
/html/semiadd2.asp
Quote:
Analysis Services: Semiadditive Measures and Inventory Snapshots

Amir Netz
Microsoft Corporation

Updated May 18, 2004

Applies to:
Microsoft SQL Server 2000
Microsoft SQL Server 2000 Analysis Services

Summary: Focusing on a classic inventory problem, this article describes
the implementation techniques of semiadditive measures in online
analytical processing. (10 printed pages)
...
Quote:

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


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.