How to view S-Curve in PS 2007 and entering the formula

[aSoundMind]

Hi Guys,

I have Project Server 2007 installed with SQL Server 2005 and its SP2
and
also Analysis Service. The cube has been build successfully. My
question is I
want to view a S-Curve graph from the analyser view.

I came accross this link which explained how to do it in PS 2003. But
I am
stucked on this part

http://articles.techrepublic.com.com/5100-6329_11-5030578.html

"Figure E shows the Name field and the formula field already filled
in. In
this example, we'll call this new calculated total WTD, for Work To
Date.
Paste the following formula into your dialog box:
Sum(PeriodsToDate([Time].[All]),Work)"

simply because I don't know where are the buttons now. In PS 2003
it's
obvious the button is on top of the graph. So please guide me on how
to
CREATE and VIEW S-Curve in PS2007. Any help is highly appreciated.
Thanks in
advance.

Regards,
Jack

 

[Marc Soester [MVP]]

Hi Jack,

The functionality is actually exactly the same since they are still 03
Office Web Components. All you need to do is to tick on "display toolbar"
this will show you the icon you are after.

I hope this helps
Marc

 

[Vadim Gerya, PMP]

Hi Jack !

1)
according to article you mentioned please use the following MDX formula (for
SQL2005 Analysis) :
---
Aggregate(PeriodsToDate([Time].[year]), [Measures].[Work])
---
or easy one
---
Aggregate([Time].[year], [Measures].[Work])
---

2)
Other way - in 2007 you can create calculated member directly in Cube
configuration settings (Server Settings->Cube->Configuration).
Select Portfolio_Analyser cube and add measure S_WORK with formula above.

After cube rebulding you may select S_WORK measure to display in any Analys
view

have a nice day !

 

[Vadim Gerya, PMP]

Sorry Jack,
second formula is not correct.
Use only
Aggregate(PeriodsToDate([Time].[year]), [Measures].[Work])

--
Vadim Gerya, PMP

Hi Jack !

1)
according to article you mentioned please use the following MDX formula (for
SQL2005 Analysis) :
---
Aggregate(PeriodsToDate([Time].[year]), [Measures].[Work])
---
or easy one
---
Aggregate([Time].[year], [Measures].[Work])
---

2)
Other way - in 2007 you can create calculated member directly in Cube
configuration settings (Server Settings->Cube->Configuration).
Select Portfolio_Analyser cube and add measure S_WORK with formula above.

After cube rebulding you may select S_WORK measure to display in any Analys
view

have a nice day !

--
Vadim Gerya, PMP

Hi Guys,

I have Project Server 2007 installed with SQL Server 2005 and its SP2
and
also Analysis Service. The cube has been build successfully. My
question is I
want to view a S-Curve graph from the analyser view.

I came accross this link which explained how to do it in PS 2003. But
I am
stucked on this part

http://articles.techrepublic.com.com/5100-6329_11-5030578.html

"Figure E shows the Name field and the formula field already filled
in. In
this example, we'll call this new calculated total WTD, for Work To
Date.
Paste the following formula into your dialog box:
Sum(PeriodsToDate([Time].[All]),Work)"

simply because I don't know where are the buttons now. In PS 2003
it's
obvious the button is on top of the graph. So please guide me on how
to
CREATE and VIEW S-Curve in PS2007. Any help is highly appreciated.
Thanks in
advance.

Regards,
Jack

 

[Mike]

Sorry Jack,
second formula is not correct.
Use only
Aggregate(PeriodsToDate([Time].[year]), [Measures].[Work])

--
Vadim Gerya, PMP

Hi Jack !

1)
according to article you mentioned please use the following MDX formula (for
SQL2005 Analysis) :

2)
Other way - in 2007 you can create calculated member directly in Cube
configuration settings (Server Settings->Cube->Configuration).
Select Portfolio_Analyser cube and add measure S_WORK with formula above.

After cube rebulding you may select S_WORK measure to display in any Analys
view

have a nice day !

Hi Guys,
I have Project Server 2007 installed with SQL Server 2005 and its SP2
and
also Analysis Service. The cube has been build successfully. My
question is I
want to view a S-Curve graph from the analyser view.
I came accross this link which explained how to do it in PS 2003. But
I am
stucked on this part
http://articles.techrepublic.com.com/5100-6329_11-5030578.html
"Figure E shows the Name field and the formula field already filled
in. In
this example, we'll call this new calculated total WTD, for Work To
Date.
Paste the following formula into your dialog box:
Sum(PeriodsToDate([Time].[All]),Work)"
simply because I don't know where are the buttons now. In PS 2003
it's
obvious the button is on top of the graph. So please guide me on how
to
CREATE and VIEW S-Curve in PS2007. Any help is highly appreciated.
Thanks in
advance.
Regards,
Jack- Hide quoted text -

- Show quoted text -

This is fine if your project begins and ends in a single year. How do
you generate an SCurve where projects are multi-year?

Mike

 

[aSoundMind]

Sorry Jack,
second formula is not correct.
Use only
Aggregate(PeriodsToDate([Time].[year]), [Measures].[Work])

Hi Jack !
1)
according to article you mentioned please use the following MDX formula (for
SQL2005 Analysis) :
---
Aggregate(PeriodsToDate([Time].[year]), [Measures].[Work])
---
or easy one
---
Aggregate([Time].[year], [Measures].[Work])
---
2)
Other way - in 2007 you can create calculated member directly in Cube
configuration settings (Server Settings->Cube->Configuration).
Select Portfolio_Analyser cube and add measure S_WORK with formula above.
After cube rebulding you may select S_WORK measure to display in any Analys
view
have a nice day !
--
Vadim Gerya, PMP
:
Hi Guys,
I have Project Server 2007 installed with SQL Server 2005 and its SP2
and
also Analysis Service. The cube has been build successfully. My
question is I
want to view a S-Curve graph from the analyser view.
I came accross this link which explained how to do it in PS 2003. But
I am
stucked on this part
http://articles.techrepublic.com.com/5100-6329_11-5030578.html
"Figure E shows the Name field and the formula field already filled
in. In
this example, we'll call this new calculated total WTD, for Work To
Date.
Paste the following formula into your dialog box:
Sum(PeriodsToDate([Time].[All]),Work)"
simply because I don't know where are the buttons now. In PS 2003
it's
obvious the button is on top of the graph. So please guide me on how
to
CREATE and VIEW S-Curve in PS2007. Any help is highly appreciated.
Thanks in
advance.
Regards,
Jack- Hide quoted text -

- Show quoted text -

This is fine if your project begins and ends in a single year. How do
you generate an SCurve where projects are multi-year?

Mike

Hi Guys,

I really want to try solutions you given but unfortunately my project
server is corrupted due to inappropriate installation of active
directory. I will definitely get back to you soon.

Regards,
Jack