dbTalk Databases Forums  

Re: How I can to create a variable in a Calculated Member?

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


Discuss Re: How I can to create a variable in a Calculated Member? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Matt Carroll [MS]
 
Posts: n/a

Default Re: How I can to create a variable in a Calculated Member? - 07-11-2003 , 04:49 PM






You can create a hidden calculated member which you then use within your
visible calculated member.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Fernando Budrevicius" <fernando.budrevicius (AT) pirelli (DOT) com.br> wrote in
message news:3dc7efce.0307111035.86a3387 (AT) posting (DOT) google.com...
Quote:
How I can to create a variable in a Calculated Member?

Thanks,
F. Budrevicius



Reply With Quote
  #2  
Old   
Fernando Budrevicius
 
Posts: n/a

Default Re: How I can to create a variable in a Calculated Member? - 07-14-2003 , 02:16 PM






Thanks Carroll for your answer!

How I can attribute values to this hidden calculated member, and can I
use "while" inside a calculated member, how?

Thanks,
F. Budrevicius


"Matt Carroll [MS]" <MattCar (AT) online (DOT) microsoft.com> wrote

Quote:
You can create a hidden calculated member which you then use within your
visible calculated member.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Fernando Budrevicius" <fernando.budrevicius (AT) pirelli (DOT) com.br> wrote in
message news:3dc7efce.0307111035.86a3387 (AT) posting (DOT) google.com...
How I can to create a variable in a Calculated Member?

Thanks,
F. Budrevicius

Reply With Quote
  #3  
Old   
Matt Carroll [MS]
 
Posts: n/a

Default Re: How I can to create a variable in a Calculated Member? - 07-16-2003 , 02:56 PM



In the calculated member definition you can use the expression for the value
you want it to contain. You can't assign to it they way you could in a
procedure language, but this can serve the trick. Looping is not supported
in MDX although the Generate() function can often achieve the desired
results.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Fernando Budrevicius" <fernando.budrevicius (AT) pirelli (DOT) com.br> wrote in
message news:3dc7efce.0307141116.221978ef (AT) posting (DOT) google.com...
Quote:
Thanks Carroll for your answer!

How I can attribute values to this hidden calculated member, and can I
use "while" inside a calculated member, how?

Thanks,
F. Budrevicius


"Matt Carroll [MS]" <MattCar (AT) online (DOT) microsoft.com> wrote

You can create a hidden calculated member which you then use within your
visible calculated member.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Fernando Budrevicius" <fernando.budrevicius (AT) pirelli (DOT) com.br> wrote in
message news:3dc7efce.0307111035.86a3387 (AT) posting (DOT) google.com...
How I can to create a variable in a Calculated Member?

Thanks,
F. Budrevicius



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.