Calulated Field in Portfolio Analyzer views

[ST]

I know how to use the calculated fields to display an S-curve for a measure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure? ie., I would like the display the
total cost accross all time periods. Is this possible? If so, what would be
the syntax I need to use?

 

[Mike Mahoney]

I know how to use the calculated fields to display an S-curve for a measure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure?  ie., I would like the displaythe
total cost accross all time periods.  Is this possible?  If so, what would be
the syntax I need to use?

ST

Doesn't the Grand Total column do this for you?

Mike

 

[ST]

Hi Mike,

I need to plot that value so that it is shown in the chart accross all
periods displayed. Do you know of any way to do that?

/Spir Theopoulos.

I know how to use the calculated fields to display an S-curve for a measure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure? ie., I would like the display the
total cost accross all time periods. Is this possible? If so, what would be
the syntax I need to use?

ST

Doesn't the Grand Total column do this for you?

Mike

 

[ST]

Hi Folks,

Eurika! I found what I was looking for "BUT" I need your help to see if I
can optimize it.

Is there some wild card that I can use to avoid having to explicitly write
out the years? I want all all the 'years', at the moment I only know how to
get the information by writing the out each year like this:

Sum
(
{
[Time].[Year].&[2008],
[Time].[Year].&[2009],
[Time].[Year].&[2010]
},
[Measures].[Task Actual Cost]
)


/Spiro Theopoulos.

Hi Mike,

I need to plot that value so that it is shown in the chart accross all
periods displayed. Do you know of any way to do that?

/Spir Theopoulos.

I know how to use the calculated fields to display an S-curve for a measure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure? ie., I would like the display the
total cost accross all time periods. Is this possible? If so, what would be
the syntax I need to use?

ST

Doesn't the Grand Total column do this for you?

Mike

 

[Mike Mahoney]

Hi Folks,

Eurika!  I found what I was looking for "BUT" I need your help to see if I
can optimize it.  

Is there some wild card that I can use to avoid having to explicitly write
out the years?  I want all all the 'years', at the moment I only know how to
get the information by writing the out each year like this:

Sum
(
        {
          [Time].[Year].&[2008],
          [Time].[Year].&[2009],
          [Time].[Year].&[2010]
         },
          [Measures].[Task Actual Cost]
)

/Spiro Theopoulos.

Hi Mike,

I need to plot that value so that it is shown in the chart accross all
periods displayed.  Do you know of any way to do that?

/Spir Theopoulos.

I know how to use the calculated fields to display an S-curve for ameasure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure?  ie., I would like the display the
total cost accross all time periods.  Is this possible?  If so,what would be
the syntax I need to use?
ST
Doesn't the Grand Total column do this for you?
Mike- Hide quoted text -

- Show quoted text -

Hi Spiro

Try this:
sum([Time].Levels(0),[Measures].[Work])

regards

Mike

 

[ST]

Hi Mike,

Nope.

sum([Time].Levels(0),[Measures].[Work])

Does not work.

/Spiro.

Hi Folks,

Eurika! I found what I was looking for "BUT" I need your help to see if I
can optimize it.

Is there some wild card that I can use to avoid having to explicitly write
out the years? I want all all the 'years', at the moment I only know how to
get the information by writing the out each year like this:

Sum
(
{
[Time].[Year].&[2008],
[Time].[Year].&[2009],
[Time].[Year].&[2010]
},
[Measures].[Task Actual Cost]
)

/Spiro Theopoulos.

Hi Mike,

I need to plot that value so that it is shown in the chart accross all
periods displayed. Do you know of any way to do that?

/Spir Theopoulos.

"Mike Mahoney" wrote:

I know how to use the calculated fields to display an S-curve for a measure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure? ie., I would like the display the
total cost accross all time periods. Is this possible? If so, what would be
the syntax I need to use?

ST

Doesn't the Grand Total column do this for you?

Mike- Hide quoted text -

- Show quoted text -

Hi Spiro

Try this:
sum([Time].Levels(0),[Measures].[Work])

regards

Mike

 

[mahoney.t0]

Hi Mike,

Nope.  

sum([Time].Levels(0),[Measures].[Work])

