dbTalk Databases Forums  

Calculated Member Builder

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


Discuss Calculated Member Builder in the microsoft.public.sqlserver.olap forum.



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

Default Calculated Member Builder - 11-08-2006 , 05:09 PM






First I'd like to say I'm completely ignorant when it comes to I OLAP/MDX
concepts, I'm a transactional guy, so please bear with me.. I have a pretty
simple question, I think.. I have a calculated member that uses an expression
that calls the ClosingPeriod function, I read the documentation and kind of
follow the purpose of the function but am a little confused about syntax..
Here's the expression.

(ClosingPeriod([Calendar Year Month], [Date].[Calendar].CurrentMember),
[Measures].[Monaco Inventory Units])

There appears to be two function calls at play here, one to ClosingPeriod
and another (implicit call..??) to something else... So here's the call to
ClosingPeriod..
ClosingPeriod([Calendar Year Month], [Date].[Calendar].CurrentMember), then
here's the call to the other function..

("return value of ClosingPeriod", [Measures].[Monaco Inventory Units])

Is this an implied function call...? What are the parameters and where can I
find the documentation about this...?

Thanks,

Dan


Reply With Quote
  #2  
Old   
yongli
 
Posts: n/a

Default RE: Calculated Member Builder - 11-08-2006 , 11:18 PM






There is only one function in your case that is ClosingPeriod() which return
your time dimension member

The (closingperiod(), [Measures].[]) is the tuple expression which is
heavily used in the MDX. The above expression returns the measure for the
time period determined by closingPeriod().

"Alien2_51" wrote:

Quote:
First I'd like to say I'm completely ignorant when it comes to I OLAP/MDX
concepts, I'm a transactional guy, so please bear with me.. I have a pretty
simple question, I think.. I have a calculated member that uses an expression
that calls the ClosingPeriod function, I read the documentation and kind of
follow the purpose of the function but am a little confused about syntax..
Here's the expression.

(ClosingPeriod([Calendar Year Month], [Date].[Calendar].CurrentMember),
[Measures].[Monaco Inventory Units])

There appears to be two function calls at play here, one to ClosingPeriod
and another (implicit call..??) to something else... So here's the call to
ClosingPeriod..
ClosingPeriod([Calendar Year Month], [Date].[Calendar].CurrentMember), then
here's the call to the other function..

("return value of ClosingPeriod", [Measures].[Monaco Inventory Units])

Is this an implied function call...? What are the parameters and where can I
find the documentation about this...?

Thanks,

Dan


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.