Does not work.

/Spiro.

Hi Folks,
Eurika!  I found what I was looking for "BUT" I need your help to see if I
can optimize it.  
Is there some wild card that I can use to avoid having to explicitly write
out the years?  I want all all the 'years', at the moment I only know how to
get the information by writing the out each year like this:
Sum
(
        {
          [Time].[Year].&[2008],
          [Time].[Year].&[2009],
          [Time].[Year].&[2010]
         },
          [Measures].[Task Actual Cost]
)
/Spiro Theopoulos.
:
Hi Mike,
I need to plot that value so that it is shown in the chart accross all
periods displayed.  Do you know of any way to do that?
/Spir Theopoulos.
:
I know how to use the calculated fields to display an S-curve for a measure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure?  ie., I would like the display the
total cost accross all time periods.  Is this possible?  Ifso, what would be
the syntax I need to use?
ST
Doesn't the Grand Total column do this for you?
Mike- Hide quoted text -
- Show quoted text -

Hi Spiro

Try this:
sum([Time].Levels(0),[Measures].[Work])

regards

Mike- Hide quoted text -

- Show quoted text -

Strange I got a result but am in PS2007 using SQL AS 2005.

regds

Mike

 

[ST]

I found it!

Sum({[Time].[Year].Members},[Measures].[and you put your measure here!])

Thanks,

/Spiro Theopoulos

Hi Mike,

Nope.

sum([Time].Levels(0),[Measures].[Work])

Does not work.

/Spiro.

Hi Folks,

Eurika! I found what I was looking for "BUT" I need your help to see if I
can optimize it.

Is there some wild card that I can use to avoid having to explicitly write
out the years? I want all all the 'years', at the moment I only know how to
get the information by writing the out each year like this:

Sum
(
{
[Time].[Year].&[2008],
[Time].[Year].&[2009],
[Time].[Year].&[2010]
},
[Measures].[Task Actual Cost]
)

/Spiro Theopoulos.

:
Hi Mike,

I need to plot that value so that it is shown in the chart accross all
periods displayed. Do you know of any way to do that?

/Spir Theopoulos.

"Mike Mahoney" wrote:

I know how to use the calculated fields to display an S-curve for a measure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure? ie., I would like the display the
total cost accross all time periods. Is this possible? If so, what would be
the syntax I need to use?

ST

Doesn't the Grand Total column do this for you?

Mike- Hide quoted text -

- Show quoted text -

Hi Spiro

Try this:
sum([Time].Levels(0),[Measures].[Work])

regards

Mike- Hide quoted text -

- Show quoted text -

Strange I got a result but am in PS2007 using SQL AS 2005.

regds

Mike

 

[ST]

PS... this was using PS 2003

Hi Mike,

Nope.

sum([Time].Levels(0),[Measures].[Work])

Does not work.

/Spiro.

Hi Folks,

Eurika! I found what I was looking for "BUT" I need your help to see if I
can optimize it.

Is there some wild card that I can use to avoid having to explicitly write
out the years? I want all all the 'years', at the moment I only know how to
get the information by writing the out each year like this:

Sum
(
{
[Time].[Year].&[2008],
[Time].[Year].&[2009],
[Time].[Year].&[2010]
},
[Measures].[Task Actual Cost]
)

/Spiro Theopoulos.

:
Hi Mike,

I need to plot that value so that it is shown in the chart accross all
periods displayed. Do you know of any way to do that?

/Spir Theopoulos.

"Mike Mahoney" wrote:

I know how to use the calculated fields to display an S-curve for a measure
over time (eg., Sum(PeriodsToDate([time].[all],[measure].[...])), but is it
possible to get the total for a measure? ie., I would like the display the
total cost accross all time periods. Is this possible? If so, what would be
the syntax I need to use?

ST

Doesn't the Grand Total column do this for you?

Mike- Hide quoted text -

- Show quoted text -

Hi Spiro

Try this:
sum([Time].Levels(0),[Measures].[Work])

regards

Mike- Hide quoted text -

- Show quoted text -

Strange I got a result but am in PS2007 using SQL AS 2005.

regds

Mike